I am having trouble building a network based MS Access application. I used the splitter wizard to put the tables in a backend Access database and the forms in a front end Access database. I then secured the database using the user-level security wizard. I created a full data user group and assigned several userids to that group.
The problem is nobody can run this database but me. Everybody else is getting the ‘you dont have permissions to run etc…’ message.
Here are the icon parameters:
“C:\Program Files\Microsoft Office\Office\MSACCESS.EXE” “O:\prcrmnt\PRCRMNT.MDB” /WRKGRP “O:\prcrmnt\Secured.mdw”.
I also want users without MS Access licenses to be able to run this application. Here is what I think the icon should be for them:
“O:\prcrmnt\PRCRMNT.MDB” /WRKGRP “O:\prcrmnt\Secured.mdw” /runtime
Is this correct after running the runtime setup program? If so this is also not working.
I am stumped and spending too much time on what should be something simple.
