Max number of fields in Access

[Chky071]

I have a unique database that I am building. I am new to Access and am trying to learn what the best practices are.

We are a manufacture and I am trying to build a database that captures all the unique features that define an individual product.

From these unique variables I can generate a BOMs, Production times, Box content labels, job tickets, etc. All this information is entered using a form, I want one location to input all the pertinent information to avoid having to enter anything twice.



The trouble I am having is that I have hit the 255 fields. I know that this typicaly means that there is a poor structure, however this is the amount of data required to define one product. Is it possible to split the database into two or more databases? I built a second database, but how do I sync the "Part Number" fields so that they always match each other?

Thoughts?

Thanks!!!

[amrut]

Never heard of so many fields in a database. If you are sure the db structure is correct, Create separate tables and join them on Primary key in One-to-One relationship. Can you post a screenshot of your table relationships ?

[orange]

chky071,

You say you are new to Access, and I have a suspicion that you are new to database. Don't confuse the two.

I can generate a BOMs, Production times, Box content labels, job tickets, etc. All this information is entered using a form, I want one locatio.......

Is it really can, or is it I hope to, generate ....?

In any database a table with more than 255 fields is so rare. Databases tables tend to be narrow (few fields) and deep (many rows).

Here are 2 tutorials and some free videos that may help put some of your database plans into context, and show you some of the underlying concepts involved.
Database tables should be Normalized to prevent all sorts of inconsistencies.

Bill of Materials is NOT a trivial subject.

I suggest you make a plan to identify what you want to build to support your companies processes and data needs.
However, I would not try to take on the whole thing at one setting. Identify something simple, but useful and get it working. Learn from the tutorials and videos and apply concepts to what you decide to build.

If, after the tutorials and videos, you still feel that 255 fields is limiting your effort, then please come back and tell us.

Here's a list of things you may want for reference.


Principles of relational Design http://forums.aspfree.com/attachment...2&d=1201055452
Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip

Video tutorials:
If you learn by Watching/Listening rather than reading.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

https://www.youtube.com/watch?v=lXAG...6FE5448948D9B4 E-R Diagramming Price and Quantity

Complete set of tutorials on Acc2010.
https://www.youtube.com/playlist?lis...FoilxbUY0yUqZP

Good luck with your project.