Inserting Records into a Microsoft Access Database...

[mbrown174]

Hello, Im still new at using PHP although thanks to these forums I'm learning quite a lot. Currently, I am trying to insert a new record into my access database.

I can display records from it but not add new ones. I know that I am to use the 'INSERT' SQL function but how would an Access Database be different from mySQL?
So far I've seen only mysql examples and havent been able to find anything on access...

Thanks for any help!

[barand]

Sample

odbc_exec($connection, "INSERT INTO mytable (colA, colB) VALUES (1, 'abc')");