Security HELP!!!!!

[Bears84]

I have locked down my welding data base and had some problems arise mabe someone eles has had this problem. All of the tables in other data base that are linked to the welding data base now will not allow me to utilize them I get the error message that I do not have rights too that information. Even though I have full access rights to the welding data base and can make changes at will.

Why can't I do any thing to the others? HELP!!!!!

 

[Banana]

I sure hope you made regular backups.

Did you try holding down shift key when you open the database already?

If so, make sure that your workgroup is set correctly. I hope that you printed out the security report that was created when you secured your database because it has the information you need to rejoin and regain the priliveges.

 

[Bears84]

I have used the shift key to open the database and it allows me to do what will with the main database. The problem is when I try to open the linked databases I am unable to do so. What do I need to do to correct this problem.

All of the databases are on a server with regular backup.

Did I miss a step when securing the database?

Like should have I secured the linked databases first?

 

[ghudson]

Are you joining the workgroup to open the backend? Use a custom shortcut when you are opening your secured db's.

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" /wrkgrp "C:\Test\MyWorkgroupFile.mdw" "C:\Test\MyTestDBFrontEnd.mdb" /user UserName

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" /wrkgrp "C:\Test\MyWorkgroupFile.mdw" "C:\Test\MyTestDBBackEnd.mdb" /user UserName

 

[Bears84]

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" /wrkgrp "C:\Test\MyWorkgroupFile.mdw" "C:\Test\MyTestDBFrontEnd.mdb" /user UserName

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "S:\QCPublic\Welding Data Base\Welding Data Base.mdb" /WRKGRP "S:\QCPublic\Welding Data Base\Secured.mdw"

This works well for opening the welding data base but I still can’t access the
S:\QCPublic\Welding Data Base\Archive\Welding defect In Base Shop.mdb. This is a link inside the DB above

I do not have the necessary permission to use. And I have changed nothing on this DB. Where do I put the permission to open this data base?

 

[Bears84]

I am very confused so far. I have not been able to understand how I am to get the other mdb's associated and linked via hyperlinks with my primary mdb to relize I do have the permission to use them. Can someone help me to understand what needs to be done.