Simple Inventory system

[Henrik]

Hi all,

I'm a .net developer working with developing automation equipment for the
sawmill industry. The main focus of our product line is mechanical and
measurement equipment but our clients start asking us for an inventory system
to keep track of their produced volume.

I am new to this area (all I've done so far is store production data in a
SQL DB and create daily production reports). What we are asked to do is a
simple inventory system where our customers can keep track of the produced
artichles and create inventory reports.

The simple flow is something like this:

1. A produced item is inserted in the inventory when it is produced. Some
properties of the item like article ID, volume and maybe more is inserted.
This is done by an operator at the delivery bay of the mill.
2. The item is removed from the inventory when it is shipped to a customer.

What could be a suitable plattform for this? Are there any simple products
like this on the market? Is this a job for Access?

NOTE: I'm not interested in a full scale inventory system like what you can
get from MS Dynamics.

Thanks

 

[Wei Lu [MSFT]]

Hello henrik,

I am not sure what's the detailed request from your customer.

Do you want to use a Web Front-End to provide a web interface to the
customer?

If so, I think you could develop a ASP.NET web site to provide such kind of
the web interface and use Access as the back-end database.

You could use the Access as a database like SQL Server . The only different
is the connection string and the data class you use in the .Net project.

For detailed information of the ASP.NET Data Access, you could refer the
following articles:

http://msdn2.microsoft.com/en-us/library/02se1ya4.aspx

If you do not want a web interface, you could develop some form in the
Access and add your vba code in the Access.

And, you could design reports in the Access to print.

For more detailed information, you could refer the sample database
NorthWind in the Access.

Here is some article for your reference:

Sample Access databases that you can download and adapt
http://office.microsoft.com/en-us/assistance/ha011201381033.aspx

Sample databases included with Access
http://office.microsoft.com/en-ca/assistance/HP051886201033.aspx

Hope these information will be helpful!

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

 

[mnature]

DBA Manufacturing puts out a very nice package, which includes an inventory
system. The nice part is that it is free for use on one workstation (they
charge a fee for any additional workstations). They also have tutorials for
using the different modules. Even though Access is very suitable for this
type of application, sometimes it is nice to get a canned software to put
into place immediately.

http://www.dbamanufacturing.com/