Security issues when trying to open a copy of a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
Click to expand...

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?
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
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
 
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
Click to expand...

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
 
Back
Top