Are you getting any errors?
Unless you have a DSN named exactly the same as the table you're trying to update that may be your problem.
Also remember that (unlike SQL standard...) MSAccess I think uses case sensitive table and field names.
The most correct form of the insert statement would also include the field names in the statement to ensure that they're in the order you want.
Furthermore you may or may not need to add a semicolon to the SQL statement. Officially it shouldn't be needed but some drivers and databases aren't as nice as others
So your SQL should be INSERT INTO Coffeebreak (Name, ID_NUM, Pay) VALUES ('Bob', 24, 23)
Reputation Points: 1658
Solved Threads: 331
duckman
Offline 7,719 posts
since Nov 2004