Accessing Access over a network

[jaf893]

For users to access Access over a network is it just a case of:

Storing the .mdb file on some shared network space and giving everyone usernames and passwords?

 

[spacepro]

Do a search of the forum, you will find loads of posts regarding networks.

Ideally for performance you should split the db into front/backend. Put the backend on the network and the frontend on the users pc.

There are different opinions on what should you do, but it determines on what your network setup is like. Do a search and always backup your db before trying any solutions out.

Andy

 

[The_Doc_Man]

Storing the .mdb file on some shared network space and giving everyone usernames and passwords?

In the simplest cases, yes. When you have a gung-ho domain administrator for your network, maybe no.

If your network security folks are intrusive in how they run the site's internal network, this is what you need.

1. Be sure that you put your .MDB file and .MDW file on the same shared network space.

2. Be sure that everyone uses the .MDW file.

3. Be sure that everyone has a unique account. BUT don't give ANY of them rights by account name. Instead, based on the roles they play, create groups representing those roles, then assign the users to the role-groups.

4. Don't name the .MDW file SYSTEM.MDW - use another name. Like maybe the name of the .MDB file.

5. Get your domain administrator to define a single domain-wide group for all your users. This is NOT a Workgroup group. It is a Windows group. Give the group Windows "Modify" rights on the folder and set up permission inheritance on that folder and its files. Then don't share the folder with any other application.

Search this forum for issues with WorkGroup security, Securing a Database, and other similar topic names. Even if you limit the search to the last year (which you should NOT do), you would get a pot-load of references.