Query Fails in WinXP using Access 2003

[dank06]

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

[NeoPa]

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.

[puppydogbuddy]

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

[missinglinq]

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)>

[dank06]

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

[NeoPa]

Please do Dan :)

We like to know how you get on.