By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 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?

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


NeoPa
Expert Mod 15k+
P: 31,186
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

puppydogbuddy
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.

http://www.databasedev.co.uk/jet-sandbox-mode.html


http://allenbrowne.com/bug-Access2003SP3.html
Apr 26 '08 #3

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

http://allenbrowne.com/ser-48.html

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

NeoPa
Expert Mod 15k+
P: 31,186
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.