database security question

[dumdum2]

Is there a way to secure a linked table in a database? I only want read access to the data, the forms etc I don't care about.

I haven't worked with database security and going through the user-level security wizard leaves me locked out.....I guess I am not doing it right...

I was hoping for an easy way to just lock the table up!

Thanks!

 

[opvk]

There is a way to secure the linked table. Go to the DB where the original table is and click on tools >> security>> user and group permissions and then you click on what ever you want. like read only or administer etc.

Hope this helps

Winners don't do different things
They do things differently

 

[dumdum2]

Thanks, I guess I am having trouble with the 'user'....where does the database read the user name to know the permissions? Is it the Windows 2003 network user name? Or does the database need to have usernames and passwords set up on it?

 

[psemianonymous]

You can set a linked table to "read only" using the Linked Table Wizard. This will accomplish what you need without having to bother with Access security.