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

Query Fails in WinXP using Access 2003

P: 2
We recently upgraded a '97 Access db to Access 2003. The user interface is programmed in VB6.4
When the user attempts to query the data from a Win2k environment, the data is available.
When the user attempts the query from a WinXP environment, the data does not appear at all.

Any suggestions to solve this problem?

Apr 24 '08 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 15k+
P: 31,494
Unfortunately, there is much more involved than simply the operating system environment.

I suggest you Google for published differences when migrating from Access 97 upwards. You'll probably need to check out the SQL you're using with this to see if anything is likely to fall foul of the newer rules.
Apr 25 '08 #2

Expert 100+
P: 1,923
Many of the conversion problems with Access 2003 relate to Microsoft implementing the sandbox mode as the default mode beginning with Access/Office 2003. Under the sandbox mode, macros and other expressions were evaluated as unsafe expressions for security reasons, and therefore, disabled. See the first link for detailed information on the sandbox mode. See the second link for info on new bugs introduced with Access 2003.
Apr 26 '08 #3

Expert 2.5K+
P: 3,532
Actually, Allen Browne also has a page on upgrading from v97 to v2000 and beyond:

Welcome to bytes!

Linq ;0)>
Apr 26 '08 #4

P: 2
Ok, thanks for all your help! My suspicion is that it's a sandbox issue and some unsafe vb code.
I will post back if I have any problems
Thanks again
Apr 27 '08 #5

Expert Mod 15k+
P: 31,494
Please do Dan :)

We like to know how you get on.
Apr 29 '08 #6

Post your reply

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