Home All Groups Group Topic Archive Search About

Workgroup - back ups

Author
22 Sep 2006 2:21 PM
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
--
Johanna G

Author
22 Sep 2006 3:37 PM
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).



--
Joan Wild
Microsoft Access MVP

Johanna Gronlund wrote:
Show quoteHide quote
> 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
Author
26 Sep 2006 9:23 AM
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

Show quoteHide quote
"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
>
>
>
Author
26 Sep 2006 6:51 PM
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.


--
Joan Wild
Microsoft Access MVP

Johanna Gronlund wrote:
Show quoteHide quote
> 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