is it possible access file update autometically

[kulraj]

hi guys,
I have a dictionary software in vb6, based on access (mdb) file, containing two fields Word and Wordmeaning. I am continuously feeding data in access file.

Now I want to distribute my software, however, database extension work will continue, and i want that access file check for update from the database file placed on my server, and autometically store the update data in mdb file of computer. It will be like updation of an antivirus.



Is it possible ????, if so please help.

Thanks in advance

Regards.

[June7]

Even automation needs a trigger event. Could have code behind a form that opens when project opens and runs the update procedure.

[kulraj]

Even automation needs a trigger event. Could have code behind a form that opens when project opens and runs the update procedure.

No Doubt trigger event is required. It can be placed on vb project. But the question is that how it will work. How can I connect Access file to database file uploaded on my server.

[June7]

With table links? VBA code? Depends on what you mean by 'connect'.