I have a sql server table named TABLESQL.
I have access database in c:\mydir\MYACCESSDB.mdb and a table named TABLEACESS
I just have active connection with adojet from the two database:sqlconn and accessconn
The two table have exactly the same names and numbers of fields.
My prob is:
Synchronize the field1_sql and the field2_access, field2_sql and the field2_access, field3_sql and the field3_access....ecc
In this mode when the record value in the field1 of sql table changed, changed also the realted field in access table in real time.
Important form me a solution.
Other way are wel come to have the same effect wath i have explain.
note:
Not have permission to insatll sql manager but have only a reading permission on sql table e a complete permission on access database.
Sorry for my bad englsih, but i think you have an idea wath i want
If is possible with vb6 calssi and adoject(?)
I have access database in c:\mydir\MYACCESSDB.mdb and a table named TABLEACESS
I just have active connection with adojet from the two database:sqlconn and accessconn
The two table have exactly the same names and numbers of fields.
My prob is:
Synchronize the field1_sql and the field2_access, field2_sql and the field2_access, field3_sql and the field3_access....ecc
In this mode when the record value in the field1 of sql table changed, changed also the realted field in access table in real time.
Important form me a solution.
Other way are wel come to have the same effect wath i have explain.
note:
Not have permission to insatll sql manager but have only a reading permission on sql table e a complete permission on access database.
Sorry for my bad englsih, but i think you have an idea wath i want
If is possible with vb6 calssi and adoject(?)
