Connect to MS Access db on network server

david.a.libby_265 · September 18, 2009, 9:21am

How do i connect to Ms Access db on a networked server?
Any MS Access db connects fine from my c drive.

Thanks

Dave

david.a.libby_265 · September 18, 2009, 10:34am

Apparently I can connect to the db but, the tables/queries are not showing.

Dave

MichaelG · September 18, 2009, 10:58am

Is there a security file associated with that Access database?

david.a.libby_265 · September 18, 2009, 11:13am

No.
There is a mdw file on my C drive but no security is set.

MichaelG · September 18, 2009, 11:29am

Interesting, does this happen with all Access databases out on the network? I did a quick test here and everything seems to work as expected.

Debbie_Peabody · September 18, 2009, 11:39am

I would copy the MDW file to the network and include that path in your connection in the MDW file attribute. See the Toad Sample Database connection for example.

Debbie

david.a.libby_265 · September 18, 2009, 12:49pm

Now I see that it shows static tbls but not linked tbls. Should it show linked tbls?

MichaelG · September 18, 2009, 2:52pm

Linked tables store DSN connection information. You need to setup the DSN connection information exactly the same on all machines accessing this database.

Thanks.

david.a.libby_265 · September 21, 2009, 9:17am

The linked tbls will show if the Show System Files is checked in the Connect window.

Dave