Member Avatar for faisalmukhtarch

i am using "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\My PC\Desktop\MOMS 3\MOMS2\WindowsApplication2\MOMS.accdb" This is the path to connect with the database. can you one tell me any other way i can use instead of this. I want to use the program on other computers. I tried "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|Data Directory|\MOMS.accdb" and "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & application.startuppath & "\MOMS.accdb"
but it didn't help.

Tell me what connection string i can use.

  • 2 Contributors
  • 1 Reply
  • 191 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

You could keep the database name (fully qualified path and file) in a settings variable like

My.Settings.DatabaseFile

and use the connection string

 "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & My.Settings.DatabaseFile & "MOMS.accdb"

You'd have to prompt for the location on the first run then save that value back into the settings variable for subsequent runs.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.