Home > IT Answers > Microsoft Windows > Converting from Access 2003 to Access 2007
BUG68
225 pts.
 Converting from Access 2003 to Access 2007
Access, Access 2003, Access 2007, Access Database
hi, everyone

i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007

so i divide my Access database in two parts on of them have tables an other a form queries, etc.

My problem is, is possible link tables for these three desktop's.

because of that diference i convert for two version's 2003 and 2007.

anyone give me a help for that question?

thanks in advanced.



Software/Hardware used:
Microsoft Office, Windows 7
ASKED: January 14, 2011  5:05 PM
UPDATED: January 17, 2011  12:25 PM
RELATED QUESTIONS
Answer Wiki:
Microsoft has confirmed that Access 2007 and Access 2010 share the same native file format. With SharePoint Server, it is possible to create web database and allow users to access a database in a web browser. Of course, you need Access 2010 to make changes to the database itself. I refer two links for clear concepts. Please link <a href="http://www.access2010converter.com/">Here</a> And to know what r the additional things, please visit <a href="http://blogs.techrepublic.com.com/10things/?p=1705">Here.</a> Please update me about ur query ! Thanks--
Last Wiki Answer Submitted:  January 17, 2011  12:25 pm  by  Michael Morisy   6,893 pts.
All Answer Wiki Contributors:  Michael Morisy   6,893 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I would suggest having the main tables in 2003, as 2007 can read them, and do what you want with the data, and write it back in the 2003 format.

Probably best to have a server for the 2003 tables, and hold the form queries local. They can be written in the local database version (2003 or 2007, depending what is installed.)

Are all 3 desktops adding to the tables, or are the updates only done on the 2003 desktop, and reports pulled off on all 3 desktops?

Chippy088
 4,625 pts.
 

hi, again,

and if i have Access 2010, it is possible consulting 2007 database?

thanks.

BUG68
 225 pts.