Re: Workgroup - back ups

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.


--
Joan Wild
Microsoft Access MVP

Johanna Gronlund wrote:
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" wrote:

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).



--
Joan Wild
Microsoft Access MVP

Johanna Gronlund wrote:
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
--
Johanna G


.

Relevant Pages

  • Re: User access on a company intranet
    ... I did as you said and created a shortcut with the path you gave me and it ... I have built into my database should I disable this? ... When you want to implement security, you create a new mdw file, and follow ... to open the secure mdb is by using the mdw you created. ...
    (microsoft.public.access.security)
  • RE: Workgroup Security
    ... I am going to make an .mde out of this database. ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... use it for that mdb. ...
    (microsoft.public.access.security)
  • RE: Workgroup Security
    ... I am going to make an .mde out of this database. ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... use it for that mdb. ...
    (microsoft.public.access.security)
  • Re: Display Short Name of Current Database name
    ... As about the backup of a mdb file can you please ... Myfile I get it from the Database using ...
    (microsoft.public.access.modulesdaovba)
  • Re: Backing up the .mdb automatically
    ... About using the Tools> database utilities> backup database function? ... of the .mdb that you are working in at the click of a control button on ... If not in a macro any other way would be ok too. ...
    (microsoft.public.access.tablesdbdesign)