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
|
|||
|
|||
synchronization
Good Day,
I would like to synchronize two database; one is Access 97 the other Access 2003, Would anyone know how best to accomplish this, if possible? If synchronization is not possible, would it be possible to replicate the Access 97 database then convert it to Access 2003 and they continue to synchronize? Let me know Thanks |
#2
|
|||
|
|||
synchronization
You should be able to convert the Access 97 database to Access 2000 (the
default format) or Access 2003. From the Tools menu, select Database Utilities, then Convert. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Beeyen" wrote in message ... Good Day, I would like to synchronize two database; one is Access 97 the other Access 2003, Would anyone know how best to accomplish this, if possible? If synchronization is not possible, would it be possible to replicate the Access 97 database then convert it to Access 2003 and they continue to synchronize? Let me know Thanks |
#3
|
|||
|
|||
synchronization
Thank you for the good response. I can use the information but is it
possible to syn the two different versions of databases? Access 97 to Access 2003, and if so, how? Let me know Thanks "Arvin Meyer [MVP]" wrote: You should be able to convert the Access 97 database to Access 2000 (the default format) or Access 2003. From the Tools menu, select Database Utilities, then Convert. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Beeyen" wrote in message ... Good Day, I would like to synchronize two database; one is Access 97 the other Access 2003, Would anyone know how best to accomplish this, if possible? If synchronization is not possible, would it be possible to replicate the Access 97 database then convert it to Access 2003 and they continue to synchronize? Let me know Thanks |
#4
|
|||
|
|||
synchronization
=?Utf-8?B?QmVleWVu?= wrote in
: I can use the information but is it possible to syn the two different versions of databases? Access 97 to Access 2003, and if so, how? What do you mean by "synchronize?" -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#5
|
|||
|
|||
synchronization
Good Day Mr. Fenton,
What I mean by synchronizes; is having the database from Access 97 synchronize to a converted Access 2003. Perhaps it is referred to as something else. You see after the Access 97 database was converted to Access 2003, there remain quite a few users that continued entering data in Access 97 database. It will be at least another month or so before the users of Access 97 will have the Access 2003 installed. Although, the queries are being run from the Access 2003 database, there is a need for data from Access 97 to be included. So I was hoping there would be a way to match up the data from Access 97 to Access 2003. Any assitance you can provide will be much appreciated. "David W. Fenton" wrote: =?Utf-8?B?QmVleWVu?= wrote in : I can use the information but is it possible to syn the two different versions of databases? Access 97 to Access 2003, and if so, how? What do you mean by "synchronize?" -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#6
|
|||
|
|||
synchronization
I would convert the Access 97 database to the same version as the newer one.
Then import the data, build a query that shows them both and run a query that finds duplicates. Alternatively, I suggest that you delete and records from the imported data tables that have already been imported. If you have an autonumber, add a temporary field to the existing table for the ID of the new records, and then do an update to any of the many-side tables to accommodate the new, changed ID values. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Beeyen" wrote in message ... Good Day Mr. Fenton, What I mean by synchronizes; is having the database from Access 97 synchronize to a converted Access 2003. Perhaps it is referred to as something else. You see after the Access 97 database was converted to Access 2003, there remain quite a few users that continued entering data in Access 97 database. It will be at least another month or so before the users of Access 97 will have the Access 2003 installed. Although, the queries are being run from the Access 2003 database, there is a need for data from Access 97 to be included. So I was hoping there would be a way to match up the data from Access 97 to Access 2003. Any assitance you can provide will be much appreciated. "David W. Fenton" wrote: =?Utf-8?B?QmVleWVu?= wrote in : I can use the information but is it possible to syn the two different versions of databases? Access 97 to Access 2003, and if so, how? What do you mean by "synchronize?" -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#7
|
|||
|
|||
synchronization
Wouldn't it make more sense to leave the back-end in Access 97 format so
that both sets of front-ends could communicate with it? The fact that Beeyen's encountering problems suggests to me that the application in question may not have been split. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Arvin Meyer [MVP]" wrote in message ... I would convert the Access 97 database to the same version as the newer one. Then import the data, build a query that shows them both and run a query that finds duplicates. Alternatively, I suggest that you delete and records from the imported data tables that have already been imported. If you have an autonumber, add a temporary field to the existing table for the ID of the new records, and then do an update to any of the many-side tables to accommodate the new, changed ID values. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Beeyen" wrote in message ... Good Day Mr. Fenton, What I mean by synchronizes; is having the database from Access 97 synchronize to a converted Access 2003. Perhaps it is referred to as something else. You see after the Access 97 database was converted to Access 2003, there remain quite a few users that continued entering data in Access 97 database. It will be at least another month or so before the users of Access 97 will have the Access 2003 installed. Although, the queries are being run from the Access 2003 database, there is a need for data from Access 97 to be included. So I was hoping there would be a way to match up the data from Access 97 to Access 2003. Any assitance you can provide will be much appreciated. "David W. Fenton" wrote: =?Utf-8?B?QmVleWVu?= wrote in : I can use the information but is it possible to syn the two different versions of databases? Access 97 to Access 2003, and if so, how? What do you mean by "synchronize?" -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#8
|
|||
|
|||
synchronization
=?Utf-8?B?QmVleWVu?= wrote in
: Good Day Mr. Fenton, What I mean by synchronizes; is having the database from Access 97 synchronize to a converted Access 2003. Synchronize *what*? Data? Forms? Reports? Perhaps it is referred to as something else. You see after the Access 97 database was converted to Access 2003, there remain quite a few users that continued entering data in Access 97 database. It will be at least another month or so before the users of Access 97 will have the Access 2003 installed. Although, the queries are being run from the Access 2003 database, there is a need for data from Access 97 to be included. So I was hoping there would be a way to match up the data from Access 97 to Access 2003. The obvious solution, seems to me, is to split the app (I'd assumed it was already split?), and create a Jet 3.5 back end (i.e., A97's format), then link all the front ends to that. This means you'd be editing one data file whether the user was in A2K3 or A97, and you then would have no need to synch two separate MDBs. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#9
|
|||
|
|||
synchronization
Is your application split? As Doug Steele reminds us, the data from a split
application can be accessed by both versions. Have a look at Tony Toews page on splitting a database: Splitting the database: http://www.granite.ab.ca/access/splitapp/overview.htm -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Beeyen" wrote in message ... Good Day Mr. Fenton, What I mean by synchronizes; is having the database from Access 97 synchronize to a converted Access 2003. Perhaps it is referred to as something else. You see after the Access 97 database was converted to Access 2003, there remain quite a few users that continued entering data in Access 97 database. It will be at least another month or so before the users of Access 97 will have the Access 2003 installed. Although, the queries are being run from the Access 2003 database, there is a need for data from Access 97 to be included. So I was hoping there would be a way to match up the data from Access 97 to Access 2003. Any assitance you can provide will be much appreciated. "David W. Fenton" wrote: =?Utf-8?B?QmVleWVu?= wrote in : I can use the information but is it possible to syn the two different versions of databases? Access 97 to Access 2003, and if so, how? What do you mean by "synchronize?" -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
Thread Tools | |
Display Modes | |
|
|