Invalid operation error

[Guest]

Client is using Access 2K/Win2K. He has a select query that is based on many
individual select queries. He recently went into the linked table manager and
changed the server name from an alias to the real server name. Now when
trying to run the query gets the error: Invalid operation. All of the
individual queries that this query is based on run. We are able to open the
tables the queries are based on. There is no VBA code in the database. Any
ideas?????

 

[Guest]

Hi Mary,

He recently went into the linked table manager and changed the
server name from an alias to the real server name.

I'm not sure I follow exactly what you are telling us here, but I have a
couple of suggestions:

1.) Make sure that Name Autocorrect is disabled
Tools > Options | General tab

2.) Delete all linked tables. Then compact the database
Tools > Database Utilities > Compact and Repair Database...

Then recreate the linked tables from scratch, using
File > Get External Data > Linked Tables...

3.) Open the query that is not working in design view. Click on View > SQL
View. Copy the SQL statement by selecting it and hitting Ctrl A. Create a new
query. Dismiss the Add Table dialog. Click on View > SQL View. Paste the SQL
statement into the new query. You might have a corrupted query, or perhaps
there is a query property that refers to the old server name. Query
properties are not stored in the SQL statement, so copying the SQL and
pasting into a new query will eliminate any suspect property settings.


Good Luck,

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Client is using Access 2K/Win2K. He has a select query that is based on many
individual select queries. He recently went into the linked table manager and
changed the server name from an alias to the real server name. Now when
trying to run the query gets the error: Invalid operation. All of the
individual queries that this query is based on run. We are able to open the
tables the queries are based on. There is no VBA code in the database. Any
ideas?????