logic of tables

[Guest]

i really would like some input on how i should set up tables on a db that
holds manufacturing information. parts that are made up of many parts and
other subassemblies. i've went through help information for the past week
and just cant find a way to do it. because some subassemblies are used on
more that one finished part. any discussion on this would be awesome!

thanks
--

 

[Guest]

What you are describing is a fairly complex, but not unusual, structure. You
wont find it in Help.

This is usually done with an additional table. You will have your regular
inventory table that will contain each item whether it be an assemply, a sub
assembly or an individual part. The additional table will be a child table
to the inventory table. It will have an entry for each part that makes up
the part. By that I mean, if a Widget is an assembly and it take 1
Fladratchet, 3 Flubber rings, 2 Wandaggles, and 1 Foogasket to create it,
then the additional table would have a reference back to the Inventory table
for each of those parts. Each of the records should show the quantity
required for each part. As to the Where Used part, you can do that with a
query based on the additional table joined to the inventory table.

 

[Douglas J Steele]

This is always a difficult subject.

Take a look at http://www.mvps.org/access/modules/mdl0027.htm at "The Access
Web" for one approach. http://www.mvps.org/access/queries/qry0023.htm shows
another approach.

 

[Guest]

i have access 2003 and am unable to open it
--

This is always a difficult subject.

Take a look at http://www.mvps.org/access/modules/mdl0027.htm at "The Access
Web" for one approach. http://www.mvps.org/access/queries/qry0023.htm shows
another approach.

 

[Guest]

i'm not sure i follow completly. i understand the main inventory table but
the child table i'm unsure of. would the 1

Fladratchet, 3 Flubber rings, 2 Wandaggles, and 1 Foogasket

be seperate records or fields?

 

[Douglas J Steele]

What do you mean by "unable to open it"? Access 2003 should open Access 97
databases without any problem.

 

[Guest]

msg box says that the file is read only and the first time its opened, user
needs to be able to make changes

 

[Douglas J Steele]

Let Access convert it. If you don't get the option when you open it, look
under Tools | Database Utilties | Convert

 

[Guest]

as soon as i click on it, that message box opens up. i doesn't give me any
option--it stops me. access opens up and so does the msg box

"You are trying to open a read-only data base

The first time you open an earlier version database, you must be able to
write changes to the data base.
*the data base file's read only attribute may be set; clear this attribute.
*you may have chosen the Open Read Only command in the open dialog box.
Don't choose this command the first time you open the data base (i was not
given this choice)
*Your license to use this application may have expired."

this is Exactly what it says. i stops me here--i can't go to tools until i
close the box

 

[gls858]

as soon as i click on it, that message box opens up. i doesn't give me any
option--it stops me. access opens up and so does the msg box

"You are trying to open a read-only data base

The first time you open an earlier version database, you must be able to
write changes to the data base.
*the data base file's read only attribute may be set; clear this attribute.
*you may have chosen the Open Read Only command in the open dialog box.
Don't choose this command the first time you open the data base (i was not
given this choice)
*Your license to use this application may have expired."

this is Exactly what it says. i stops me here--i can't go to tools until i
close the box

Did you check to see if the read attribute is set? If you copied
this file from a CD then it's set to read only.

Open Explorer find the file right click select properties and
look at the bottom of the dialog box. There should be a check box
that says read only. Uncheck it.

gls858

 

[Guest]

it's a file off the internet mvp.org i think

 

[gls858]

it's a file off the internet mvp.org i think

OK but did you check the read attributes?

gls858

 

[Guest]

when i click on it (it's a zip file) i asks if i want to open or save (i've
done both). if i check the properties, there is a greyed out box that say
read only, hidden

there is nothing i can check off unless i am looking at the wrong place

 

[gls858]

when i click on it (it's a zip file) i asks if i want to open or save (i've
done both). if i check the properties, there is a greyed out box that say
read only, hidden

there is nothing i can check off unless i am looking at the wrong place

Sounds like your looking in the right place. Are you saying that the file
won't unzip? Is the suffix to the file .zip or some other compression type.

gls858

 

[Guest]

the file unzipps

i had a similar problem at work one time. the data base was in 97 and my
computer only had 2003. if i wanted to open it, i had to use some one else's
computer.