in reply to Inserting a record into an Access database

Do you get your error message? Do you get any message? It looks like you have some code in there to print out all the rows, did that work? Try turning RaiseError on and see if that gives you better info.

As a side note, you can use a MySQL database (or any other) as the backend for Access. I've found that doing that makes the Access database faster, and much easier to work with. It also means that when the Access mdb file becomes corrupt (which happens all too often) you don't have to worry about your data being corrupted.


___________
Eric Hodges
  • Comment on Re: Inserting a record into an Access database