question about system.mdw

[akinia]

Hi every one

When you create a new system.mdw on your Pc do you need to copy it on the client Pc where you copy your DB ?
I've developped a DB in Access 97 which need to be used by few users. I want to let the DB on the server without access for whom who has not right. It seems to work good with the system.mdw I've created.
Now I've made a copy on every PC users with link tables in order to provide a multiple access simultaneously.
Is it the good way to share an access DB ?
What do I need to do with the system.mdw on the users'Pc beacuse I still want to protect my DB?

Thanks for your answers.

Have a good day :->

Akinia

 

[scriverb]

The system.mdw should be put on your network server in the folder where the back-end database(your tables) resides. This way all users are using the same system.mdw.

To have all users using this common system.mdw file just create a shortcut on the individual PC's with a Target Location of:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\..folder..path.\FEdatabase.MDB" /WRKGRP "g:\..folder..path..\system.mdw"

The above is an example to use and would need to be updated with the path to your databases, database names, and the path to the location of the system.mdw. I hope this helps you understand the setup to use.

Bob Scriver

 

[akinia]

Thanks for your answer Bob.

If the user for example modify the shorcut and remove everything about system.mdw, can he still be able to access de DB ? and with what king of rights ?
Still an another question.
With this shorcut You're telling me that It's no more necessary to make a copy of the DB on the client PC. Am I right ?
I'm in trouble now because I've tried to access the DB on different Pc's silmutaneously but got the message "already in use" on the second Pc which I've tried to connect the DB.

Thanks for your answers

Akinia

 

[tEkHEd]

This is probably because you have the DB setup in "Exclusive Access" mode meaning that only 1 user may access at any one time.

Are you using a /excl switch anywhere?

You may also need to check your MDW configuration for this, the user group that you have created has probably got the Open Exclusive option checked.

 

[scriverb]

tEkHEd is correct in his response. In answer to your first question if you modify the shortcut and eliminate the reference to the system.mdw then the user will be able to open the database with Admin rights.

In answer to your question about making a copy on the client PC, the FE and BE design concept requires that each user have a front-end(FE) application on their PC that is linked to the back-end(BE) application. The BE contains just the dynamic tables that are being shared and updated by the users. The FE contains the static tables, linked tables, queries, forms, modules and reports. Everyone's FE is the same. The reference to the System.mdw in the shortcut directs everyone using the application to logon using the UserID and Password setup that you have created as the programmer for this application. All of the rights for Groups and individual Users are setup in this system.mdw.

Let me know if you need more assistance with this.

Bob Scriver