Re: Remote MSSQL + Local Access Database update
From: Morpheus (morpheusATredpointDOTcoDOTza)
Date: 12/08/04
- Next message: Ram Mulay: "XMLType in Oracle and Delphi ADO components"
- Previous message: Huseyin Tasdoven: "Access and Ado for multi-user"
- In reply to: Summerking: "Remote MSSQL + Local Access Database update"
- Next in thread: Yannis: "Re: Remote MSSQL + Local Access Database update"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 8 Dec 2004 17:37:23 +0200
I've never tried using MS SQL Replication with an Access DB on the other
end, but it might well work. Perhaps some other group mebers may be able to
advise. If not, then I guess you'll just have to "roll your own". By that I
mean write code, executed daily which allows you to retrive the transactions
from the shops Ceess DB's, and post any product tabel changes from the MS
SQL DB to the shops Acess DB's. If you're using Autoincrement columns as a
means of providing unique identifiers, then you may continue to do so at MS
SQL level for the product tables, but you cannot do so in the Access DB's.
By like token, if you use autoincrement columns in the transaction tables in
the access db's you must not try to post those numbers back to the MS SQL db
or you will have a problem. Rahter allow MS SQL to assign an anutoincrement
number when posting, and write the id back to the Access DB at the shop.
That way, you can retain a link between the two DB's, and also determine
that the record has been downloaded from the shop. You will also need a FK
into a Shops table at head office to identify each transactions shop origin.
Hope this makes sense, if not let me know and I'll try to post an example.
Regards,
Morpheus
"Summerking" <summerking2003@yahoo.com.hk> wrote in message
news:41b57828@newsgroups.borland.com...
> Application: POS system
> Clients at Shops: using local Access database
> Server at office: running MSSQL, which the central database will be kept
> Task: update everyday transactions from shops to office, and update shops
> new products from office
>
> I am thinking what will be the best way to complete the task. Any
> suggestions?
>
> Many thanks.
>
- Next message: Ram Mulay: "XMLType in Oracle and Delphi ADO components"
- Previous message: Huseyin Tasdoven: "Access and Ado for multi-user"
- In reply to: Summerking: "Remote MSSQL + Local Access Database update"
- Next in thread: Yannis: "Re: Remote MSSQL + Local Access Database update"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
