Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to let a .mdb read only?

Status
Not open for further replies.

jslmvl

Vendor
Jan 26, 2008
268
GB
Hi,

How to let a .mdb read only? How to let it read only even the user knows the password.

Thank you in advance.
 
How are ya jslmvl . . .

Have you tried setting the [blue]read only[/blue] attribute of the file?

In [blue]windows explorer[/blue], find and right-click the file. Select [blue]properties[/blue] and set the [blue]read only[/blue] attribute.

Give it a whirl and let us know.

[blue]Your Thoughts? . . .[/blue]

BTW: Welcome to [blue]Tek-Tips![/blue] [thumbsup2] Do have a look at one of the links at the bottom of my post. The links will help you [blue]ask better questions[/blue], get [blue]quick responses[/blue], [blue]better answers[/blue], and insite into [blue]etiquette[/blue] here in the forums. Again . . . Welcome to [blue]Tek-Tips![/blue] [thumbsup2]

Calvin.gif
See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886
 
Thank you TheAceMan1!
Sorry, I didn't make my question clearly. My .mdb is in a remote server and I think I cannot set the read only attribute.
 
jslmvl . . .

If the Db is split you can make the frontend read only. Also, are you using Access Security?

You can also set a frontend to read only by:
[ol][li]Open Access.[/li]
[li]File - Open - select the file - then select read only in the combobox on the bottom right.[/li][/ol]

Calvin.gif
See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886
 
Dear TheAceMan1,

I have a .mdb for my site in a remote server. To read the data in the .mdb, users need to open the asp page. In the asp code there is no way to insert any data into the database. However, I found the size of the .mdb file became bigger but I couldn't find any inserted records (by comparing to the bckup .mdb in my computer)! That is why I want to make the .mdb read only.

>File - Open - select the file - then select read only in the combobox on the bottom right.
Can I do that in a remote server?
 
jslmvl . . .

I havn't done much in ASP, so I suggest you take your question over to the Microsoft: ASP.NET Forum

Calvin.gif
See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top