Re: DB2, MsSQL, and MS Access, How to maintain 3 data sources

What type of information will the salesmen be working on?

I am thinking if you have the same record with 20 different versions (from
20 different salesmen), I will timestamp the record in the laptop and then
use the latest version and drop the rest of the 19 versions.



"David Richards" <dave@xxxxxxxxxxx> wrote in message
news:db5qa5$dmd$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
>
>
> I was hoping someone could help me. I have been asked to look at creating
> a simple CRM system for our salesmen. We wish to export records from out
> main database, which is a DB2 database located on an AS/400. These records
> will be imported into a database located on an MsSQL server. I am hoping
> to create some routines (probably using VB.Net) to automatically send any
> additions from the DB2 database, into the MsSQL database. Each salesman
> will then have an Ms Access Database located on there laptop. A small
> routine will build an XML file containing any changes made on the SQL
> server, and another routine will do the same for the Access databases. The
> MS Access database will then send the XML file containing changes made by
> the salesman to the SQL server, and retrieve the XML file containing any
> records that have been added to the SQL server from DB2. An import routine
> will then run to update both databases.
>
>
>
> The flow of data will look like this:
>
>
>
> DB2 ----> MsSQL <----> MS Access
>
>
>
>
>
> The problem I have is synchronizing the record ID of new records between
> the SQL server and the 20 MS Access databases located on the salesman's
> laptops. Does anybody know how to do this?
>
>
>
> Any help be great
>
>
>
> Thanks in advance
>
> Dave
>
>
>


.

Relevant Pages

  • Re: Failure of Linked table in Access...
    ... SQL Server database via an ODBC DSN. ... in the Access database with various forms and reports. ... error and all subsequent queries on the PROJ table fail. ... The table is one of many tables that are linked from SQL Server ...
    (microsoft.public.access.modulesdaovba)
  • Help! Microsoft Access 2003 issue with linked tables.
    ... I have a Microsoft Access database and tables are linked to the SQL Server ... I use that SQL user in my connection string, ...
    (microsoft.public.access.security)
  • RE: Access Databases and ASP.NET 2.0
    ... but I can say that Sql Server Express is free ... and can handle much more traffic than any access database can. ... As for the default provider, its set in the base directory of IIS or in your ... I cannot set up a new website to use an Access Database to hold the site ...
    (microsoft.public.vsnet.general)
  • Re: SQL Server - Access synchronization
    ... salesman is pretty apt. ... database, or they can create a new Access database but that ... Users can add/edit via the web interface, ... > Apply all updates>= last connection, ...
    (comp.databases.ms-sqlserver)
  • Re: [ot] MS SQL and Access - connection usage
    ... > We have an application which used to be a straight MS access database, ... > which has been migrated to a SQL Server back-end (I imagine using some ... > to 6 connections to the SQL database. ...
    (uk.rec.motorcycles)