Can't run with Access 2007

  • Thread starter Thread starter jim
  • Start date Start date
J

jim

Recently I rewrote our company software to meet management's needs. My
development computer has Access 2003. I referenced something new, MS DAO 3.6
Object Library. Now most of my objects won't run on a user's computer that
has Office 2007 installed. Before conversion all the objects ran on any
computer, including the one with Access 07. Do I have to reference or
convert something in order to use an Access 03 database when Office 2007 is
installed on a computer?
TIA
 
jim said:
Do I have to reference or
convert something in order to use an Access 03 database when Office 2007 is
installed on a computer?
Click to expand...

AK27 uses ACEDAO, not DAO 3.6. Make a separate front end for the AK27
users and compile it on an AK27 PC before distributing.
 
Gigamite said:
AK27 uses ACEDAO, not DAO 3.6. Make a separate front end for the AK27
users and compile it on an AK27 PC before distributing.
Click to expand...

That's only true, though, if you're using the new accdb file format.

Since jim is dealing with a file in the old mdb file format, DAO 3.6 is the
appropriate reference.

However, it is still necessary to ensure that the mdb file exists in a
trusted location in order to ensure that the code is automatically run.
 
Thanks Doug for you reply. I went thru the steps to make sure my database is
in a trusted location and got the message "The remote or network path you
have entered is not allowed by your current security setting." Since I
haven't used Office 2007, what do you suggest I do next?
TIA
 
Did you check the "Allow trusted locations on my network (not recommended)"
check box?
 
Back
Top