Same Security-protected database on 2 different computers

[SherryScrapDog]

I have a database for a genealogy volunteer project that is for their library
inventory system. The Society has bought a new computer for the purpose of
the librarian to update the database. (Note: I created this database system
by converting data from an old PC File database, so it begins with these
records and now needs to be updated with current and on-going information.)
I placed the database on their 'Main' computer (Access 2007, but the database
is Access 2003) and created Usergroup Security on it. Now, the new computer
has come in and they cannot get it to network to the main computer. So, I
want to be able copy the same secured database to the new computer, and then
periodically, copy the updated database back to the main computer. (The main
computer is used for researchers for inquiry only.) Can this be done by just
copying the .mdb & .mdw files for the new computer, then copying just the
..mdb file back to the main computer? Thanks in advance if you can offer
advice! Sherry

 

[Olduke]

You should be able to update the main computer by using the Get External Data
command on the file menu and just replacing the tables.

 

[Olduke]

Sorry...should have added make a copy on your desktop first and try it there
before messing with the permanent data.

 

[SherryScrapDog]

Thanks for this info. It seems like such an easy thing to do and I only have
2 tables. I happen to have a copy of the database on my computer (versus the
Society's) that is currently unprotected and a copy of the security protected
database in another directory. I tried to import with my unprotected copy
up, from my protected copy (and again from my flash drive), drive and I get a
security error message. I cannot get into the secured copy of the database
on my computer. If I can get the other secured copy working on the new
computer at the Society, I will try there again. If there is some step
here that I am missing, please let me know!! Thanks, Sherry

 

[david]

Yes, you can copy the mdb and mdw from one computer to another.
Make sure that the mdb and mdw are not in use while being copied,
and make sure you get your short-cuts right. (If you don't have any
shortcuts pointing to the mdb and mdw, you haven't done it right
to start with).

The mdw is just another database - a user database. Access security
is not integrated into Windows security because there was no Windows
security when Access was designed.

If you don't change the mdw - don't add new users or change
passwords - you don't have to copy it around after there is a
copy on the PC.

(david)

 

[SherryScrapDog]

Thanks David. I do have the short-cuts and seem to have them ok. Hopefully
my first copy of the updated database will go smooth; I have just put them
into production. This information was helpful! Sherry