help

[Anup]

I am SQL DBA and want to design a form that will update the database ona LAN
environment can someone guide me where can i begin and steps

basically I want to substitute the
INSERT INTO Command
through the use of aceess form froma client

 

[kingston]

You can do this with an Access update query object or
attach the SQL to the form through AccessVB. Either way,
you need to know a little about creating Access forms that
execute actions. In the first method, use Access to help
you create your query and then add a button to the form
that runs that query. In the second method, create a
button on the form and select [Event Procedure] in the
Properties box after the On Click event. Then create a
string that has your SQL command and use the command
DoCmd.RunSQL strSQL where strSQL is your string. You may
also want to use the command DoCmd.SetWarnings False/True
to turn messages on and off.