>I can connect to the database and browse the records, however my insert doesnt work
What does the code look like? Are you trying to insert into the result (VFP) cursor, or the Access Table.
It would be helpful to see your:
SQLCONNECT()
and SQLEXEC() insert statement
Imagination is more important than knowledge