invalid path to tables

[gtupling]

This is my first post in this forum so please be patient with me.

My issue is an existing database in ms Access 2007, it runs great on the local computer, but now we are trying to share the database with other computers in the office across the network. We get an error when trying to open the database from any machine over the network

windows 7 home premium 64bit is hosting the database, trying to access the database across the network from windows 7 ultimate 32bit. I have mapped a drive to the shared folder of the database and added the network location to the trusted locations, I then placed a shortcut on the desktop to the database files, but I get an error that access can't find the tables, showing the correct path to the tables. "z:\database\blah.mdb" What am I missing?
I can open access and then open the tables from within access in table view, but in form view I get a blank page.

I'll be at the office in about two hours.
Thanks in advance for any help.
Glen

 

[Deleted member 125916]

Hi Gtupling,

I have my databases also on share network drives and from my experience these are the issues that can happen:

• Other user has the share mapped under another drive letter/path
• Share is disconnected at startup

Also, instead of using the drive letter as you mapped them on your PC, if the network allows it ofcourse, can be used in Access as //domain.com/path/file.txt

Hope this helps you a bit!

 

[jdraw]

Also, have you split your database. Should do -- backend on shared location. Separate front end on each user's pc/workstation.

see http://office.microsoft.com/en-us/access-help/split-an-access-database-HA010342026.aspx

 

[mcclunyboy]

Consider splitting the database:
http://office.microsoft.com/en-gb/access-help/split-an-access-database-HA010342026.aspx

It creates two parts to the database, the front (forms etc) and the back (tables).

That way you can link each "Front End" copy of the database seperately - pointing it to the location you need. Of course if you modify the "Front End" copy of the database you will need to copy it to the other machines every time.

The "Back End" is basically just the tables.