Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

How do I distribute an .exe with an .mdb access file to users?

Using VC++6, I was able to create an .exe file that connects to an .mdb Access database file, which I used the ODBC Data Source Administrator to add a data source name assigned to it.
The program works fine in my local machine. However when I distributed both the .exe file and the .mbd file to other users they could not execute it, unless they also have to use their ODBC Data Source Administrator to add the database name.

How do I make it transparent to the users so they don't have to do that step? i.e. All they need to do is to execute the .exe file and run it.
0
Volga
Asked:
Volga
2 Solutions
 
jkrCommented:
See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcmfc98/html/_mfcnotes_tn048.asp ("TN048: Writing ODBC Setup and Administration Programs for MFC Database Applications")
0
 
jploegCommented:
Or do it without a datasource, and use a commection string like this:

"ODBC;DRIVER={MICROSOFT ACCESS DIRVER (*.mdb)};DSN='';DBQ=filename;UID=username;PWD=password"
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now