Can Access have too many feilds...

[outhere]

Hi,
I'm working with this database for a while now and as the weeks go by more feilds are needed so i add them. I was just wondering if it was possible to screw it up because of too many feilds, is there a limit...
Im aware that Access 97 cant handle databases greater than 1 gig but if it stays below that is that OK. Is that the same with Access 2000.

Thanks

 

[Dreamboat]

Why do you create a new field? What new fields are you adding? If you're adding date fields or something like that, then you're not using it the way it's intended. For instance, fields like:

name---week1data---week2data---week3data

are wrong.

It should be:

name---week#---data

If this doesn't make sense or doesn't help, answer my first few questions and we'll be able to help better.


techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[outhere]

hi,
thanks for the help what I meant was that our project is growing and we are needing to retain more information such as process dates, draft dates, second telephone ect...
I truly beleive we are using it well, its just a question of how many feilds can Access handle...I wouldnt want to come across some starnge errors in the futur,,just thinkin ahead..
thanks techsupportgirl
steve

 

[Dreamboat]

Your answer, and then some: (type "limitations" into the help file)

Microsoft Access database table specifications

Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048. The actual number may be less because of tables open internally by Microsoft Access.
Table size 1 gigabyte
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user interface;
1 gigabyte when entering data programmatically.
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) 2,000
Number of characters in a field property setting 255

Good luck!

techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[outhere]

Thanks, That was the answer i was searching for

Cheers
Steve