read/write permissions in Access 97

[hysteria]

When I open the database through a shortcut,it asks me for a Name and a paswd.Works fine over here.
When I open the actual target of the shortcut (the same database ofcourse) it doesent ask me for a name and a pswd.Plus in the first case I am able to open and view tables.In the second case while the database opens without asking for a pswd,I cannot open and view the tables.It says you do not have read permission.
I cannot understand why that is happening and could anyone please direct me as to what properties or conditions to set to correct that.

Thanks a lot.

 

[SgtJarrow]

Without going into the long of it (and it can get very long), this issue lies in the default workgroup file you are joined to. When you are using the shortcut method to access the database, you are probably being redirected to a different workgroup file with appropriate permissions and security set up. When you acees the file directly, you receive the security and permissions from your default workgroup. These workgroup files don't have the same list of objects and therefore you are experiencing read/write permissions denials.....

That all being said, the (relatively) simple fix is to close off the access to the database unless you use the shortcut. IN other words, if you don't open the databse with the shortcut,you ain't even getting in.... Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[hysteria]

ok..but i need to get into the database because I have to make a few changes.
I havent really worked with read/write permissions before, therefore I am having some difficulty.
I made a copy of the database so that I do not muddle with the original data but I cant seem to even view the tables in this copy.
How do I have full access to it?

 

[SgtJarrow]

You will need to log into the database using the shortcut you have created and you must log in using password that has admin priviledges in the workgroup file.... Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[JeremyNYC]

If you can get in with the shortcut, that seems to be good enough for most purposes, yah?

If not, it will take a decent investment of your time in learning about securing a database b/c it sounds like the database was secured improperly in the first case.

If you decide to do this, get the MS Access Security White Paper from their website and read it several times before trying to resecure it. And a copy made before this, as you've already picked up on, is VERY important.

Jeremy =============
Jeremy Wallace

http://www.AlphaBetCityDataworks.com

Designing, Developing, and Deploying Access databases since 1995.