I have a vb6 client app with an access database where the user can add
records. These new records need to be exported as hierarchical recordsets
and imported into a remote database. Each table has an id autonumber column.
I persist the shaped recordsets as xml and sent to the remote database over
an asp page. The problem is that the recordset is not being inserted.
Looking deeper, the rs's editmode property is adeditnone and its status is 8
(ie no changes).
So my question is: How is it possible to flag the recordset to be inserted
even though I didn't do an AddNew of the persisted rs? And how do I clear
the id autonumber column so I can insert the master-details records with
breaking data integrity??
Re: Database Business Layer and Database Sync Design ... synchronization to a remote database....business object in technical terms). ... one to the local database and one to the remote database.... (microsoft.public.dotnet.languages.csharp)
Re: FM AppleScript task, seems so simple... ... I have tried a bunch of different strings for the URL, including doubling the forward slash as you suggest. ... FM says in my V9 documentation that "get remote URL" does not open a remote database, but displays the "Open Remote File..." ... This provides you with a handy log of database use. ...FileMaker 5.5, but according to its AppleSript dictionary the address ... (comp.databases.filemaker)
RE: Running Remote Queries ...query in a remote database and running it from the current database. ... CurrentDB.Execute "QueryName", dbFailOnError ... This is less work than managing it in the remote database.... (microsoft.public.access.modulesdaovba)
Re: DTS ... Where is your Remote database Located, Is that database assesible using SQL... From Local server execute the BACKUP database of your remote server using ... (microsoft.public.sqlserver.clients)
