By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,605 Members | 1,329 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,605 IT Pros & Developers. It's quick & easy.

Add more fields to Table

100+
P: 101
Hi,
My Project is in MS Access 2002.
Now I want to know that can I add more field to table.Its maximum capacity is 255 fields.But I want to add 10 more fields to that table.Is this thing possible?
Or I have to use another table.

I know this is simplr question so someone will reply me soon.
Thanks.
Jan 30 '08 #1
Share this Question
Share on Google+
7 Replies


jaxjagfan
Expert 100+
P: 254
Just a thought ...I think your data needs some serious normalization.

Would you mind telling us the type of data and some examples of the fields?

You can link together tables to cover all the required data elements.

Could you imagine going to a company and having to fill out a form with 300+ entries? Or trying to put 300+ data controls on a single form.

It would seem you need to approach your project from a different angle.
Jan 30 '08 #2

100+
P: 101
I am just making a Form for Data Entry.
In some cases people have to take readings and note down that readings on papers.They are taking readings on different timings.So its not fixed how many readings they will take.Some times they take 265 readings, which is the maximum limit. Uptil now they did this thing manually by writing on papper.But now my company want this thing computerized.I need only 10 more fields.
If I can do this then i can avoid to make another table and link it to others and so some of coding.But if I can't do this than its fine I will create new one.That doesn't matter only I have to do some more things.If I can than tell me how,.otherwise leave it i have to make another table.

thanks for ur reply
Jan 30 '08 #3

jaxjagfan
Expert 100+
P: 254
I am just making a Form for Data Entry.
In some cases people have to take readings and note down that readings on papers.They are taking readings on different timings.So its not fixed how many readings they will take.Some times they take 265 readings, which is the maximum limit. Uptil now they did this thing manually by writing on papper.But now my company want this thing computerized.I need only 10 more fields.
If I can do this then i can avoid to make another table and link it to others and so some of coding.But if I can't do this than its fine I will create new one.That doesn't matter only I have to do some more things.If I can than tell me how,.otherwise leave it i have to make another table.

thanks for ur reply
What sort of environment are you working in - what do you mean by "readings"

In an engineering environment, each particular piece of equipment (I.E. Low Pressure Air Compressor) has about 20 parameters (measures) which are taken at different intervals (timings) and for different reasons. If I had 4 of these compressors (LPAC's) and only operating 1 or 2 at any given moment, I would have a LPAC Log (formatted paper document with layout for taking "readings") for each LPAC running. In the entire plant, I may be taking readings on 20 or more pieces of equipment/systems - each with its own log.

Each different Log would represent a different table you would need to create. I would only need 1 LPAC table but make sure there is a field to capture which LPAC the readings are from (this is normally on the paper log as well).

I was an marine engineer for 16 years and during that time we went from paper to PDA as far as taking readings.

Are all of the readings coming from the same piece of equipment or system?
Jan 30 '08 #4

100+
P: 101
My company is filling & packaging perfume for some of the famous companies.
Now For that they used vials, bottles and tubes etc.
Now before start filling they have to check the vails,bottles and tubes that they don't have any problem.Bcz everything is doing automatic on various machies,so if they have any problem then it will creat a major problem.and all lines will stop bcz of that problem.
So before filling they have to test the vials,bottles,tubes etc.For that they perform some processes on that things.like vaccum test,cap torque test,weight test etc.
Now they take some readings for each test.and they perform each test at any time.Time interval is not define for that test, they perform it at any time.
So bcz of this things there are lots of readings.

By the way I create new table instead of saving all data in one table.But there is only one problem with that.For that I want to know how can I run two Query at the same time when I press submit button?
OR can I Insert values in two different tables using single query?

Do u have any Idea abt it?
Jan 30 '08 #5

100+
P: 101
Thanks For ur help.I got my solution.
Jan 30 '08 #6

jaxjagfan
Expert 100+
P: 254
Thanks For ur help.I got my solution.
Some further thoughts ...

Most of the packaging (vials, bottles, etc) will come in batches with a batch number. I assume you will be testing a random number of items from each batch but doesnt matter. You will need a table to track the Packaging Batch and quantity in the batch. And you will need a seperate table for each type of test.

Some possible table names and fields

tblPackage: batchID,Type,Name, Volume, Quantity, Medium (Medium would be like glass, plastic, aluminum, etc)

tblTest_CapTorque: batchID, batchItemNbr, TestDate, Testor, Measure1, Measure2, ......, Results, Comments

batchItemNumber - if you grab a vial out of a batch you may want to identify it. I'd use a sharpie and put a 1 or A on it and enter the same value in the table.
seperate table for each test type.

Put this all together with a main form for the batch or however you group the packaging. You would have multiple tabs on this form (tab for each test type). Each tab would be a subform which links to the main form.

These are just ideas as I don't know your processes. From a production standpoint QA is going to be involved at some point.

HTH
Jan 30 '08 #7

100+
P: 101
Ya we have some processes like these.But now I made diffrent tables and problem is solved only I wrote couple of lines more in coding for each table i created.But now no problem.
Thanks for ur help buddy.
Jan 31 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.