Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-02-2006, 02:45 PM   #1
TClark14
Registered User
 
Join Date: Sep 2001
Location: Charleston, WV, US
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
TClark14
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?

Thanks!

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: 26,048
Thanks: 12
Thanked 1,142 Times in 1,084 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
Reply

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 01:09 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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