Inventory w/realtime update?

  • Thread starter Thread starter Penny Miller
  • Start date Start date
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?
 
Is the equimpment inventory system in Access? If not, does it have the
ability to export transactions in real time?
 
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 ).
 
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.
 
Back
Top