Issues with Win XP, Win 2000, and Access 2000

[easycode]

I have posted a question before regarding this issue:
Does anyone know if there is any problems with Access 2000 and Win XP, cause i have a database that works fine with Win 2000 but apparently did not work very well with Win XP

well i had some feedbacks

lameid (Programmer) 1 Feb 06 15:39
I doubt it is the Windows version. More likely something else is going on or the Regional settings are causing problems. I've only worked with systems with the same regional settings but I know it can cause problems with formatting etc.For someone to help they'll need to know what information is missing.

and
PHV with something similar.

Well yesterday i borrowed a windows xp machine for 20 minutes, because in my area we only have windows 2000 and i was testing the database (in the windows xp mach.) and i got this error message:

"Catastrophic failure"

and some data was showing incomplete, i would have debugged, but i did not have much time.

Does anyone know what could have happend, why did i get this error message?

 

[CautionMP]

I do a lot of work across Win 2k and Win XP with Access 2k and Access 2003 (SP2) and have had similar issues.

A couple things I found:[ol][li]Remove the reference to DAO 3.6 (if possible)[/li][li]If not fully qualify your calls in code (i.e. [tt]DAO.Recordset[/tt], [tt]ADODB.Recordset[/tt]...)[/li][li]If you have code, sign the project. There are some goofy things that happen with Access in Sandbox mode.[/li][/ol]

In my situation Access would end abnormally, when I made these changes it seemed to correct the problem.

Hope this helps,
CMP

Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus

 

[easycode]

Thanks CautionMP, i'll do that but,
Could you explain number 3

i am working with ADO in this database.

Thank you

 

[CautionMP]

Sandbox Mode is new to me. I only ran across it a week or so ago when I started an new project in Access 2003 (SP2) which is the only version affected be this. If you want to read more about it here are a couple of official links:[ul]
[li]Windows Presentation Foundation Security Sandbox[/li][li]Functions and properties that are blocked in sandbox mode[/li][/ul]

Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus