S
Salil
Hi,
ok, I'm a bit of a newbie (or rather, I've been away from SQL Server
for quite some time). A client has given us an Access DB to "migrate"
to SQL Server. Moving the tables, related data structures, and data is
no big deal, of course.
The macros on some of the forms are another story, though. Many
seemingly simple macros create ODBC errors when they're run now. It
appears to be that column names are being inserted into the SQL
statement's "ORDER BY" clause repeatedly. It looks like an Access bug,
but I'm not 100% certain I'm not doing something wrong.
Has anyone else seen this? Any help would be GREATLY appreciated; I'm
under serious time pressure from my own company and the client.
Thanks,
Salil Maniktahla
571-215-8218
[email protected]
ok, I'm a bit of a newbie (or rather, I've been away from SQL Server
for quite some time). A client has given us an Access DB to "migrate"
to SQL Server. Moving the tables, related data structures, and data is
no big deal, of course.
The macros on some of the forms are another story, though. Many
seemingly simple macros create ODBC errors when they're run now. It
appears to be that column names are being inserted into the SQL
statement's "ORDER BY" clause repeatedly. It looks like an Access bug,
but I'm not 100% certain I'm not doing something wrong.
Has anyone else seen this? Any help would be GREATLY appreciated; I'm
under serious time pressure from my own company and the client.
Thanks,
Salil Maniktahla
571-215-8218
[email protected]