You need to look into building in a detection mechanism for the "online
status" of a form (see
http://office.microsoft.com/en-us/assistance/HA011227901033.aspx). Put this
mechanism in the OnLoad event handler of the form, and if a connection is
available whenever the user opens the form, run the code to update the
database.
---
S.Y.M. Wong-A-Ton
> I am looking for information on how to do a submit to a database for a
> disconnected user. My users are often remote and fill-in forms disconnected
> from the database. I want to have them submit the form to their local drive
> when the finish it. Then when they reconnect I want to download everything to
> the database without user intervention. Any suggestions?