Problems Adding New Records

[Guest]

I am having a problem adding / editing a record in my forms / subforms for a
MS Access 2000 database. When you are adding or editing a record once you
are done you can not leave that record. It says "Calculating ...." in the
status bar. I cancel out of the form, get the message "Microsoft Access may
have encountered an error while trying to save a record." Followed by the
message "You can not save the record at this time." I go back into the form
and the changes were accepted.

I tried the standard solutions of "Compact and Repair" and creating a new
database then importing the objects from the original database. I have the
problem with this database on various computers (some Access 2000, some
Access 2003). I can open other databases from these computers and they work
fine.

My data attributes for my form are
Recordsource - built in recordsource, not a reference query
Allow Filters - Yes
Allow Edits - Yes
Allow Deletions - Yes
Allow Additions - Yes
Data Entry - No
Recordset Type - Dynaset
Record Locks - No Locks

My table relationships are set up correctly and any Master / child links are
set up correctly too.

I'm confused.

 

[Armando Blanco]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Armando Blanco
Microsoft MVP

 

[Jeff Boyce]

Disregard the "cant do this with Access" message. It is SPAM (or worse).
Follow the link at your own peril...<g>

Regards

Jeff Boyce
Microsoft Office/Access MVP