If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Split database Access 2000/2003
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? |
#2
|
|||
|
|||
Split database Access 2000/2003
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 "Erin" wrote in message ... 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? |
#3
|
|||
|
|||
Split database Access 2000/2003
On Tue, 25 Mar 2008 09:11:03 -0700, Erin
wrote: 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. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Split database Access 2000/2003
Thanks guys!
"John W. Vinson" wrote: On Tue, 25 Mar 2008 09:11:03 -0700, Erin wrote: 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. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Split database Access 2000/2003
Erin wrote:
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/ |
Thread Tools | |
Display Modes | |
|
|