473,385 Members | 1,486 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Query Fails in WinXP using Access 2003

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
5 1307
NeoPa
32,556 Expert Mod 16PB
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
1,923 Expert 1GB
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
3,532 Expert 2GB
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
dank06
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
32,556 Expert Mod 16PB
Please do Dan :)

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

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

Similar topics

13
by: Wescotte | last post by:
Here is a small sample program I wrote in PHP (running off Apache 1.3.31 w/ PHP 5.0.1) to help illustrates problem I'm having. The data base is using DB2 V5R3M0. The client is WinXP machine using...
2
by: C Martin | last post by:
For some time, I have been using TSISOON90.dll, a free Access COM Add-in from Trigeminal Software which closes one db and opens another, plus other useful tasks. We recently installed some new...
8
by: Adam Louis | last post by:
I would like help resolving this problem. I'm a novice who's been hired to query a hospital database and extract useful information, available to me only in a dynamically generated, downloadable...
5
by: deko | last post by:
After developing an MDB in Access 2003 on WS03, then making it into an MDE and deploying it on a WinXP box with Access 2003 installed, I get this error: Function is not available in expressions...
12
by: Joe Stanton | last post by:
Hello Group I have a query that works in Oracle and SQL Server, but fails in Microsoft Access. The query is: SELECT data fromTABLE1 WHERE data>='A&' AND data<'A''' Here is my sample data:
2
by: Norbert Lieckfeldt | last post by:
I am setting up a database for a friend who's an Optician, using MS Access 2002. All seems to be working well, but I have hit a snag. There's a calculated field both in a form and a query which...
2
by: John Ortt | last post by:
Hi All, I have a database in Access 97 which works fine but our company is converting from NT4 to XP Pro and in the process changing Office 97 for Office 2003. I have tried to convert the 97...
1
by: Henry Stockbridge | last post by:
Hi, I have a query that runs smoothly in an Access 97 database, but fails when it runs in Access 2003. (The original database was created in 97 and converted to 2003, if that makes a...
0
by: kkos | last post by:
I noticed the following issue posted as a double-hop issue in many discussion boards but found no answers that explain how to pass the second hop with windows auth from IIS ASPX page to remote SQL...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.