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: 25,763
Thanks: 12
Thanked 1,076 Times in 1,022 Posts
Pat Hartman is just really nice Pat Hartman is just really nice Pat Hartman is just really nice Pat Hartman is just really nice Pat Hartman is just really nice
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 11:46 AM.


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