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
|
|||
|
|||
Access 2000 DB in Access 2002
I was curious about the following situation. Because
Access 2002 allows you to open and work with databases created in Access 2000 format, my question is, if I open a database that is in Access 2000 format with Access 2002, can I continue to work on the database (Access 2000 format) in Access 2002 without having to convert it to Access 2002 format? If so, will I still be able to open the database back in Access 2000, even if I make changes to forms/code/tables/queries, etc..., in Access 2002? My situation is such that I have a lot of Access 2000 databases and there are times when I will have a PC that has Access 2002 installed on it, and I don't want to upgrade my other PC that has Office 2000 installed on it, and I'd like to be able to make changes to the Access 2000 DB on an Office 2002 PC, while still being able to take the changes back to my Office 2000 PC and have the application work. |
#2
|
|||
|
|||
Access 2000 DB in Access 2002
Actually, the default format for Access 2002 is Access 2000. You have to
make a change to one of the settings to make Access 2002 format the default (and convert any already-created databases if you want them to be in Access 2002 format). In other words, you should have no problems. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (No private e-mails, please) "Tony_VBACoder" wrote in message ... I was curious about the following situation. Because Access 2002 allows you to open and work with databases created in Access 2000 format, my question is, if I open a database that is in Access 2000 format with Access 2002, can I continue to work on the database (Access 2000 format) in Access 2002 without having to convert it to Access 2002 format? If so, will I still be able to open the database back in Access 2000, even if I make changes to forms/code/tables/queries, etc..., in Access 2002? My situation is such that I have a lot of Access 2000 databases and there are times when I will have a PC that has Access 2002 installed on it, and I don't want to upgrade my other PC that has Office 2000 installed on it, and I'd like to be able to make changes to the Access 2000 DB on an Office 2002 PC, while still being able to take the changes back to my Office 2000 PC and have the application work. |
#3
|
|||
|
|||
Access 2000 DB in Access 2002
You should be OK *provided* that in your database design
changes, you don't use new features that are introduced in A2K2. If you do, the database still works in A2K0 but the new A2K2 features you use in the database won't work for the A2K0 users. HTH Van T. Dinh MVP (Access) -----Original Message----- I was curious about the following situation. Because Access 2002 allows you to open and work with databases created in Access 2000 format, my question is, if I open a database that is in Access 2000 format with Access 2002, can I continue to work on the database (Access 2000 format) in Access 2002 without having to convert it to Access 2002 format? If so, will I still be able to open the database back in Access 2000, even if I make changes to forms/code/tables/queries, etc..., in Access 2002? My situation is such that I have a lot of Access 2000 databases and there are times when I will have a PC that has Access 2002 installed on it, and I don't want to upgrade my other PC that has Office 2000 installed on it, and I'd like to be able to make changes to the Access 2000 DB on an Office 2002 PC, while still being able to take the changes back to my Office 2000 PC and have the application work. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2002 shortcut through Citrix connections | Diamond Joe | General Discussion | 1 | July 20th, 2004 02:23 PM |
Merge Access 2002 Runtime Setup With SP3 | Darrel | General Discussion | 10 | July 13th, 2004 07:32 PM |
Outlook 2002 looks for Access 2000 Runtime | KimC | General Discussion | 0 | June 25th, 2004 10:26 PM |
Access 97 & Access 2000 | Wnder | General Discussion | 2 | June 11th, 2004 12:35 AM |