Delete record error form / subform

[karriegm]

Hi,

I'm using a hybrid of Access 2003 and Access 2000. I've got a problem
deleting records using a subform. I've got front end and back end
databases. Tables are in backend with referential integrity.

frmOrder has subform frmOrderLines.
frmSiteInfo has subform frmOrder

When I delete the records in the frmOrder everything is fine. But when I
try to delete a record from frmOrder on frmSiteInfo I get one of those evil
Microsoft errors where they want you to send a report to them and repair
your database.

I've compacted and repairs the front and backends. My next plan is to
rebuild the backend, and then if that doesn't work rebuild the front end.
But I thought I'd check to see if anyone else has had this problem??
Thanks!

Karrie

 

[Jeff Boyce]

Karrie

I've not run across that. If it were mine, I'd create a new (empty)
database file and import objects as a way to rebuild.

.... but maybe another reader has a more elegant solution...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.