Share Access database between Access 2007 & 2003

[001RCB]

Hello ...

Can a single Access database be shared between two (2) computers, one
running Office 2003, the other 2007?

Here is the basic set up:

Desktop 001 (DT001) running Vista & Office 2007, on network 001
Access database xyz has been created, and at least up to now,
maintained on DT001

Notebook 001 (NB001) is running XP Pro & Office 2003. It is generally
standalone, but can be run on network 001
would like the ability to access & modify database xyz, as well as
the individual records, when in either standalone or networked mode on NB001.

Would like any modification or additions to the database design and or
records made on either computer, in whatever mode, to be merged into one
database without loss of any changes.

Is this possible?

Thanks, RCB

 

[Daniel Pineault]

Yes, but you need to always design for the lowest common denominator, which
in your case is Access 2003. Besides that you should typically have no
issues. Obviously, that said, you cannot take advantage of any of the new
features in Acces 2007 as they will nt owork in Access 2003.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.