A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

synchronization



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2008, 03:08 PM posted to microsoft.public.access.forms
Beeyen
external usenet poster
 
Posts: 100
Default 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  
Old April 27th, 2008, 06:29 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP]
external usenet poster
 
Posts: 4,231
Default 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  
Old April 27th, 2008, 11:25 PM posted to microsoft.public.access.forms
Beeyen
external usenet poster
 
Posts: 100
Default 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  
Old April 28th, 2008, 01:39 AM posted to microsoft.public.access.forms
David W. Fenton
external usenet poster
 
Posts: 3,373
Default 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  
Old April 28th, 2008, 02:06 AM posted to microsoft.public.access.forms
Beeyen
external usenet poster
 
Posts: 100
Default 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  
Old April 28th, 2008, 04:01 AM posted to microsoft.public.access.forms
Arvin Meyer [MVP]
external usenet poster
 
Posts: 4,231
Default 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  
Old April 28th, 2008, 09:59 PM posted to microsoft.public.access.forms
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default 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  
Old April 29th, 2008, 04:17 AM posted to microsoft.public.access.forms
David W. Fenton
external usenet poster
 
Posts: 3,373
Default 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  
Old April 29th, 2008, 09:19 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP]
external usenet poster
 
Posts: 4,231
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.