>I just finished a small application for a single user suddenly my manager
>told me to convert it to an multiuser.
>
>The process of determining the path of the database in a dedicated
>server has been done by using an INI file.
>
>I just need to know how to convert all the sql statements that's in the
>application to acess it from the server (assume the server name to be
>"dirtybox").
>
>I have used only ADO's with Microsoft Access as the back end.
>
>any help is highly appreciated.
>
>Regards
>shashi
Depending on how you did your application, it is normally very simple.
First, you have to check that your database isn't exclusively opened.
Second, include errors traps that can handle things like:
-record was deleted since read (on delete and update).
-record was modified since last read (on update).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com