Connecting to an Access DB over a network

[britt13]

I'm using a Jet 4 connection to an Access DB in VB.NET. The DB is on a network drive along with the EXE. The app runs fine from my developement system, but gives the following error when running from any other workstation installed with the "Framework Packager" runtime:

Application has generated an exception that could not be handled.
Process id=0x114(500), Thread id=0x4fc(1276)

If I move the EXE to the local drive of a workstation but keep the DB on the network drive, it runs just fine. I can also run any other app over the network from any workstation, as long as I'm not connecting to a DB in the app.

I know I have full R/W privileges to the DB, but there is still something I'm missing regarding Security/Permissions, probably the VB app and its connection to the DB.

Any ideas out there?

[Pirate]

Ok , if you are having trouble with the connection string , then you can try the wizard to build it for you (this way you make sure it can verify the connection to the source database is established) , then just copy the connection string generated in the IDE into your variable . It's worth a try .

[britt13]

The connection works just fine on my development system, and on all workstations when the EXE is running on a local drive. The problem only occurs when the EXE is launched from a workstation over the network (the DB is in the same folder as the EXE).