Tricks and Tips for Microsoft Access
Set DB = DBEngine.OpenDatabase("C:\MyDir\MyDB.MDB")
DB.Execute "INSERT INTO MyTable (MyField1, MyField2) VALUES ('abc',
123)"
DB.Close
Set DB=Nothing
End Sub
About Steve Gray
Steve is a seasoned (translate: old) developer in VB and ASP.NET. He spends most of his time in Dynamics GP, writing custom mods for consulting firms. Crystal reports, eConnect, VS Tools for Dynamics... anything that comes along.