.MDB Update through SQL.

[Mc Brain]

Is there any way to UPDATE, DELETE, or INSERT data in an MDB (actually it's a DBF which is vinculated to the MDB) through an SQL sentece? Am I clear?

[Lafor]

Hi...
tell us (3 yr olds..) a bit more...
surprisingly sometimes we come up with ideas... though often babyish

[Mc Brain]

It's hard to explain. But I'm making an app in SQL Server. All the data I need is on the SQL Server. However, as the app I'm making is an optimization of an old system (written in Clipper for DOS) we would like to have both system running until the "debug period" of my app is over. So, the UPDATES, INSERTS and DELETES would be "seen" in both systems.
There are two main problems. The first one is that we don't have the code of the old system, so we can not change it at all. The second one is that the SQL Server and the DBFs that the old system uses are in different networks and could not see each other. This is done for security purposes.
As I need my app to "UPDATE" (or whatever) both databases, I was thinking I could record the "queries" I make in my app, translate the "queries" (change the name of the fields and that stuff) and re-execute (at night) the "translated queries" so that the DBFs of the old system are updated.
Did I make myself clear??

[Lafor]

sql 6.5 and 7.0 have the trace capabilities
where u can trace every single statement that went through
a db during the day and save that in a .sql file

Unfortunately, enterprise manager does a few small queries
of itself.. but everything should be in that file and
you can rerun the queries later

...

[Mc Brain]

The problem is not how to make the "trace" or whatever. I have a little idea how to achieve that. The question is how do I get these statements (made during the day) to modify the other old DBFs. I don't know if there's a way to perform an UPDATE, for example, to change a DBF. And if it's possible... how?

[Lafor]

ok... sorry to have given u a run around

I don't know

[Mc Brain]

Ok, no problem. Anybody have any idea?

[Mc Brain]

No ideas??