Beginner question

[Marco Simone]

Hi,

I hope someone can answer my questions, as I am beginner in Access.
1. How many fields can be in table (what are limitations of access?),
because I would have to enter table with more than 150 fields.
2. Can I develop in access stand alone application, so that I don't have to
open access for running application.

Thanks in advance,
Marco

 

[Ed Warren]

Answer:

You can add 150 fields to an access database.
You can deveop (using Access as the data source, programs in dotnet that do
not require opening Access).
If you build the application in Access, of course opening Access is
required.

Real question is why one needs so many fields in one table; take a look at
your database structure and "normalization". You are most likely not at
"third normal form".

Hope this helps

Ed Warren

 

[Ed Warren]

Answer:

You can add 150 fields to an access database.
You can deveop (using Access as the data source, programs in dotnet that do
not require opening Access).
If you build the application in Access, of course opening Access is
required.

Real question is why one needs so many fields in one table; take a look at
your database structure and "normalization". You are most likely not at
"third normal form".

Hope this helps

Ed Warren

 

[Marco Simone]

Thanks for reply. I think I will make 2 tables instead of one, so I will not
have so many fields in table and database will be "normalised".
I think that learning dotnet is not easy, although I would like to learn and
use access as data source.

Marco

 

[Ed Warren]

Just breaking the table up into two is not the real answer.

You need to put the table into "third normal form".

This reduces the size of the database and improves the retrieval process.

You very well may end up with many tables linked via primary/foreign keys.

Do a google search for : Codd third normal form. Then find a paper suits
your level and needs for further information.

Good luck

Ed Warren

 

[Lloyd H. London]

I am far from the expert that many who read and respond here are, but I
would surmise that with 150 fields, you will be far from normalized with
2 tables. I recently created a DB with 34 fields in six tables and it
is not in compliance with the third form .
You might find reading some mateials on the first three normal forms,
and Boyce Codd to be valuable. Many intermediate level reference books
should contain what you need.

 

[Immanuel Sibero]

Hi

If you build the application in Access, of course opening Access is
required.

You can build your application using the Developer Edition and distribute
your application along with "Access Runtime". This way your users do not
have to have Access to open your application.

Immanuel Sibero

 

[Marco Simone]

Thanks,
Marco

Hi


You can build your application using the Developer Edition and distribute
your application along with "Access Runtime". This way your users do not
have to have Access to open your application.

Immanuel Sibero