Timing problems when accessing Access DB RRS feed

  • Question

  • Hi all,

    maybe someone here can help me.
    I have a VB-code that collects all kind of info from textboxes and dropdown menus and writes a lot of this info to a first table in an Access DB. In this table the added info is given an auto-increment ID number.
    After that I read the ID number from the just added row from the DB. Then I add that ID-number together with some other info in a second table.
    All this is done with simple SQL queries and OleDB commands.
    The problem is that the ID sometimes isn't read from the first table. I've already added a 600 ms pause in the VB part but that won't help either.
    Does any of you know what the problem can be? And even more important, the solution?
    I've been told to use with datatables, but I can't seem to understand that/get it to work.
    Maybe someone can give me a piece of code that does the above?
    Thanks in advance.
    Saturday, April 12, 2008 8:24 PM