This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have an Access 2003 database that is split into front and back. When I make changes to the mdb file in testing, I have not had to relink to existing tables that are defined to this database. I thought that when I go thru the creation of the mde file, it relinks automatically for me. I have not had a problem for several years related to this. Then the last time I created a new mde file, the results of the new application were totally wrong in Production. After tremendous effort on my part, I determined I needed to relink all the tables. I did so and the results were correct. Is this re-linking necessity going to be normal now? Why?
Thanks for your time.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Sounds like it might have been just a one-time fluke. Hope everything works well from here on out. Cheers!
I do a C&R every time I do an update and cut an new mde file which is about once or twice a month. Backups are taken 2x per day!
Do you regularly perform a C&R (compact and repair)? If not, it's a good idea to do it every now and then. And also, make sure you keep a good set of backup. Good luck!
Thank you for responding so quickly. I thought of that but the new part of the application was the only part that did not work properly. It DID have several new internal tables but no new links. And all of the other parts of the app work fine. And after I re-linked to all tables, it fixed the problem, so I do not think it is corrupted.
Hi. When you "link" a table in Access, the file's location is saved for future use. The only time you will have to relink the tables is if you move the file to another location. If you got this problem without moving or renaming the file, so it doesn't match what was stored internally in Access, then you could be dealing with corruption. Just my 2 cents...