[AccessD] Why no BOM on MSDN for Access?

Tom:

E-Z-MRP (www.e-z-mrp.com) handles complex bills of material including
phantom assemblies, up to ten levels.  Reporting includes indented costed
bills summary bills, and where-used, and a cost roll-up utility.  The bill
of materials database is the backbone of the MRP module which calculates
production and procurement schedules based on the user's independent
demands.

The biggest e-z-mrp database I ever saw had about 20,000 part master records
and about 70,000 product structure records.  At the time the app was running
on Access 97 and had 8 simultaneous users. The customer reported that
response times were more than adequate, and they never had corruption
problems.

So I think that Access, and in particular, the Jet engine, is more than
adequate to handle complex bills of material.  Of course, the trick, as in
any application, is structuring the data correctly with the output
requirements in mind.

HTH

Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Thomas Ewald
Sent: Saturday, July 25, 2009 1:44 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Why no BOM on MSDN for Access?

Microsoft includes a bill of material set of procedures in its
AdventureWorks sample database for SQL Server (listed on msdn), and mentions
Dynamics a lot, but lists nothing similar that I can find for Access at all.
I have found a little about it here are there on the Web, but not much. May
I ask the opinions of those on this list? Is Access inappropriate for a
complex exploding bill of material application?

Thanks.

Tom Ewald
Detroit Area

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com