Association of XYZ.mdw with XYZ.mdb

[Milan]

Hello,

I have this problem. I have created the database called let´s say
XYZ.mdb and have stored user names and permissions to the file
XYZ.mdw. The problem is that all the users use lots of other
databases, each with its own mdw file. I do not know what to do so
that the file XYZ.mdw is automatically activated when user tries to
open XYZ.mdb.

Thank you very much for your help.

Milan

 

[Joan Wild]

Hello,

I have this problem. I have created the database called let´s say
XYZ.mdb and have stored user names and permissions to the file
XYZ.mdw.

I realize you have provided fictitious names, but ensure that your mdb and
mdw do not have the same filenames; both need to create a ldb file.

The problem is that all the users use lots of other
databases, each with its own mdw file. I do not know what to do so
that the file XYZ.mdw is automatically activated when user tries to
open XYZ.mdb.

You provide a desktop shortcut that uses the appropriate mdw instead of the
user's default mdw. The shortcut target would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

They should not be able to even open your secure mdb unless they are using
the correct mdw.

 

[Milan]

Thank you very much for your answer. I have created the file "Start of
XYZmdb.bat" which runs your command in the command-line. It works
perfectly. But I would like to ask you yet

- which command should I use in the bat file to close the DOS window
when the command is already executed
- is it possible somehow to forbid the user to open the mdb file
directly and not only by the bat file?

Thank you in advance.

Milan

 

[Joan Wild]

Thank you very much for your answer. I have created the file "Start of
XYZmdb.bat" which runs your command in the command-line. It works
perfectly. But I would like to ask you yet

- which command should I use in the bat file to close the DOS window
when the command is already executed

No need to create a bat file. Just create a desktop shortcut (right-click
the desktop and choose create shortcut). You put the path I posted in the
'target' textbox of the shortcut.

- is it possible somehow to forbid the user to open the mdb file
directly and not only by the bat file?

If you implement security properly, then they won't be able to open it using
any other method. If they can, then you missed a step.

 

[Milan]

Thank you very much. It works well.

Milan