Security issues when trying to open a copy of a database

[Rudolphia]

I have a secure Access database that I am trying to copy and send to a
colleague. I basically want to copy the structure (tables, forms, queries,
etc.) and send it to my colleague so they can use it with their own data. I
am the database owner, and I have no problems getting into the database.
However, if I copy the database and try to go into the copy to delete the
data, I get an error message that I don't have permission to access the
database. I don't even get a sign-in box. I even tried creating a blank
database and copying the objects from one to the other, and I get the same
error.

Anybody have any ideas?

 

[Scott McDaniel]

I have a secure Access database that I am trying to copy and send to a
colleague. I basically want to copy the structure (tables, forms, queries,
etc.) and send it to my colleague so they can use it with their own data. I
am the database owner, and I have no problems getting into the database.
However, if I copy the database and try to go into the copy to delete the
data, I get an error message that I don't have permission to access the
database. I don't even get a sign-in box. I even tried creating a blank
database and copying the objects from one to the other, and I get the same
error.

The copy would be identical to the original ... so you'd need to use the same workgroup file you're using to open the
original to open your copy. Ideally, you'd want to send your colleague an unsecured copy, so you'd want to make a copy,
unsecure it, then delete the data and send that copy. See Joan Wild's site for info on desecuring a database:

www.jmwild.com

Anybody have any ideas?

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Rudolphia]

Thanks for the response. I went ahead and provided full permissions to the
User group. My problem now is that I can't figure out how to change the
default workgroup file to system.mdw. My current workgroup file is called
Security1.mdw

 

[Scott McDaniel]

Thanks for the response. I went ahead and provided full permissions to the
User group. My problem now is that I can't figure out how to change the
default workgroup file to system.mdw. My current workgroup file is called
Security1.mdw

I assume you mean that you're joined to Security1.mdw? If so, you can rejoin the default workgroup by opening Access,
clicking Tools - Security - WorkGroup Administrator, and then Join ... find and join the system.mdw file (it's in
different places for differents version of Access, but a quick file search will turn up the location).

If you need to use a specific workgroup file for certain Access project, you can build a shortcut that will open a
session of Access with that workgroup. Just build a new shortcut, and set the Target to this:

"Full path to msaccess.exe" "full path to your database" /wrkgrp "full path to your workgroup file"


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com