A 2010, Bites in Record

[Dick7Access]

How can I determine how many bites in each individual record?

 

[mcclunyboy]

I have done something similar in MS Access 2007...this maybe a little rough:

1. Open Access and your database
2. Click Database Tools
3. Click Database Documenter
4. Click Tables - Select All and Click OK
5. A report will be displayed, save this to .txt or something
6. Open .txt file (which maybe quite large depending on the file - I use wordpad) and search for your tablename. The information held within this will tell you the table size and record count.

I know of no way to determine the physical size of a record.. DB page files / extents I know about in other RDBMS but unforuntately I have never thought to find out how fundamentally Access works....sorry.

Are you receiving an error message stating you can't enter data or something?

Hope it helps...

 

[Dick7Access]

no, my wife has a db I made for her that has 40,000 recipes. She wants me to put some on CD so i am trying to determine how many will fit.

 

[mcclunyboy]

How big is the physical size of the database?

I assume you used the compact/repair to reduce the physical size a bit (you can always manually copy the db file when not in use to make a backup)

 

[Dick7Access]

Total Size is only 223 K, but she wants me to break it up by category. Each disc will have say Mexican, no gluten, etc. I can of course copy each rcipe into word and see how many bytes but that's too tedious. I doubt that she will fill a disc with any category, but she asked how many and being the family geek I thought I would take an ego trip via World Access Forum. I will just tell her as many as she wants. Thanks for answering

 

[Rx_]

two comments.

1. Guess you could open up each category in a function - perform a LEN on text and otherwise look into the data types (and hope you used a Long for calories in the dessert category LOL)
Did find this - don't know if the link is still good:
Access MVP Allen Browne offers a free utility that you can download which, among other things, will identify tables in your database that can potentially exceed 2000 characters. You can get a copy here:
Database Issue Checker Utility
http://allenbrowne.com/AppIssueChecker.html

2. The Mexican , no gluten example sounds great!
You are going to post this in the Sample Databases ... right!! (please)

 

[mcclunyboy]

I assume there is no field you can select certain data based upon...?

i am guessing that has been thought of...

 

[Dick7Access]

two comments.

1. Guess you could open up each category in a function - perform a LEN on text and otherwise look into the data types (and hope you used a Long for calories in the dessert category LOL)
Did find this - don't know if the link is still good:
Access MVP Allen Browne offers a free utility that you can download which, among other things, will identify tables in your database that can potentially exceed 2000 characters. You can get a copy here:
Database Issue Checker Utility
http://allenbrowne.com/AppIssueChecker.html

2. The Mexican , no gluten example sounds great!
You are going to post this in the Sample Databases ... right!! (please)

thats just the start, she has been collecting recipes for 23 years. She has no sugar, no salt, Italian, desserts, pastas, chocolate, cakes, pies, brownies. Thats just the ones I can think of, as I don't have her puter in front of me. She has fields for calories, protein, calcium, etc. The problem with the program is the old saying "garbage in garbage out. I tried to explain that she just couldn't put things all over the place, but typical wife thy don't listen. She put a whole bunch of things in a memo field now she wants to know why she can't sort some of it. Now that she wants to distribute some recipes she has to go back an correct them. After this mess I started giving her only combo box list so that she had to pick from a list. Of course the other old saying no programer ever made a program completely idiot proof. That is what hones my skills. Thanks for answering