Slightly OT: Urgent- Which program for INVENTORY ?

[blackburst]

Our audit says we need an inventory of fixed assets, and we need to do
it in a hurry.

We started one last year in MS Access, but my computer won't let me
open it without a MS anti-virus update. But one software installer told
me never to do updates, as it would screw-up a pivotal program.

I am going to recreate the inventory. Should I do it in Excel or
Access?

We have many pieces of equipment. I need each entry to have several
fields: manufacturer, model number, serial number, location, when
purchased, where purchased, active or inactive, and finally, a specific
in-house inventory number, corresponding to a bar code. The database
should be searchable by any of these fields.

Which program should I use? Excel or Access?

HELP!

 

[Ed]

Excel should be able to handle your inventory just fine. I would do two
things:
(1) Ask on an Excel newsgroup about the possibility of importing your
current Access tables directly into Excel.
(2) Ask on an Access newsgroup about the virus update thing. Tell them
which version of Access you have, and what program is in the way and how it
interacts with Access. They may have a work-around to let you update your
Access database, rather than reinventing the wheel.

Good luck!
Ed