Access 2007 will not open database

[IAmNela]

I am at my wits end. My databases will not open on my laptop (Windows 7 64-bit) and Access 2010 32-bit.
I created these databases - one in 2003 and converted to 2007 without any problems (attached) and one in 2007 and I cannot open it anymore (with or without the shift key down).
They worked for 2 years until they need further development when I discovered this problem. I don't think they are corrupted as they could be open on one computer but not on mine. I think it may be a software problem as the server where they "lived" had to be replaced and since then I cannot open the files - accdb and accde.
I am attaching the files as they may explain everything. Timesheet_FE 2007 created in 2007 cannot be open; the file that I can open is too big and I am not being allowed to attach.
Please help .

[June7]

Only one file in the zip.

Wouldn't open for me either. But everything shows up in the Import wizard. So I imported to a new db. The tables are links so of course tables did not import. Everything else except a couple of images imported. I can open objects in design view.

[IAmNela]

Only one file in the zip.

Wouldn't open for me either. But everything shows up in the Import wizard. So I imported to a new db. The tables are links so of course tables did not import. Everything else except a couple of images imported. I can open objects in design view.

Thank you, your suggestion worked in so far as I have created a new Db and imported all the forms, queries, etc (it never occurred to me to do this). However, it does not let me save a ACCDE. The message suggested that I have too many references to table ID??!! I did not understand what it meant.
Can you do your magic again, please? and tell me what happened that I am now unable to save as accde?
In the meantime I am checking code and compiling it and generally making sure that all is well.
Again, thank you so much.

[June7]

I don't understand the error message either. I have never used ACCDE.

Bing: Access ACCDE too many references

Maybe this will help http://stackoverflow.com/questions/1...cdb-into-accde

[ItsMe]

Sounds like your code is not compiling. Have you done a Debug>Compile Database?

[IAmNela]

Sounds like your code is not compiling. Have you done a Debug>Compile Database?

Thanks for this. Yes, you were correct, it was the code that did not compile. I have now managed to save as an ACCDE file. It is almost ready to release.
Thanks again for your help getting this problem fixed. I still have problems with ribbons and shortcut menus that did not import, but I'll create a new thread.
Thanks.

[John_G]

Hi -

Your code has several compilation errors. One thing to remember is that while Access 2003 is tolerant and lets you use me.controlname to reference a form control, Access 2007 isn't; you have to use me!controlname, and your code has several errors like that.

I just fixed the errors so that it would compile, and then the creation of an ACCDE worked fine, no errors. It sounds like a compilation issue is your problem.

John

[IAmNela]

Hi -

Your code has several compilation errors. One thing to remember is that while Access 2003 is tolerant and lets you use me.controlname to reference a form control, Access 2007 isn't; you have to use me!controlname, and your code has several errors like that.

I just fixed the errors so that it would compile, and then the creation of an ACCDE worked fine, no errors. It sounds like a compilation issue is your problem.

John

Hi John
You are right. I located those errors when I compiled the Db and fixed them and then created an ACCDE successfully. When I created the databases 3 years ago in 2007 it allowed me to use me.controlname. Anyway, I am grateful for your help in solving this nightmare.
Nela