This is a probably a simple thing but I've never done it before because I've always worked locally.

How do I password protect an Access 2000 database and what do I then need to add to my connection string to allow users to access the database on the server?

my current connection string is as follows

"Driver={Microsoft Access Driver (*.mdb)}; DBQ=d:\foldername\foldername\foldername\dbase.mdb"

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

BUMP!
<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Davecl,

I think the Hosting Company has to set the folder that your DB is housed in to "Browse Only".

Example ... My sites are hosted on Crystaltech servers. There is a folder that I keep my DB's in that if you type in the url, folder name and DB name it gives you an error page but the DB works fine.

I noticed that you're looking for a new server ... how about trying www.crystaltech.com

I've never been more happy with a hosting company like I am with them.

Jim

Jim

Thanks for the reply but that is not the thing I was trying to do.
I too have a seperate browse only folder for the database but I thought I could maybe add a bit of passord protection to the database itself, just for a bit more security.

Thanks anyway

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Okay,

Then hopefully this is what you're looking for. <img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle>

I found this using the F1 key in Access 2000 and typing "Database Password".

Protect a database by adding a database password.
Close the database. If the database is shared on a network, make sure all other users have closed the database.


Make a backup copy of the database, and store it in a secure place.


On the File menu, click Open.


Click the arrow to the right of the Open button, and then click Open Exclusive.


On the Tools menu, point to Security, and then click Set Database Password.


In the Password box, type your password. Passwords are case-sensitive.


In the Verify box, confirm your password by typing the password again, and then click OK.
The password is now set. The next time you or any other user opens the database, a dialog box will be displayed that requests a password.

Caution

If you lose or forget your password, it can't be recovered, and you won't be able to open your database.


Do not use a database password if you will be replicating a database. Replicated databases can't be synchronized if database passwords are defined.
Notes

A database password is stored with the database and not with the workgroup information file.


You can't set a database password if user-level security has been defined for your database and you don't have Administer permission for the database. Also, a database password is defined in addition to user-level security. If user-level security has been defined, any restrictions based on user-level security permissions remain in effect.


If a table from a password-protected database is linked, the password is cached (saved) in the database it is linked to when the link is established. This may have unforeseen consequences.<img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle><b></b>

Jim

Thanks Jim

Will take a look later.

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome