Sharing DB over network multiple servers?

[mcadle]

Does anybody know how to setup an access database so multiple users can access it at the same time over a large network that has multiple servers?

I have three offices that are separated by 35 miles. All of them are on the same network but with different servers. All servers connect to the main server where the backend tables reside. I have enabled everything that I can think of in access to allow the other two offices to connect to the database at the same time. I still have record level locking enabled though. More than two people can access the db at the same time in the same office. I could have 40 people access it in the same office and it would work, but not when one person is in the db in one office and another person attempts to get in from the other office. It says cannot access the database located "path"

I am wondering if it has to do with Novell. All users have rights to the files but I think Novell is restricting Access's ability to allow multi connects. Any thoughts?

 

[The_Doc_Man]

If the BE is on the server that everyone sees, you must have rights on that server to allow shared access. But if the FE is on another server, its rights must ALSO be set up to allow you to use it. Perhaps you need to create a shortcut that opens the DB with explicit addresses in //server/path.path.... format.

No, Novell doesn't stop you from sharing. We used Novell for a long time before we had to switch to Exchange for licensing reasons that are above my pay grade to figure out. Novell never got in the way from a sharing standpoint, though.

Question: Is everyone using the same mdw file and is it also on the server holding the BE database?

Question: Can the end-user workstations directly access this common server? Never mind the three site servers.

 

[mcadle]

yes to both questions. I believe, but I will check in the morning, that it is currently setup as archived access and not shared. THe DB itself is setup as shared access though. My servers are archived. But the group that owns the folder has all rights on all three servers. Everyone can view, create, modify, delete in that folder.

The backend resides on the central server -- the one everybody eventually connects too. The frontends are on their independent site servers.

From there I don't really know.