if you have the original .accdb you should be able to import the tables from the .accde. But per post #7 strongly recommend you split it by creating a new BE db for the tables only and import to there. Then link your .accdb to the new BE
I followed the steps I outlined in post #11.
The good news is that I have fixed the compact errors - there was no need to use any external software to do so.
The problem was that you had two f_...._Data tables with slightly different strings for the ... part.
The bad news is that there were no data tables supplied with the file - for example tbl_scala was not included.
The only non-system object is a query qry_AC with this SQL
Code:
SELECT tbl_Accessories.ID, tbl_Accessories.AC_name, tbl_AC.fgk
FROM tbl_Accessories INNER JOIN tbl_AC ON tbl_Accessories.ID = tbl_AC.A_name;
However neither table is included in the file
Let me know if you want me to return the file to you...but I'm not sure it is any use to you.
I followed the steps I outlined in post #11.
The good news is that I have fixed the compact errors - there was no need to use any external software to do so.
The problem was that you had two f_...._Data tables with slightly different strings for the ... part.
The bad news is that there were no data tables supplied with the file - for example tbl_scala was not included.
The only non-system object is a query qry_AC with this SQL
Code:
SELECT tbl_Accessories.ID, tbl_Accessories.AC_name, tbl_AC.fgk
FROM tbl_Accessories INNER JOIN tbl_AC ON tbl_Accessories.ID = tbl_AC.A_name;
However neither table is included in the file
Let me know if you want me to return the file to you...but I'm not sure it is any use to you.
Thank you for spending your time on my file,
No I don't need the recovered data, I'm looking for "tbl_scala", It seems the table is not possible to recovery.
Thanks to everyone for trying and spending time.