Access 2003-2007-2010 problem!

[Takstein]

Hi all!

I've got a problem; our office is still running on Access 2003. Before Christmas I started working on an application for planning work hours for the department. Before I started I heard we are updating to Win7 and new Office, where i checked and I was told to develop this on Access 2010. Of course when the updates will come we'll get Access 2007...

Anyhow.. For a period we will still have to run on Access 2003 and I am 90% finished with the job in Access 2010. What i wanted was to make one easy form in 2003 for people to put in hours into the system and let the boss have the 2010 version to get reports out.

Problem; I cant link any tables from an mdb directly to an accdb (Ofcourse). Does any of you know a quick solution? Can I use ODBC?(I have been looking at this abit put can't wrap my head around it...) The mdb and accdb backend databases will be on a server accessible from the local network in the office.

Any ideas??

 

[John.Woody]

Assuming you've already split your db, convert the back end to .mdb format. You can then attach tables from both 2003 and 2007.

Hth

 

[Takstein]

I have tried that actually..However, I was so "smart" when i started that i used a template from microsoft which contains attachements in the tables so that would not be possible. I have tried to remove the attachement fields but still i wasn't able to convert it to .mdb. Maybe there's some other formats that's stopping me from doing that.. any further ideas?

 

[John.Woody]

A 2003 .mdb can not read data from 2007 .accdb so you need to look at your tables and find out what fields are stopping you from converting it to an mdb and see if you can change the fields to a compatible format.

 

[Pat Hartman]

Leave everyting as A2010. The users can use the A2010 app if you install the A2010 runtime for them. It is free and you can download it from the MS download site.

 

[Takstein]

That would be the easiest and most elegant solution I believe! Thanks!

 

[Takstein]

FYI john woody, I did manage to convert the accdb to mdb like you said as well, so that solution also worked. Thanks!