ODBC Question

[cfp76]

I am trying to run a query from a linked ODBC table. It is a very large table (all transactions for a specified month). Importing the table is not an option because it is so large.

I get the table linked and can view it fine as a table. When I go to create a query, I set it up and try to run it I get the following: ODBC - Cannot Lock all Records.

The records are not locked, but even if I try to change that setting, I get the same error.

Please help.
Crystal

 

[Twin]

Hi there,
is there a error number that is displayed with the message?...
Try creating a straight make table query and recreate live table into a static one and use that one as a source for further analysis.(access sometimes has a problem tracking(locking) records if the link is live and the records are changing as it attempts to perform the action...)

HTH
Chris

 

[cfp76]

No error number is displayed and the table is not static. It is an ODBC database pulled at the end of every month showing all transactions within that month. no one goes into this and edits any records.

Thanks for the help - I am having no luck with any contacts here or with *fiddling* with it.