Running Access across network

[Guest]

Hi,

I have developed an Access application in Access 2000. When I run the
application from my local machine it runs fine. However, when I copy the MDB
file to a location on the server and have a user try to run it from that
location, the forms open but nothing are displayed on them for the user.

Anyone have any ideas how to fix this?

Thanks,

 

[Guest]

All users of the database must have at least read, write, and modify
privileges to the folder holding the database file. Not just the database
..mdb file, but the entire folder.

 

[Guest]

Jerry,

Thanks for the reply.

All my forms except one won't work correctly. I have the same access rights
to the folder on the network as someone else in my group and I can run the
application over the network no problem but when he tries run the application
and open one of my forms the form opens but nothing is displayed on it.

Also when he tries to run my application he gets a message telling him the
application has read only access.

i verified our network access rights and they are identical.

Kevin

 

[Guest]

Jerry,

You were right about the folder access issue.

Thanks for your help.

Users need full access to that folder in order to run the application ok.

Kevin

 

[Arvin Meyer [MVP]]

Besides need Read, Write, Modify, and Delete permissions, you need to split
your database and put ONLY the data back-end on the server. A copy of the
connected front-end with linked tables needs to bee on EACH user's
workstation. Users sharing a front-end file are asking for a corruption to
happen. It eventually will. See:

http://www.granite.ab.ca/access/splitapp/overview.htm