Access 2003 to Access 2007

[RoadKyng]

I am cloning a database we use in our business for a sister company. Main
changes are report headers, form header changes and some minor coding changes
due to slight process differences between the two companies. I just
discovered the new company has Access 2007. The original database is Access
2003. Looking at the Microsoft Office website it seems the changes between
the two are mainly in the interface. Is this correct? I need the data tables
to remain unchanged if at all possible as there may be a chance the two
companies will share certain data.

 

[Tom van Stiphout]

On Wed, 19 Mar 2008 21:46:00 -0700, RoadKyng <[email protected]>
wrote:

Correct. The back-end can be identical.
As I come to think about it, the front-end can be as well, depending
on if you use custom menus that have given some newsgroup users grief
since A2007 prefers the new (superior imho) Ribbon interface.

If the changes are minimal, I would maintain a SINGLE database, with
the different headers etc set programmatically, for example based on
the domain name where the app is running.
Example in Report_Open event:
If GetDomainName() = DOMAIN_ONE then
Me.Title = "Some Title"
elseif GetDomainName() = DOMAIN_TWO then
Me.Title = "Another Title"
etc.

The GetDomainName function can be patterned after
http://www.mvps.org/access/api/api0040.htm

-Tom.

 

[Allen Browne]

Access 2007 can use an Access 2003 MDB fine.

You would be stuck only if you converted it to the new file format (ACCDB.)

Access 2007 does have some other features beyond the obvious interface ones,
but you don't need to use those, and you won't want to use those if the
database needs to still be used in A2003 as well.

More info on converting to Access 2007:
http://allenbrowne.com/Access2007.html