Access is very good for programmatic manipulation of data, and can interface with other packages thru ADO/ODBC/Flat File techniques. There will be a learning curve, so keep at it, you will find that you can do nearly everything that a system would need inside Access, it's main failing is the...
In the code behind the event, you could conceivably be using the same recordset object for the two unique tables.
Dim two separate recordset objects, one for each table, and at the end of the routine, set each one to nothing.
HTH,
Neal Miller
Miller Systems, Inc.
708-479-0085 Neal Miller...
Hi, when I run into goofy problems such as this, I have found that the Access Container can be corrupted. To solve this, I open a brand new empty database, import all of the objects from the corrupted database into the new database, relink any tables that need it, reset all references that are...
Thanks for the GetReferences code, I implemented as you wrote, and it works very clearly and very well. I will be using it to resolve installation issues such as this in the future.
Thanks,
Neal Neal Miller
President
Miller Systems, Inc.
(708) 479-0085
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.