Error executing command

[Guest]

I have a database that I have split into front end and back end. I have
"secured" the database with passwords for all the users. When I'm working on
the server, I can sign on as any user and access the form and reports I need
to. However, when I map a network drive on a users computer and attempt to
access a form or report, suddently they are unable to ... they get the
message "there was an error executing the command".

The system.mdw file resides on the server and under tools, sercurity,
workgroup administrator, it is linking to the corret system.mdw file.

Any ideas?

 

[Guest]

Hi,
your workgroup file should NOT be called system.mdw.
Furthermore each user should get a copy of the frontend on their local drive.
You then create a shortcut on their desktop which includes this frontend,
the area where access is installed and the workgroup file to be used.
So the shortcut would look something like this:
"C:\Program Files\Microsoft Office\Office\MSAccess.Exe"
"C:\MyAppFolder\MyApp.MDB" /wrkgrp "C:\MyAppFolder\Your.MDW"

You can read more here:
http://support.microsoft.com/?scid=kb;en-us;305542&spid=2509&sid=307

HTH
Good luck

 

[Guest]

Thank you for your help. I did make the change on the name of the security
file and my front end was sitting on the user's computer.

The actual problem was "I'm an idiot" problem. After I mapped a drive to
the folder with the BE on the server, I forget to relink the the tables to
the mapped drive. Simple enough, just didn't think it through.

 

[Guest]

Glad you got it sorted out.
Good luck on future projects!