Upsizing and DAO

[Schlafcommodore]

I have an Access 2000 project that I have run the Upsizing wizard to move the
data to SQL Server 2000 tables. The forms have a lot of DAO code behind
them. I have noticed, however, that some of the DAO dynamic queries are
producing different row counts when using forms against the Access DB vs.
when I run the new MDB against the SQL Server tables - in other words, there
are a lot fewer results returned when I run DAO dynamic queries against the
SQL Server tables. Does anyone have suggestions on what may have gone wrong?

 

[Alex White]

Hi,

Run a quick check on the original data and the new data on the relevant
tables to make sure the record count is the same.

Do your queries Have joins in them? As some types of access queries need
changing when they are pointing to SQL data rather than access data.

Regards

Alex White MCSE MCDBA
www.IntraLAN.co.uk





-----Original Message-----
From: Schlafcommodore [mailto:[email protected]]

Posted At: 21 April 2005 00:45
Posted To: microsoft.public.access.setupconfig
Conversation: Upsizing and DAO
Subject: Upsizing and DAO

I have an Access 2000 project that I have run the Upsizing wizard to
move the
data to SQL Server 2000 tables. The forms have a lot of DAO code behind

them. I have noticed, however, that some of the DAO dynamic queries are

producing different row counts when using forms against the Access DB
vs.
when I run the new MDB against the SQL Server tables - in other words,
there
are a lot fewer results returned when I run DAO dynamic queries against
the
SQL Server tables. Does anyone have suggestions on what may have gone
wrong?