So the majority of my table data comes from linked tables. Is there a workaround for editing data in linked tables.
Novice
Windows 7 32bit 
Access 2010 32bit
So the majority of my table data comes from linked tables. Is there a workaround for editing data in linked tables.
Moderator
Windows XP Access 2003
Could you elaborate a little?
Novice
Windows 7 32bit Access 2010 32bit
Tables in access that are linked to tables from excel sheets are read-only. I want a way for users to edit data that comes from a linked table.
VIP
Windows 7 64bit Access 2010 32bit
Cannot directly edit data in linked worksheets from Access. Period. VBA code can open Excel objects and manipulate those objects, even modify data. This can get very complicated.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Relinking multiple linked tables that are linked to different databases
Posting Permissions
Reply With Quote