Tracking Inventory

[Diana]

Hi,

I am creating an inventory database that tracks server
parts. (Specifically I have 8 servers, the parts within
each server vary.) I want the quantity of the parts to
automatically deplete when a technician removes a part and
increase when a replacement is received and returned to
inventory.

I am trying to figure out the simplest way to do this. I
was advised to look into ASP (it will be web-based) along
with VBScript. So, I've been reading a couple ASP/VBScript
books I purchased, and I think I may be making this
database more difficult than it is.

Now I find myself flip flopping on how to proceed. There
must be a way Access can handle this task. Any
suggestions to help me simplify this is appreciated.

Diana

 

[Tim Ferguson]

Now I find myself flip flopping on how to proceed. There
must be a way Access can handle this task. Any
suggestions to help me simplify this is appreciated.

Access's Data Pages were meant to address this situation, but are only
relevant to an intranet where the client software environment can be
strictly constrained. In any case, I get the idea from this group that they
are not a great success nor very popular. I don't have any experience with
using them.

The best solution for a web application is, AFAIK, ... web programming! Jet
(as opposed to Access) can certainly provide the backend database, but you
might prefer the more stable and much more secure MSDE or SQL Server.

Specialist area though...

HTH


Tim F