Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts
    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.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by bvitter View Post
    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?
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts
    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.

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •