Dianne, where is the back end located? Any chance this is inconsistent?
For example, if you are using Windows Vista, and the back end is in a folder
under C:\Program Files\ you need to be aware that Vista virtualizes these
folders. Try creating a folder somewhere else, e.g. C:\Data\ and see if that
helps.
Similarly if the folder is on a network drive such as P:\Data, you might try
using a UNC name (such as \\Server1\Data\ ) instead of the network drive
letter.
Another possibility (particularly on Vista) is that A2007 needs higher
privileges. Using the Windows Explorer (My Computer), create a shortcut to
msaccess.exe. Right-click the shortcut, and check the box for Run As
Admistrator. Start Access using this shortcut a few times, and see if the
linked tables stick.
Presumably you have already tried the basics such as turning off Name
AutoCorrect under:
Office Button | Access Options | Current Database | Name AutoCorrect
Then compact the database:
Office Button | Manage | Compact/Repair
Explanation of why:
http://allenbrowne.com/bug-03.html