There is a local database on the machine. It is used locally due to speed and performance. (No links across the WAN)
There is a main datasource that is periodically updated and is updated via ASP.
Can VB Code be written that will go out to the main datasource.. ASP and pull a recordset and re-write 1 table in the local database?
So the Local database would have a button that would open up a Record Set via a DSN or DSNLESS connection to an ASP database and then OVERWrite the local table in the local database with the 'fresh' new recordset. The local database is NEVER updated it is just used for 'Data Lookups".
Is there a different way to do this?
There is a main datasource that is periodically updated and is updated via ASP.
Can VB Code be written that will go out to the main datasource.. ASP and pull a recordset and re-write 1 table in the local database?
So the Local database would have a button that would open up a Record Set via a DSN or DSNLESS connection to an ASP database and then OVERWrite the local table in the local database with the 'fresh' new recordset. The local database is NEVER updated it is just used for 'Data Lookups".
Is there a different way to do this?
