-
July 12th, 2004, 12:40 PM
#1
Registered User
access query cannot edit data
I'm working on a linked Oracle table that I pull into Access. I can edit data while in a table, however, when I run a query on the linked Oracle table, I cannot edit or add data to the query. I have checked properties to check to see if the records are locked and they aren't. If I just import the linked table, I can then edit and add data to the query. I don't want to do this, because I'm trying to have realtime access for users. What could be the matter?
Last edited by amyb; July 12th, 2004 at 12:43 PM.
Dyslexics of the world..UNTIE!
-
July 12th, 2004, 01:23 PM
#2
Driver Terrier
I think you have to run and update or and sql query to do that.....
I have tinkered with linked tables in access and there is considerable differences between access's sql and mysql and oracle sql.
edit check the warning at the bottom of this page
Last edited by NooNoo; July 12th, 2004 at 01:28 PM.
Never, ever approach a computer saying or even thinking "I will just do this quickly."
-
July 12th, 2004, 05:50 PM
#3
Registered User
Originally Posted by NooNoo
I think you have to run and update or and sql query to do that.....
I have tinkered with linked tables in access and there is considerable differences between access's sql and mysql and oracle sql.
edit check the warning at the bottom of this page
Thank you NooNoo, I will see if that works tomorrow at work. I've been banging my head against my desk with this. I've looked at some books without any success.
Dyslexics of the world..UNTIE!
Similar Threads
-
By 70-240 in forum Certification
Replies: 14
Last Post: February 20th, 2012, 03:35 AM
-
By bstanbu in forum Tech-To-Tech
Replies: 3
Last Post: April 11th, 2001, 04:27 AM
-
By cpenergy in forum Microsoft Office
Replies: 2
Last Post: March 15th, 2001, 10:35 AM
-
By Bjorn in forum Windows NT/2000
Replies: 3
Last Post: February 17th, 2001, 12:58 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Bookmarks