Split database Access 2000/2003

[Erin]

I have an existing Access 2000 database that is split. I've made changes to
the front end, and when I tried to create an MDE, I received the error
message that I can't create an MDE from the earlier version of Access (we're
using Access 2003 now). So I converted the MDB to Access 2003 and was able
to create the MDE. My question is, do I need to do anything with the
back-end? Will the Access 2003 MDE update the tables created in Access 2000?

 

[Jeff Boyce]

Erin

I don't believe it (or you) would need to.

After all, you can use version X of Access to link to tables in Access,
Oracle, SQL-Server, DB2, ... in any number of versions. So you should be
able to keep your data in the form it was created in.

It may be (only "may") that there are some efficiencies Access can use if
both front- and back-ends are at the same version. You could test this by
creating a copy of your current back-end, opening it with the newer version
of Access, then saving as the newer version of Access, before re-linking to
that newer version of Access' .mdb file.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Will the Access 2003 MDE update the tables created in Access 2000?

Yes, and I've had no problems using either 2000 or 2002/3 format as a backend.

 

[Erin]

Thanks guys!

Yes, and I've had no problems using either 2000 or 2002/3 format as a backend.

 

[Tony Toews [MVP]]

I have an existing Access 2000 database that is split. I've made changes to
the front end, and when I tried to create an MDE, I received the error
message that I can't create an MDE from the earlier version of Access (we're
using Access 2003 now). So I converted the MDB to Access 2003 and was able
to create the MDE. My question is, do I need to do anything with the
back-end? Will the Access 2003 MDE update the tables created in Access 2000?

Yes, that will be just fine. In fact I have a client using Access
2000 MDEs to update A97 MDBs.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/