Hi everybody,

Am trying to add a record to a Access db, so that when I click the button "Knop2", the values of A1 & B1 are written to the Access db:

Please Login or Register  to view this content.

but this returns a "80040e37" error (can't find Table1) at the "rs.Open sSQL, cnn, adOpenKeyset, adLockOptimistic, adCmdTable" line. I checked, and Table1 is the name of the table in Productie.accdb. What I gathered from Googling the error, is that it could be a problem with permissions(?) (I work in a client-server environment), but I'm a complete noob when it comes to SQL and/or Access.

Could anyone shed some light on this?