By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,600 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,600 IT Pros & Developers. It's quick & easy.

Conflicts with Access97 and Access2003

P: 11
Hi,
I am creating reports using VBA code.
I have the same query in a querydef residing both in Access97 and Access2003. The result of this querydef is then moved to a table in Access97 and Access2003 respectively. The table in Access97 returns 874 rowcount, table in Access 2003 returns 1050 rowcount. In both the case the querydef is retrieving from the same database which resides in SQL Server 2003.

I executed the application Access97 and Access2003 individually and tried to capture the query executed through SQL profiler. In both the case the same query is executed with rowcount 1050 in SQL Server 2003. But I am not able to find why this confict occurs though the same query used in querydef which is in both Access97 and Access2003.

I am badly in need of help. Please help me to fix this issue.

With regards,
ram
May 23 '08 #1
Share this Question
Share on Google+
3 Replies


puppydogbuddy
Expert 100+
P: 1,923
Hi,
I am creating reports using VBA code.
I have the same query in a querydef residing both in Access97 and Access2003. The result of this querydef is then moved to a table in Access97 and Access2003 respectively. The table in Access97 returns 874 rowcount, table in Access 2003 returns 1050 rowcount. In both the case the querydef is retrieving from the same database which resides in SQL Server 2003.

I executed the application Access97 and Access2003 individually and tried to capture the query executed through SQL profiler. In both the case the same query is executed with rowcount 1050 in SQL Server 2003. But I am not able to find why this confict occurs though the same query used in querydef which is in both Access97 and Access2003.

I am badly in need of help. Please help me to fix this issue.

With regards,
ram
See if this link is any help:

http://allenbrowne.com/bug-10.html
May 24 '08 #2

P: 11
No this url tells in general about the usage of join in Access.

I think you didnt got wat i am expecting for.
Any one please help.. i am badly in need of the solution for this.

Thanking in advance,

With regards,
ram
May 28 '08 #3

puppydogbuddy
Expert 100+
P: 1,923
No this url tells in general about the usage of join in Access.

I think you didnt got wat i am expecting for.
Any one please help.. i am badly in need of the solution for this.

Thanking in advance,

With regards,
ram
Ok, please post the sql of your queries, so we can analyze them.

PDB
May 28 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.