pjscott said:
I'm using sql 2000 and Access 2003. I have a database that I need for
people
to be able to submit work orders. Basically adding a new record.
What is the best way to add a new record using sql and Access?
"Best," like "beauty", "is in the eye of the beholder."
That's a pretty broad request, so we don't have any idea of the level at
which you expect an answer.
I'll make these assumptions: since you said you are using SQL Server 2000
and Access 2003, you have the Tables already defined and linked, whether via
ODBC if you are using an MDB or ADODB if using an ADP.
In either case, I think the simplest approach would be to create a new Form
with the Table (or, better, an updateable Query on the Table) as its
RecordSource and set its DataEntry property to Yes. You can use the Wizard
to create the Form in the format you prefer, but I suspect you'll have to
manually display Properties and set the Data Entry property to Yes.
You'll need, of course, to handle a few details, such as including VBA code
to ensure you aren't adding a duplicate record (if your table is designed
using the SQL equivalent of an AutoNumber as Primary Key, this will not be a
problem) or handling the error if you do, and validating (to the extent
possible) the Fields that are entered.
Larry Linson
Microsoft Access MVP
