Access 200 DB errors when run in Access XP

[Justin Brookman]

Hi All

I've written a Contacts or Mailing DB in Access 2000 (Windows 2000
OS). When I run it on a laptop with Access XP (Windows XP OS) I
experience many errors.

I've installed both Office XP SP1 and SP2 on the laptop and this has
made no difference, another PC running Access XP with no service packs
also fails (in a seemingly identical fashion).

It keeps on wanting to send an error report to Microsoft and creates a
backup of the DB.

Some parts of the DB work fine, however one line of code which is
certain to make it fail is the following:

DoCmd.RunSQL ("INSERT INTO tblMailingDetail " & strSQLMailingDetail)

This line commits a Mailing that the user has constructed, an example
fo the complete runSQL string would be,

INSERT INTO tblMailingDetail SELECT GetMailingID() As MailingID ,
[qselOpinionFormers].[OpinionFormerID],
[qselOpinionFormers].[StoredFullOrgType],
[qselOpinionFormers].[StoredNameAndOrJobTitle],[qselOpinionFormers].[StoredOrgName]
FROM qselOpinionFormers WHERE qselOpinionFormers.SubOrgTypeID IN (9)
AND qselOpinionFormers.PostTownID IN (1,2,45) AND
qselOpinionFormers.Print = -1

This runs fine on Access 2000 but errors in XP on this line.

In addition Access XP also fails if I try to look at certain queries
in design view. I've tried importing the queries one by one into a
new xp DB and find that most but not all cause failure if I try to
view them.

I would be most grateful if somebody could give me some strategies as
to how to approach, and further isolate this problem.

Thanks in advance

Justin
Post a follow-up to this message

 

[Van T. Dinh]

The first thing I would check is the Reference Errors. See Douglas J.
Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Also, open any code module and do a Compile to make sure the code is OK in
AXP.