Go Back   Access World Forums > Microsoft Access Discussion > Tables

Thread Tools Rate Thread Display Modes
Old 04-02-2006, 02:45 PM   #1
Registered User
Join Date: Sep 2001
Location: Charleston, WV, US
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Can't update records in Linked table

I have done everything I can think of to remedy this, but I can't figure out why this is happening. I have a linked table from excel that contains 5 fields for each record. I have a table in access with matching records and 20-30 fields. The linked spreadsheet is used when adding records. I have a query that queries both tables to get all data from both and a form based on that query where others can pertinent data for the records resulting from the query. My problem is that when I open the form the new records that were added in the linked file are there but all the fields from the access table cannot be updated. I have looked every place I know to look for record locks, read only options, everything I can think of why i cannot update these records and I am coming up empty. I checked my join properties and selected the only one that actually displays the linked records when the query is run (not sure the name of the join but it's #2 of 3 join properties options (in Access 2002). maybe I am just overlooking something simple? Do you have any ideas what I can do here?


TClark14 is offline   Reply With Quote
Old 04-03-2006, 07:15 PM   #2
Pat Hartman
Super Moderator
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,123
Thanks: 13
Thanked 1,350 Times in 1,286 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
The problem is that in order for a query to be updatable, ALL the tables and queries it references must be updatable. I think due to a lawsuit that MS lost, linked Excel files are no longer updatable. To get around this problem, you'll need to import the excel files.
Bridge Players Still Know All the Tricks
Pat Hartman is online now   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
auto update field - form to table Old Timer Forms 2 06-24-2009 07:58 PM
TextBox to show number of records in a table? robjones23 Forms 2 03-18-2005 07:56 AM
Relationship Importance philljp390 General 7 08-24-2004 04:30 AM
Update table from linked forms rpadams General 5 08-05-2004 12:52 AM
[SOLVED] copy records to other Table Krishnan Kutty General 0 01-13-2003 07:26 AM

All times are GMT -8. The time now is 07:39 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World