We are on XP Pro, all updated for Windows and Office have been installed.

Yes the data access pages in access run on SQL server and the files are stored remotely.

The computers that use this Project that are on SP1 have no problems, it is only those running n SP2.

The exact problem is that when you click between data access pages, the screen goes white for around a minute of so.

Some errors occur also such as;

- "Data provider could not be initilized"
- "Timeout expired"
- "Save record error = The Save command failed"

None of these problems have ever occured on non-SP2 PC's

__________________________________________________ __________


Quote Originally Posted by confus-ed
Welcome to windrvers forums Martin.

Some questions now to figure out 'where you are at' ..

Which XP ? Home or Pro ? & 'everything' got from windows update ? (I mean 'post' sp2 'essential' ones, there are some 'corrections' in a subsequent patch).

Office version ? Patched up or not ? (if not do so ! - all the patches are now interdependent between o/s & office version & need sometimes doing in a certain order too, I always have an extra check at each )

CRM ? Customer relationship manager ? Some access app/'thingee' or something else ? (e.g. another appplication) & is this getting its files/data locally or remotely ?

Firewalled ? Is the Windows firewall on also ? So are you 'double-firewalled' ? (SP2 has an annoying habit of turning the windows firewall service included in it ON, without telling you it did).

Any chances of screenshots (btw despite what the board says you can't add attachments) or more exact error messages such as what 'event viewer' has to say about matters ?

Anymore to add to your rather brief info that may help us ?