If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Imported query from another access db has strange syntax error.
I have two databases (Access 2003) which have same tables. I imported
queries from one database into another database. Most of these queries have preview error like: Syntax error (missing operator) in query expression ‘TableA.’. Same error is also found if I copy a working query’s SQL and parse it in a new query in the same database. Can someone help me, Please? Thanks. |
#2
|
|||
|
|||
I'd say that there's got to be something different about the tables involved
in the query in the two databases - how do you know that they're the same tables? You could confirm this by renaming the tables in the non-working database to something else temporarily (like tablename_temp and exporting the corresponding tables from the working database to the non-working one. If the SQL still falls over, there's something weird going on: if it works, then there must be something different about the tables. You could then narrow down which table it is by progressively putting back the _temp tables, and then you'd have to compare the problem table in both database field by field. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200509/1 |
#3
|
|||
|
|||
Imported query from another access db has strange syntax error.
How do you export a query (not the results but the query itself) to another
database? I've been copying and pasting each year and with over thirty queries it takes way too much time. I'm using Access 2000. Thank you so much for any assistance you can offer! DC "Simon" wrote: I have two databases (Access 2003) which have same tables. I imported queries from one database into another database. Most of these queries have preview error like: Syntax error (missing operator) in query expression ‘TableA.’. Same error is also found if I copy a working query’s SQL and parse it in a new query in the same database. Can someone help me, Please? Thanks. |
#4
|
|||
|
|||
Imported query from another access db has strange syntax error.
It's simpler to IMPORT into the new database if you can.
Open the new database Select File: Get External Data: Import... from the menu Locate and select the SOURCE database Click the Import button Click the Queries Tab Click on the queries you want to import. (You can click the options button to check the Import options. Unless you import queries as Tables, you will import only the definitions) "Union_98" wrote in message ... How do you export a query (not the results but the query itself) to another database? I've been copying and pasting each year and with over thirty queries it takes way too much time. I'm using Access 2000. Thank you so much for any assistance you can offer! DC "Simon" wrote: I have two databases (Access 2003) which have same tables. I imported queries from one database into another database. Most of these queries have preview error like: Syntax error (missing operator) in query expression 'TableA.'. Same error is also found if I copy a working query's SQL and parse it in a new query in the same database. Can someone help me, Please? Thanks. |
#5
|
|||
|
|||
Imported query from another access db has strange syntax error
Thank you so much! You have no idea how much time you've saved me!!
Debby "John Spencer" wrote: It's simpler to IMPORT into the new database if you can. Open the new database Select File: Get External Data: Import... from the menu Locate and select the SOURCE database Click the Import button Click the Queries Tab Click on the queries you want to import. (You can click the options button to check the Import options. Unless you import queries as Tables, you will import only the definitions) "Union_98" wrote in message ... How do you export a query (not the results but the query itself) to another database? I've been copying and pasting each year and with over thirty queries it takes way too much time. I'm using Access 2000. Thank you so much for any assistance you can offer! DC "Simon" wrote: I have two databases (Access 2003) which have same tables. I imported queries from one database into another database. Most of these queries have preview error like: Syntax error (missing operator) in query expression 'TableA.'. Same error is also found if I copy a working query's SQL and parse it in a new query in the same database. Can someone help me, Please? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 97 using a saved query in MS Query | Eric | Running & Setting Up Queries | 0 | June 1st, 2005 09:52 PM |
What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
How to use a Access Query that as a parameter into Excel database query | Karen Middleton | Running & Setting Up Queries | 1 | December 13th, 2004 07:54 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |