Database does not save records

[Guest]

I have an Acc97 database that is not saving the records. At the beginning of
the day a user opens the form and begins to enter records. Sometime during
the course of the day the user gets the error message - Runtime 2448 - "You
can't assign a value to this object". This is when the database will stop
saving the records or would not allow any more entries. This problem does
not occur for all users.

Any suggestions?

Thanks

 

[John Vinson]

I have an Acc97 database that is not saving the records. At the beginning of
the day a user opens the form and begins to enter records. Sometime during
the course of the day the user gets the error message - Runtime 2448 - "You
can't assign a value to this object". This is when the database will stop
saving the records or would not allow any more entries. This problem does
not occur for all users.

Any suggestions?

Thanks

Have you Compacted the database? Is this a single database shared
between multiple users (VERY unwise!) or a split database, with a
shared "Backend" containing the tables and individual frontends?

John W. Vinson[MVP]

 

[Guest]

The database is divided into a front end and back end both stored on the
network. The users have shortcuts to the database on their desktops. The
database is repaired and compacted several times a week.

 

[TC]

You need to show the line of code that causes the error. And
preferably, the 20 or 30 lines on either side of it. It's too hard to
guess the cause of the problem otherwise.

HTH,
TC [MVP Access]

 

[John Vinson]

The database is divided into a front end and back end both stored on the
network. The users have shortcuts to the database on their desktops. The
database is repaired and compacted several times a week.

Are all users *sharing the same frontend*? Just as bad as sharing the
single database...

John W. Vinson[MVP]