DAO - Access 2003

[SR]

Hi,

Can anyone please point me towards any sites that can offer me some basic
DAO scripting?

I'm used to ADODB within ASP pages but need to run a some SQL in Access
2002, then apply some changes to the results via another SQL statement.
I am guessing that VB & SQL within a module is the best way to do this?

Any advice, help or examples would be much appreciated.

Thanks
Simon

 

[Allen Browne]

Are you trying to read/modify the data, or read/modify the schema?

For the data, you can use ADO recordsets in Access 2003. For the schema, you
can use ADOX or execute DDL statements if you are familar with that
approach.

DAO is still the native language in Access. For a graphical summary of the
objects in this library, see:
http://allenbrowne.com/ser-04.html

For an example of how to read the schema with DAO, see:
http://allenbrowne.com/func-06.html

For an example of how to execute action query statements in a transaction,
see:
http://allenbrowne.com/ser-37.html

For information about managing both the ADO and DAO libraries together, see:
http://allenbrowne.com/ser-38.html