copy secure database onto a network

[babs]

I have set up a database that is setup for password security - username on my
desktop. I would like to copy it out to the network and also change some of
the security settings - who does and doesn't need to log in. I used the
security wizard to set it up but not sure how to change the usernames and
their passwords and would like to be able to access the database remotely
from home office - can I do this???

Thanks for your help in advance,
Barb

 

[Keith Wilby]

I have set up a database that is setup for password security - username on
my
desktop. I would like to copy it out to the network and also change some
of
the security settings - who does and doesn't need to log in. I used the
security wizard to set it up but not sure how to change the usernames and
their passwords and would like to be able to access the database remotely
from home office - can I do this???

Thanks for your help in advance,
Barb

Yes you can. Split your database and put the back end on the server. Place
your security (mdw) file in the same location. Give all of your users their
own copy of the front end and have them open your app using a shortcut in
the format:

"full path to MSACCESS.exe" "full path to your front end.mdb" /wrkgroup
"full path to your security file.mdw"

including quotation marks.

You give your user accounts passwords by logging in on that account and
using the change password feature under Security, User Groups and Accounts.

Post back if you need more.

Keith.
www.keithwilby.com

 

[babs]

The exe file for Access may only be on the desktop. Not on network - is that
okay. Not sure how the split database works and or how you do it. Can you
explain a little further??? Do I split the existing one on the ONE desktop
that it is presently on. Not sure who can use it - open it, change the
database design. Can I from home ( tapping into network remotely???)

Thanks,
BArb

 

[Keith Wilby]

The exe file for Access may only be on the desktop. Not on network - is
that
okay. Not sure how the split database works and or how you do it. Can
you
explain a little further??? Do I split the existing one on the ONE
desktop
that it is presently on. Not sure who can use it - open it, change the
database design. Can I from home ( tapping into network remotely???)

There are a couple of issues there. For splitting see this:

http://www.granite.ab.ca/access/splitapp/index.htm

Networking is another kettle of fish and I'm not sure this is the right
place to ask but I think you'd need a very stable and fast connection to
your works server from home in order for it to work.

Regards,
Keith.
www.keithwilby.com