Workgroup - back ups

[Johanna Gronlund]

Hi,

The previous person in my post created a database for the organisation to
use which is secured using workgroups. I am now having to make some changes
and trying to make a backup. The problem is that when I try to open the
database exclusively I get an error message saying that I don't have the
necessary permissions to use the (file location) object. I am instructed to
have my system operator or the person who created the object establish the
appropriate permissions for me. Unfortunately, the systems admistrator says
they can't do anything and the person who created the db has left the
company. Any suggestions???

Many thanks in advance,

Johanna

 

[Joan Wild]

It sounds as though you aren't using the correct mdw file. Are you opening
the mdb using the workgroup it was secured with? If you are just
double-clicking on the mdb in Windows Explorer to open it, you shouldn't be
able to open it.

Try creating a desktop shortcut that points to the secure mdw:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

You could always do your backup via a simple copy of the mdb file in Windows
Explorer (ensure there is no ldb file in the same folder, as that indicates
someone is still using it, and you shouldn't copy a file that is in use).

 

[Johanna Gronlund]

Thanks for your reply Joan,

I am very much a beginner with MSAccess and was not able to implement your
instructions. However, there is an excisting shortcut to the database which I
can access. If I copy that shortcut to another folder, it just seems to
become another shortcut and hence cannot be a backup. I would be very
grateful for specific instructions of how to create a backup copy.

Regards,

Johanna G

 

[Joan Wild]

Right-click the shortcut and look at the target, It will have something
like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

The path to mdb part tells you where the mdb is located. However if the
database is split, this will be the path to the frontend. You'd more likely
want to backup the backend. If it isn't split, then the path to mdb is what
you want to backup.

Open Windows Explorer, and locate the mdb (the path you discovered above).
Check that there is NOT a file in the folder with the same name, but a ldb
extension. If there is no ldb that means there is no one using the mdb and
it is safe to copy it.

If the database is split, you'll want to find the backend mdb file in
Windows Explorer and copy it (again ensure no one is using it by checking
that there is no associated ldb file.