Welcome to dbFreaks.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

MS Access / SQL Server Data Syncroniseation

  
   Database Help (Home) -> Visual Basic RSS
Next:  Report  
Author Message
Ihug

External


Since: May 05, 2004
Posts: 1



(Msg. 1) Posted: Wed May 05, 2004 6:05 pm
Post subject: MS Access / SQL Server Data Syncroniseation
Archived from groups: microsoft>public>vb>database (more info?)
Hi,
Basically I'm trying to write a program (will eventually be a web service)
that will syncronise a Microsoft Access Database (this would be on the local
Machine) with a SQL Server Database (this will be on the web).

Currently I'm trying to do this by checking each record's GUID to see
weither it is in the database (and if it's not I would insert it) and I have
been unable to compare them (that is compare the GUID). This is currently
done (unsuccessfully) by populating 2 datasets (one with the Access data and
the other with the SQL data), and scanning through each dataset checking to
see if a guid is in the database (and of course if it isn't, I'll insert
it).

--
Brian Barnes
Please post reply to newsgroups - I haven't got spam proof e-mail yet

 >> Stay informed about: MS Access / SQL Server Data Syncroniseation 
Back to top
Login to vote
Brian Barnes1

External


Since: May 06, 2004
Posts: 3



(Msg. 2) Posted: Thu May 06, 2004 7:23 pm
Post subject: Re: MS Access / SQL Server Data Syncroniseation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Ihug" <spamme.RemoveThis@nospam.com> wrote in message
news:ej$in3kMEHA.3052@TK2MSFTNGP12.phx.gbl...
 > Hi,
 > Basically I'm trying to write a program (will eventually be a web service)
 > that will syncronise a Microsoft Access Database (this would be on the
local
 > Machine) with a SQL Server Database (this will be on the web).
 >
 > Currently I'm trying to do this by checking each record's GUID to see
 > weither it is in the database (and if it's not I would insert it) and I
have
 > been unable to compare them (that is compare the GUID). This is currently
 > done (unsuccessfully) by populating 2 datasets (one with the Access data
and
 > the other with the SQL data), and scanning through each dataset checking
to
 > see if a guid is in the database (and of course if it isn't, I'll insert
 > it).

Figured it out - MS Access returns guids different to SQL Server.

In short SQL Server returns it in {} and in uppercase as a string type, and
Access returns it as guid type without {} and in lowercase

--
Brian Barnes
No Spam Proof e-mail
Use News Groups<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: MS Access / SQL Server Data Syncroniseation 
Back to top
Login to vote
Utf-8BS2plbGw

External


Since: Jan 30, 2004
Posts: 29



(Msg. 3) Posted: Wed May 26, 2004 7:41 am
Post subject: Re: MS Access / SQL Server Data Syncroniseation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Just a thought....

This sounds like a one-way communication going from SQL to Access.......

Surely there must be a way to create (Export) a new Access db from SQL and each time
overwrite the existing (old) Access db

Kjell
 >> Stay informed about: MS Access / SQL Server Data Syncroniseation 
Back to top
Login to vote
Jonas

External


Since: May 25, 2004
Posts: 13



(Msg. 4) Posted: Thu May 27, 2004 8:59 pm
Post subject: Re: MS Access / SQL Server Data Syncroniseation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Ihug,

how can you do this so easily as you said.
Check each record's GUID (how can I get the guid, Access supports only
normal autoids ?)
and insert it.
I have the same problem. I want to merge two access dbs (relational dbs).
Do you have a clue how I can do this properly.

Thanks in advance.

Regards

Jonas


"Ihug" <spamme.DeleteThis@nospam.com> schrieb im Newsbeitrag
news:ej$in3kMEHA.3052@TK2MSFTNGP12.phx.gbl...
 > Hi,
 > Basically I'm trying to write a program (will eventually be a web service)
 > that will syncronise a Microsoft Access Database (this would be on the
local
 > Machine) with a SQL Server Database (this will be on the web).
 >
 > Currently I'm trying to do this by checking each record's GUID to see
 > weither it is in the database (and if it's not I would insert it) and I
have
 > been unable to compare them (that is compare the GUID). This is currently
 > done (unsuccessfully) by populating 2 datasets (one with the Access data
and
 > the other with the SQL data), and scanning through each dataset checking
to
 > see if a guid is in the database (and of course if it isn't, I'll insert
 > it).
 >
 > --
 > Brian Barnes
 > Please post reply to newsgroups - I haven't got spam proof e-mail yet
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: MS Access / SQL Server Data Syncroniseation 
Back to top
Login to vote
Brian Barnes1

External


Since: May 06, 2004
Posts: 3



(Msg. 5) Posted: Thu Jun 03, 2004 5:02 pm
Post subject: Re: MS Access / SQL Server Data Syncroniseation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Kjell" <anonymous.TakeThisOut@discussions.microsoft.com> wrote in message
news:872572B7-B4E7-4FB2-A8EA-E65191ED7275@microsoft.com...
 > Just a thought....
 >
 > This sounds like a one-way communication going from SQL to Access.......
 >
 > Surely there must be a way to create (Export) a new Access db from SQL and
each time
 > overwrite the existing (old) Access db
 >
 > Kjell
I'm unsure as to weither there is a way to do that, but even if there was,
it was to be done via a web service therefore not practical.

The aim was to have (after the process was completed) both the MS Access
Database and the MS SQL Server Database to have the same data. Unfortunately
I've been told now that it's more of a distribution / Backup issue now and
I'm being bogged down with other isssues (see my post on
Microsoft.public.dotnet.framework.aspnet.webservices)

--
Brian Barnes
No Spam Proof e-mail
Use News Groups<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: MS Access / SQL Server Data Syncroniseation 
Back to top
Login to vote
Brian Barnes1

External


Since: May 06, 2004
Posts: 3



(Msg. 6) Posted: Thu Jun 03, 2004 5:26 pm
Post subject: Re: MS Access / SQL Server Data Syncroniseation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Jonas" <JoCaMo RemoveThis @gmx.net> wrote in message
news:ewjkfIAREHA.3504@TK2MSFTNGP09.phx.gbl...
 > Hi Ihug,
 >
 > how can you do this so easily as you said.
 > Check each record's GUID (how can I get the guid, Access supports only
 > normal autoids ?)
 > and insert it.
 > I have the same problem. I want to merge two access dbs (relational dbs).
 > Do you have a clue how I can do this properly.
 >
 > Thanks in advance.
 >
 > Regards
 >
 > Jonas

I'm not sure which version of Access Guids came in (this particular version
of Access is 2k) but to get it in this version, in design view select the
data type as AutoNumber and in the general tab set the field size to
Replication ID (as opposed to a long integer).

As for merging them, possibly merge them into a new database (if you have a
date created field) and enter them via date order, otherwise I'd suggest
inserting the smaller database into the larger one as you obviously haven't
used Guids.

--
Brian Barnes
No Spam Proof e-mail
Use News Groups<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: MS Access / SQL Server Data Syncroniseation 
Back to top
Login to vote
Jonas

External


Since: May 25, 2004
Posts: 13



(Msg. 7) Posted: Tue Jun 08, 2004 9:29 pm
Post subject: Re: MS Access / SQL Server Data Syncroniseation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Brian,

thanks so much for your advice.

You helped me alot.

Jonas

"Brian Barnes" <spamme.DeleteThis@nospam.com> schrieb im Newsbeitrag
news:%23I$rgIRSEHA.1388@TK2MSFTNGP09.phx.gbl...
 >
 > "Jonas" <JoCaMo.DeleteThis@gmx.net> wrote in message
 > news:ewjkfIAREHA.3504@TK2MSFTNGP09.phx.gbl...
  > > Hi Ihug,
  > >
  > > how can you do this so easily as you said.
  > > Check each record's GUID (how can I get the guid, Access supports only
  > > normal autoids ?)
  > > and insert it.
  > > I have the same problem. I want to merge two access dbs (relational
dbs).
  > > Do you have a clue how I can do this properly.
  > >
  > > Thanks in advance.
  > >
  > > Regards
  > >
  > > Jonas
 >
 > I'm not sure which version of Access Guids came in (this particular
version
 > of Access is 2k) but to get it in this version, in design view select the
 > data type as AutoNumber and in the general tab set the field size to
 > Replication ID (as opposed to a long integer).
 >
 > As for merging them, possibly merge them into a new database (if you have
a
 > date created field) and enter them via date order, otherwise I'd suggest
 > inserting the smaller database into the larger one as you obviously
haven't
 > used Guids.
 >
 > --
 > Brian Barnes
 > No Spam Proof e-mail
 > Use News Groups
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: MS Access / SQL Server Data Syncroniseation 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Visual Basic All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]