Scotty Parker wrote:
> What do you mean by a "real" database? And so, how do I configure MS
> Access such that it can handle multiple clients. I know this could be
> done but I don't know how to.
Well, I don't consider MS Access a real database. SQL Server, Oracle and
such are databases, but MS Access is just an office application which
happens to have some database functionality.
I have no experience with MS Access. I know that I can do what you want
without any problems in SQL Server and other database applications, but
they are also in a different price range than Access.
> When I run my VI on the remote computer while Teststand is also
> logging into the database on the other computer, my VI was able to
> capture data from the database.
However, TestStand halts to a run time
> error.
This really seems to be a problem with Access then. I could possibly
understand if you had problems when both applications are on the same
computer as that might mean, that the ODBC driver has a limitation and
can only serve one application at one time. But not working from
different computers seems to hint that MS Access itself can't handle
multiple connections at the same time, and the ODBC driver takes care of
that when you access the database from multiple applications on the same
computer.
Rolf Kalbermatter