QUOTE(PsychoCoder @ 23 Feb, 2008 - 11:15 AM)
You're going to want to pass in the connection string to
Connect . The easiest way to get your connection string is to create a new text document on your desktop, right-click on the new document and select
Rename. Rename your document to
Connect.udl, then click
Yes on the dialog that follows. Once the UDL file is created double-click it and it will open a
Data Link Properties dialog that looks like this:
On that dialog select
Use connection string like in the image below
Then click the
Build button. It will then walk you through creating a connection string for your Access database file. Once that is complete click the
Test Connection button to ensure it is valid, then copy the text in the
Connection string textbox and use that with
Connect instead of
App.Path & "\TEST.mdb" , like so:
vb
.Connect = "Data Source=Localhost;UID=username;PWD=password;DSQ=DataBaseName;"
Remember to replace the connection string I have in the example with the one you create with the steps above.
15 May, 2008 - 09:33 PM
| 