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
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