Access 2007 Linked Table Questions

Topic

New Reply

I have two questions about using a linked table from an Access 2007 application I did not create:
1) Is there a way to establish a Linked Table as Read Only? I do not have any control over the source database and I don’t want users of the database with the linked table (which I do control) to be able to update or delete data in the source table
2) If I display the source table (less than 1,000 records, not complex structure) I can see all fields. When I display the linked table the first two fields do not display. I searched the MS TechNet and could not find any reference to this issue.

Desktop OS is XP, databases are on a server but the same missing fields issue occurs when I copy the two databases to a local drive on a Windows 7 system.

Reply | Quote

Replies

I have two questions about using a linked table from an Access 2007 application I did not create:
1) Is there a way to establish a Linked Table as Read Only? I do not have any control over the source database and I don’t want users of the database with the linked table (which I do control) to be able to update or delete data in the source table

[*]To do this properly you would need to set up full User and Group Security, which is not available with accdb files, but is available with mdb files used under Access 2007.[*]Also, do not provide direct access to the tables. If you force users to interact with the data via a form, you can make the form read-only.

2) If I display the source table (less than 1,000 records, not complex structure) I can see all fields. When I display the linked table the first two fields do not display. I searched the MS TechNet and could not find any reference to this issue.

[*]Are the source tables coming from Access or something else? I have never encountered this with Access linked tables.[*]What datatype are the missing fields? Is there anything different/special about them?

Reply | Quote

The Read-Only form is a good idea – thanks.

The source table is in a Access 2007 database. The first field is the automatically created Record Key and the second field is text.

I played around with it some more and it appears that the problem is the field name – both are two words with a space between. When I replaced the space with an underline in my test copy of the source database the fields showed up in the linked table.

Reply | Quote

John’s spot on about NEVER letting users access tables direct.

Select the table, then on the ribbon goto Create>More Forms> Datasheet.

The resulting form still looks like a table but you can easily lock the contols on the form to prevent editing or set the form’s allow edits, allow additions and allow deletions to false.

Interesting about the fields missing when their names have a space. Especially when you see so many sample apps, even from MS that use field names with spaces.

Reply | Quote