data in a field is erasing and copying itself onto a different fi.

L

LisaGray

I am using Access Version 1.10. The data under the heading "Zip Code" is
erasing and copying the data under a different heading "Description". 'Zip'
can take 5 characters. ' Description' can take 65 characters. What needs to
be done to be able to input and leave the proper data in each column?
 
J

John Vinson

I am using Access Version 1.10.
Click to expand...

Wow. I'm impressed. What version of Windows are you using for this
truly ancient program (2.0 was released a full decade ago, in 1994).
The data under the heading "Zip Code" is
erasing and copying the data under a different heading "Description". 'Zip'
can take 5 characters. ' Description' can take 65 characters. What needs to
be done to be able to input and leave the proper data in each column?
Click to expand...

It appears that your database may be corrupt. I don't have a copy
around to check but I believe that there is a menu option to "Compact"
the database, and another one to "repair" it; have you run either of
these? If not, MAKE A BACKUP FIRST!! and try Repairing the database.

If that doesn't work try creating a new, empty database and use
File... Import (or Get External Data... Import) to import the tables
from your existing database.

Good luck!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top