updating user database using server database 
Author Message
 updating user database using server database

hi, let me start with what i'm trying to acvhieve

i've written a access 2000 database front end using VB6 SP3 my plan is to
have the same database on my server which contains all the latest records, i
would like the user to click an import button to connect to the server and
import any updated or new records that the user hasn't already got. i've
made a lastUpdatedOn field in the database table which would holds the date
of when the user last updated on.

to make things a little easier i plan to simply ftp the whole database from
the server to the user than check the lastUpdated field against the users
and updated/addnew as needed, but what i'd like to know is how to create a
new databse on the server with the same structure as the master which
contains only the records that the user needs, then ftp it to the user, and
perform the update. i dont know if asp would have to do this or what. at the
moment i have absolutly no knowledge of ASP. if anyone has any ideas/theorys
of the best way to do this please e-mail me.

thanks, and excuse the loose terminology.


Tue, 10 Sep 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Changing a report that uses 1 database into a report using 2 databases

2. Updating Databases on a User System Through CD-ROM

3. Wed Database - User Update

4. Wed Database – User Update

5. All users on network see update to database immediatley


7. Programatically Updating a Users Registration Database

8. Wed Database - User Update

9. locking databases (don't want more than one user to update at a time)

10. Wed Database – User Update

11. multiple users updating a central online database offline???

12. Updating database security at the user end


Powered by phpBB® Forum Software