Access 2003 error, Need help

[Meredith]

Upon trying to open a field in Access 2003, which we've used for years, I
receive the errors "The field is too small to accept the amount of data you
attempted to add. Try inserting or pasting less data." and "Microsoft Access
can't follow the hyperlink to Form Form3. Please verify the destination." As
far as I know, all I'm trying to do is open the field. I am not trying to
insert any data yet, because it won't open. How can I fix this so that we
can retrieve and enter data?

 

[mscertified]

You cannot 'open a field' in Access. Do you mean open a database or open a
table?
There may be code that is running unbeknownst to you. What EXACTLY are you
doing when this error occurs? Maybe when you open the database, it
automatically is importing or exporting some data. And maybe some of the data
items are bigger than the tables were designed for.
-Dorian

 

[John W. Vinson]

Upon trying to open a field in Access 2003, which we've used for years, I
receive the errors "The field is too small to accept the amount of data you
attempted to add. Try inserting or pasting less data." and "Microsoft Access
can't follow the hyperlink to Form Form3. Please verify the destination." As
far as I know, all I'm trying to do is open the field. I am not trying to
insert any data yet, because it won't open. How can I fix this so that we
can retrieve and enter data?

MAKE A BACKUP of your database, immediately, if you have not already done so
(don't overwrite any existing backups).

Then - once you're sure you have a working backup!! - open the database
exclusively and use Tools... Database Utilities... Compact and Repair.

If that doesn't help see the suggestions at
http://www.granite.ab.ca/access/corruptmdbs.htm