Access "Invalid Argument" Message

[Guest]

I have researched other questions about this message and it appears that my
database is too large, therefore I am not allowed to import any other tables
into it, but here is my problem; I am trying to build a database that will
hold a table for every week since 2004. As of right now I have 26 weeks in
and the database is too large and I get the invalid argument message. Is
there any suggestion as to how I can get the rest of the data in the database
without having seperate databases.
thanks.

 

[Guest]

Hi Chase,

You need to read up on Database Normalization. You should not have a
separate table for each week. Here is a link to get you started:

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

How large is your database currently, and which version of Access are you
using?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Your post title does not fit your discussion!

First click on TOOLS - Database Utilities - Compact and Repair Database.

Next you need to change your database structure so you do not have a table
per week but one table with a date field to indicate what week.

 

[John Vinson]

I have researched other questions about this message and it appears that my
database is too large, therefore I am not allowed to import any other tables
into it, but here is my problem; I am trying to build a database that will
hold a table for every week since 2004. As of right now I have 26 weeks in
and the database is too large and I get the invalid argument message. Is
there any suggestion as to how I can get the rest of the data in the database
without having seperate databases.
thanks.

STOP.

The problem you're having is NOT with Access - it's with your
incorrect table design.

"A table for every week" is simply incorrect design for a relational
database. You're storing data - dates - in the table name. It should
instead be stored IN THE TABLE.

Rather than 52 identically-structured tables, you need *one* table
with an indexed (non-unique) field (date/time, or week number,
whatever meets your needs) to indicate which week this record applies
to. You can easily create a Query to extract the week of August 12,
for example; this Query can be used in exactly the same way you would
use your table.

The size limit on Access .mdb files is 2 gigabytes; is your database
approaching this limit? Have you used Tools... Database Utilities...
Compact and Repair?

John W. Vinson[MVP]