If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Delete record error form / subform
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 |
#2
|
|||
|
|||
Delete record error form / subform
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. "karriegm" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|