.MDB local to .MDB with linked SQL

[Ryan Langton]

I recently upsized a database using the upsizing wizard (went from a local
..mdb to a .mdb with linked tables on SQL Server). I am unable to upload 2
of the tables. One table says error 156: Incorrect syntax near the keyword
'ESCAPE', the other just says skipping table... (no error given). What
could cause this problem? Also is there any place I could find some sort of
basic guide? Steps to go through when upsizing from .mdb to .mdb with
linked SQL tables?

Thanks,
Ryan
Skipping table 'ESCAPE'...

Server Error 156: Incorrect syntax near the keyword 'ESCAPE'.

 

[Ryan Langton]

I re-imported the 2 local tables that will not upload to SQL and the
application seems to work perfectly. Problem is that those 2 tables are
still stored locally in the .mdb. I think if I can get those uploaded to
the SQL Server everything will work great. What is the recommended way to
run .mdb with linked SQL tables, as a distributed or central application
(.mdb file distributed to clients or run on the SQL server)?

Thanks,
Ryan

 

[Alex White MCDBA MCSE]

Hi Ryan,


Sounds like the word ESCAPE could be a reserved word, just for testing
rename the table to something else and try to upsize it.

http://support.microsoft.com/?kbid=248738

 

[Ryan Langton]

Thanks! That was it.
Any ideas on the second table? It's tablename is "PERSON" and I'm getting
no errors, just skipping table... on the printout summary. The table does
have about 11,000 records.

Ryan

 

[Alex White MCDBA MCSE]

11,000 is nothing,

try just upsizing that table, without data first, if that works then do it
with data it should give you some feedback about failure. In the past when I
have got to this point I have written my own importer, because it nearly
always falls down on some invalid data somewhere.

 

[Ryan Langton]

Good catch. It was 2 records that had invalid dates (3 digit years).
Thanks again!

Ryan

 

[Alex White MCDBA MCSE]

Glad it's working....