Tables in backend lost

[HansvanhEERTUM]

I tried to remove 1 table from the backend and now they are all lost. How can I get my tables back?
Thanks

[Micron]

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.

[HansvanhEERTUM]

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.

The front end shows only two tables instead of 30+ before:

[Salty Mariner]

The front end shows only two tables instead of 30+ before:

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.

[orange]

When was your last backup?
Did you try relinking as micron suggested?

Is this production/operational database?

[HansvanhEERTUM]

[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]

[HansvanhEERTUM]

Hoe kan ik de tabellen opnieuw koppelen?
Hans

[CJ_London]

Use the linked table manager

[orange]

Gebruik Google of Bing en zoek.
Use Google or Bing and search.

[Bulzie]

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?

[HansvanhEERTUM]

I tried to remove 1 table from the backend and now they are all lost. How can I get my tables back?
Thanks

Thank you all for your help. My problem is solved.

Hans

[CJ_London]

it will help others who find this thread to understand what the solution was

perhaps you can tell us?

[journeyman]

In addition to CJ_London's comment, please mark your thread Solved.

[HansvanhEERTUM]

In addition to CJ_London's comment, please mark your thread Solved.

Problem is solved. Thnx.

[Welshgasman]

Problem is solved. Thnx.

So you are not going to say how it was solved, despite being asked?
These forums are here to help everyone.
Try giving for a change, instead of just taking.