Need some help

[jvincent]

Hello,
Yesterday i compacted my access base and i had an Microsoft Error message wich told me they are sorry and ask me if i want to save a backup. The problem is that my base and the backup are dead!!
If i enter in my base with Shift key i can see forms, reports, queries etc..
Now the program doesn't work, after investigations i saw that in all queries the links between tables are broken and all fieldnames where named Expr:FieldName. (in menu Tools/Relation links between table are corrects).
This base is linked to another base wich contains the table and this link is ok, i can access to the tables.
Do you know the cause of this problem and how to repair?
Thanks in advance.
VINCENT

 

[alastair69]

If you relink your tables this should do the trick.

Alastair

 

[jvincent]

Hi, Alastair

Thanks for your response.

If i re-link my base with the tables from the other base that doesn's solve the problem, in queries the links between the table fields stay broken, it works if manualy i re-create these links between fields and rename expr: AAA as AAA. in each column of the query.
But i would like to know if there is a tool wich can repair this.
VINCENT