I tried doing this for a client - A SQL Server db for on-line to be
backed-up. replicated by an off-line Access db.
I found that it isn't practical for all but the simplest dbs.
You need to limit your db design (and, therefor, the entire on-line
application design) to the lowest common denominator (Access). Not
to the mention the time required, synchronization, etc.
A better approach for this client was to make their applications web-centric.
You can put together some simple CF programs to allow ad hoc
reporting and queries of the on-line db.
Dick
At 11:27 PM +0200 9/4/00, CF-Talk wrote:
>I want to transfer data from an MS-SQL-Server (6.5) back to MS-Access for
>storage and offline reading reasons.
>Is there an CF-Application / Custom Tag which can do that automatically with
>the help of the CF-scheduler ?
>Or do I have to write my own app. here ?
>
>Thanks. Uwe
>
>SD Solutions
>Lange Zeile 27
>85435 Erding
>Fon: 08122/903791
>Fax: 08122/903792
>Mail: [EMAIL PROTECTED]
>Web: www.sdsolutions.de
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
