Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connect to server-based access db help ?

Status
Not open for further replies.

rab54

Programmer
Jan 28, 2004
112
GB
Access Gurus -

I hardly ever use MS Access so please bear with me ;-)

We have a 3rd-party app that connects to an access db - it works fine on my local machine -

However I want it to sit on the server so that a number of client machines can connect to it simultaneously (read-only)

I have put the connect string in to a registry-key (that the app calls)

driver={Microsoft Access Driver (*.mdb)};Dbq="\\server\dir\dir1\dir2\Quote.mdb;"

I can connect from the command line using the above string ok - yet the app throws an Automation Error !

Any ideas or pointers would be most helpful -

cheers guys

Rab
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top