K
Ken McLean
I used the upsizing wizard to convert an Access 2002 database to an Access
project. My entry forms use VBA code and ADO 2.1 command objects to add
records. When I attempt to add a record the program is shut down with this
message: "Microsoft Access has encountered a problem and needs to close."
When I re-open the project, I find the record has actually been added. If I
delete the record and then use the entry form to add new records it works
fine. But if I close the form or project and reload it, the same unexpected
shutdown ocurrs. The only way I can get it working again is to delete all of
the records added since the upsizing.
The Access 2002 database (.mdb file) works fine with the same code.
I would appreciate any ideas on how to resolve this problem. Thanks.
project. My entry forms use VBA code and ADO 2.1 command objects to add
records. When I attempt to add a record the program is shut down with this
message: "Microsoft Access has encountered a problem and needs to close."
When I re-open the project, I find the record has actually been added. If I
delete the record and then use the entry form to add new records it works
fine. But if I close the form or project and reload it, the same unexpected
shutdown ocurrs. The only way I can get it working again is to delete all of
the records added since the upsizing.
The Access 2002 database (.mdb file) works fine with the same code.
I would appreciate any ideas on how to resolve this problem. Thanks.