Hi everybody,

I have a small problem.

I have tables with data in one database, and these tables are linked to other databses (with forms) only for use of non-administrators of data.
Can I link tables between databses with read-only rights (that no body can update, edit fields in linked tables from second database)?

Regards,

Jacek

As for the access by forms, in the non-administrator's database, modify the forms:

• Open the form in Design view.
• Double-click the form selector to open the form's property sheet.
• In the AllowEdits property box, click No.
• In the AllowDeletions property box, click No.
• In the AllowAdditions property box, click No.

Otherthan compiling the DB to an MDE, I don't think you can disable users looking at the tables directly.

HTH

Edited by: fdcusa on Sun Jan 28 9:17:31 EST 2007.

Thanks for reply.

I know how to set read-only rights through the forms (methodology you send).
My mistake I did not mentioned about earlier.

Problem is when user knows how to get straight to the Access menu and get to linked tables (in menu: tables).
Can I somehow make these tables there are read-only tables?

Regards,