I tried to remove 1 table from the backend and now they are all lost. How can I get my tables back?
Thanks
I tried to remove 1 table from the backend and now they are all lost. How can I get my tables back?
Thanks
Tables that are in a back end are only linked to the front end. If you deleted anything from the front end, it was only the links. Just re-link them.
If you're saying you removed tables from the back end itself, they are gone. You'd have to get them back from a saved be copy.
Can't say I ever experienced all tables being removed from the be if I just removed one. Make sure you close and reopen the be before determining that they are all gone. The only way I can see that happening is if you had selected all of them and hit delete.
Last edited by Micron; 01-03-2024 at 04:54 PM. Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
The front end shows only two tables instead of 30+ before:Tables that are in a back end are only linked to the front end. If you deleted anything from the front end, it was only the links. Just re-link them.
If you're saying you removed tables from the back end itself, they are gone. You'd have to get them back from a saved be copy.
Can't say I ever experienced all tables being removed from the be if I just removed one. Make sure you close and reopen the be before determining that they are all gone. The only way I can see that happening is if you had selected all of them and hit delete.
Do you know where your backend is located?
If so can you open it by itself (not through the front end)?
Are your tables in the backend when you open it on it's own?
We need to know that you still actually have a backend file.
When was your last backup?
Did you try relinking as micron suggested?
Is this production/operational database?
[QUOTE=Micron; 520526]Tabellen die zich in een back-end bevinden, zijn alleen gekoppeld aan de front-end. Als je iets van de front-end hebt verwijderd, waren het alleen de links. Koppel ze gewoon opnieuw.
Als je zegt dat je tabellen uit de back-end zelf hebt verwijderd, zijn ze verdwenen. Je zou ze terug moeten krijgen van een opgeslagen kopie. Ik kan niet zeggen dat ik ooit heb meegemaakt dat alle tabellen uit de be werden verwijderd als ik er maar één heb verwijderd.
Zorg ervoor dat u de be sluit en opnieuw opent voordat u vaststelt dat ze allemaal verdwenen zijn. De enige manier waarop ik dat kan zien gebeuren, is als je ze allemaal had geselecteerd en op verwijderen had gedrukt. [/CITAAT]
Hoe kan ik de tabellen opnieuw koppelen?
Hans
Use the linked table manager
Gebruik Google of Bing en zoek.
Use Google or Bing and search.
Usually it would still show the table links, you would just get an ODBC error trying to open them (at least for SQL). If you had 30 and now have 2 but only deleted 1, kinda don't make sense. Is your backend Access or SQL? Did you delete the link in the FE or BE as others asked also?
it will help others who find this thread to understand what the solution was
perhaps you can tell us?
In addition to CJ_London's comment, please mark your thread Solved.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba