Shanan212
asked on
The minimum requried version to change the design on Access
The Microsoft Office Access database engine cannot change the design of "FILENAMEHERE.accdb"
The minimum requried version to change the design is 14.0.0000.0000.
Hi,
When I try to compact and repair the database (I am not sure when this massive 600mb one was created), it gave the error message.
I have to clean up this database (never compacted so it accumulated junk) What is the best option going forward considering it has many queries and such?
My thought was (and worst case), I ll have to export queries and tables to new db. In this case, would queries maintain their relationship, etc (instead of giving an #REF error like excel sometimes do)
Thanks!
ASKER
The current version is 2007.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ow its 633mb to be exact :o
I will try doing it on 2010 computer and post back fast!
I will try doing it on 2010 computer and post back fast!
Not doubt C&R will dramatically shrink that ...
mx
mx
ASKER
It brought down the database by 100mb to 533mb
I still do have about 200,000 rows x 35 columns of data (time to clean that)
Thanks!
I still do have about 200,000 rows x 35 columns of data (time to clean that)
Thanks!
cool. For fun .. Zip it up and note the size ...
mx
mx
ASKER
It came down to 100mb :o
What does this means though? (I mean going down in size by this much?)
What does this means though? (I mean going down in size by this much?)
It means there is a LOT of dead space ... and that Win Zip is an AMAZING tool ... seriously.
mx
mx
ASKER
oO aah I see...there are dead space among rows and such! Thanks!
Anytime you delete any object(s) ... form, code, queries, etc ... as well as data ... it's only 'flagged' for deletion internally. You don't 'see' it, but it remains until a C&R is done. Other thing affect bloating also ... just 'normal' use ... reading/writing data, etc.
mx
mx
mx