471,075 Members | 1,395 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Conflicts with Access97 and Access2003

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
3 1824
puppydogbuddy
1,923 Expert 1GB
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
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
1,923 Expert 1GB
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.

Similar topics

9 posts views Thread by Lauren Quantrell | last post: by
6 posts views Thread by Ryan Bounds | last post: by
1 post views Thread by MSWEENEY | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.