New Access 2007 User

[Guest]

I have an MS Access application that I originally developed approximately 10
years ago in Access 97. I now configure the program in Access 2000, however
using Access 97 DAO libraries. My clients use the application in Access
2000, 2002, 2003 without any problems.

I now have a few customers who have purchased Access 2007 and want to run
the application from 2007. I recently purchased Access 2007 to test the
apllication. It appears that I can open an *.mde version of the product, but
I can not open an *mdb version. The application just hangs up without an
error message except "Not Responding" and shuts down.

Are there any suggestions as to how to trouble shoot this issue?

LarryG

 

[Guest]

Well that one is hard because we've got nothing to go on. Why not try
upgrading it first to 2000 or 2003 and then opening it in 2007. Maybe there
are some compatibility issues.

Have you tried opening it with shift-enter?

Maurice

 

[Aaron Kempf]

DAO is obsolete

seriously-- get with the times, kid

move it to ADO and SQL Server