By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Using Secured MS Access 2003 Database

pbala
P: 37
hello,
I created the user level security for one MS Access 2003 database.It created one Shortcut file in Desktop. Now I want to share the database with my company workers. How i will share the Database?


Thanks...
Feb 11 '09 #1
Share this Question
Share on Google+
2 Replies


P: 69
@pbala
pbala,

When you add user level security to a database, a special file called "Secured.mdw" is created that contains information about user names and permission levels to the database. In order to open the database after user level security has been established, a special shortcut is needed (thus the shortcut Access 2003 created on your desktop). From now on, in order to open your database, you must use the new shortcut. If you want others to use the database, you must give them a copy of your shortcut file.

Hopefully, the database and the "Secured.mdw" file are located somewhere they have access to. If not (and you move or copy the database and "Secured.mdw" files) the path information in the shortcut file will need to be updated. Hope this helps.

sphinney
Feb 12 '09 #2

NeoPa
Expert Mod 15k+
P: 31,419
We can help with this if you need it and provide the necessary information.

NB. Moving forward (from 2007 I believe) security databases (.MDW) are no longer used in Access. They were always complicated (Quite logical really, but many people had difficulty understanding them), so it's probably not a bad thing.
Feb 13 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.