Can't run with Access 2007

[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

 

[Gigamite]

Do I have to reference or
convert something in order to use an Access 03 database when Office 2007 is
installed on a computer?

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.

 

[Douglas J. Steele]

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.

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.

 

[jim]

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

 

[Douglas J. Steele]

Did you check the "Allow trusted locations on my network (not recommended)"
check box?

 

[jim]

Thanks, Douglas -did the trick.

Did you check the "Allow trusted locations on my network (not recommended)"
check box?