Problems using Access 2007 for 2003 format db

[Everest]

My 5 yr old laptop died due to a virus and I had to get a new one which came
with OEM Office 2007 compared with the Office 2003 I had on the old one. Our
office, however, is using Office 2003 and the main Access db's all need to
remain in 2003 format. I changed the default filetype to 2003 but the mdb
files do not run properly. Filter queries do not work right. Various
functions are not recognized. It's a big mess.
What can I do to resolve this whole host of errors?
While I sort it out, I need to get my work done. Can I install Office 2003
in addition to my new Office 2007 so I can work with that at least
temporarily? I have licenses for both the old OEM version and for the new one
so this would be legit. How would I install the OEM version? Where would I
get a copy of it?

I need help! Thank you.

 

[AccessVandal via AccessMonster.com]

Have you put your database in the Trusted Locations?

 

[FPS, Romney]

Everest,
For what it's worth, here's my experience:
Our database is version Access 2000 and runs fine under Office 2007 without
having to having to install Office 2002/2003 and without having to do
anything with "Trusted Locations". What I did do, however, was go to Office
Button / Access Options / Trust Center / Trust Center Settings / Macro
Settings ... and select "enable all macros".

I don't know whether this is a good thing, or bad thing, or whether it would
work in your situation -- I guess there could be other factors involved --
but it's worked for me.
Mark

 

[Everest]

Thank you for the suggestion. Yes, I had selected "enable all macros". I did
that plus set the default file format to 2003. That solved a lot of problems
but errors persist.

 

[Everest]

Thank you for the suggestion. I tried it and it seemed to help the opening of
the files but I still can't run all the programming I have. For instance, the
search filters don't work right. And trying to edit a query, it keeps telling
me that certain functions are undefined. Like the Format function. Or the
Left string function.

 

[AccessVandal via AccessMonster.com]

The only thing now I can guess is your References. How do you Dim the
variables like

Dim db As Database
Dim rs As Recordset

If you use your 2003 MDB in A2007, it will fail. You'll have to fully declare
them like

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim tdf As DAO.TableDef

or

Dim Con As ADODB.Connection
Dim Rs As ADODB.RecordSet
so on.....

It a good idea to go thru your codes in debug with 2007 and post them here so
that we can see what's wrong.