Access 97 permissions

[L0stAngel]

Hello, I have an access 97 database that I edited thats located on my PC. In order to be able to edit it, I had to go through a shortcut in the dir. The shortcut pointed to:
""C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "\\ServerName\MTP_EIS\AccessWorkgroupFiles\MPI_APPS.MDW" "C:\mpi_applications\NCMR\NCMRSecure.mdb""

When I use this shortcut, I can edit and view the forms. If I just goto c:\mpi_applications\NCMR\NCMRSecure.mdb, it wont let me view any forms except the main form, and I cannot edit it anything. I made my changes and saved them. But when I goto replace another users database (.mdb) with the one I edited, they get a permissions error "2603" that they cannot run frm(whatever). I tried running the access db through the shortcut I listed on my OWN PC, while holding 'Shift' down, and entered the users username/pass and it works. But when I upload it to their PC, it does not work.

Does anyone know what could be wrong?

 

[MoLaker]

Actually, nothing is "wrong". If you notice the shortcut command-line there is a reference to a workgroup file

/wrkgrp "\\ServerName\MTP_EIS\AccessWorkgroupFiles\MPI_APPS.MDW"

This workgroup file contains the usernames and passwords plus group assignments. This works in conjunction with the security permissions stored in the database to control who can access the database and who has permissions to make changes, etc. When you use the shortcut, you are automatically joined to the workgroup file. If you try to open the MDB direct without the shortcut, you are not joined with the workgroup file associated with the database (most likely you are joined with the default workgroup file) and not in a group with adequate permissions.

Basically, the workgroup file associated with the MDB must be available to any user attempting to open the MDB. Commonly, the workgroup file is located in the same directory as the MDB. I see by your example, your workgroup files are apparently kept in a special directory on a network server - \\ServerName\MTP_EIS\AccessWorkgroupFiles. The user must either join the workgroup manually using the workgroup manager (wrkgadm.exe - usually in the c:\windows\system or c:\winnt\system32 directory with Access 97) or use a shortcut command-line similar to your example. The difference being, the path to the MDB and the path to the workgroup file. Something like

""C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "C:\mpi_applications\NCMR\MPI_APPS.MDW" "C:\mpi_applications\NCMR\NCMRSecure.mdb"