Inventory w/realtime update?

P

Penny Miller

I'm not sure if this can be done but here it goes...

I have an Equipment Inventory system that keeps track of each
PC/Printer/Scanner/Server and so on... along with memory, HD, OS, software
etc... is it possible to do this in realtime mode and have it update my
database that I created in Access 2003?
 
K

Klatuu

Is the equimpment inventory system in Access? If not, does it have the
ability to export transactions in real time?
 
P

Penny Miller

Yes, it is in access and we'd like to continue using it too. It would save
us significant time if we could do realtime inventory for our network (we
have over 400 devices that we keep track of ).
 
K

Klatuu

I take it we are talking about 2 different Access mdb files here. One that
is your Equipment Inventory system and one the one that you want updated when
transactions are entered in the Inventory system.

If my assumption is correct, what you will need to do is modify your
Inventory mdb front end and include code that will create the updates to the
tables in the other mdb. That would be simply linking to the tables where
you want to put the transaction data and adding code that would create the
data in those tables.
 
Top