Accessing the database on a network through a VPN

[Linda]

I have had little issues since placing the database on the network until
today. I am working from home and my task is to tweak the db. I have to
access the network through a VPN, something I don't have to do when at the
office.

When I open the db, it assumes I am admin, but doesn't ask for a password,
so that I could log in as myself to make changes. I'm guessing it is because
it can't find the correct mdw? Where should this reside while I am in VPN
status?

Thanks for your patience!

 

[Guest]

Linda, it opens like that because Admin is the owner of
the database, and has complete permission over everything.

To create a database that is not owned by Admin,
you have to first login to Access as a different user,
then create a new database and import everything
into it. Some versions of the Security Wizard don't
do this properly.

Admin is the default user, so everyone can always
be Admin just by using the default mdw. The default
password for Admin is blank, so everyone can
always login as Admin just by using the default mdw.

You can change the default mdw used on your home
computer, there is a menu in Access for doing that.

Or, you can use a shortcut to MSACCESS.exe on
your home computer, and on that short cut you can
specify which mdw you wish to use:
.....msaccess.exe /wrkgrp c:\mywrkgrp.mdw ...
you need to use the complete path to the workgroup.

I sometimes use a partly unsecured database like
you have, with a special login mdw, so that we can
see the login name when a record is locked. I use
a shortcut to msaccess.exe with the path to the workgroup
file

(david)