Database connection string problem

[JohnM]

I apologize. I asked this question yesterday very poorly and in another section. I think this is the correct section.

If the connection string for a database in an app contains SOURCE= "C:\mydatabase..." because C:\ is the local hard drive, How can a user who installs the app to his hard drive that happens to be labeled "D" (as an example). Won't there be an error when he runs the app, and the connection string is looking for"C:\mydatabase.." when it app was installed on "D"? I am new as you can tell. Thank you for your time.
John M

 

[kulrom]

Try this:

Dim ConnectionString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & _
Application.StartUpPath & "\MyDataBase.mdb;User Id=admin;Password=;"

 

[JohnM]

Thank you. I will try this when I get back to my office. I will reply. If this does work, since I used the OLED Adaptor wizard to create the connection, this answer probably means I would have to change the coding created by the wizard, correct?

John M