• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2526
  • Last Modified:

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.

Open in new window


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!
0
Shanan212
Asked:
Shanan212
  • 6
  • 5
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
What version of Access are you using to do this C&R ?

mx
0
 
Shanan212Author Commented:
The current version is 2007.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Well, 14 is 2010.  Can you upload. I have A2010 ... I can see what message I get ...

mx
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Shanan212Author Commented:
Ow its 633mb to be exact :o

I will try doing it on 2010 computer and post back fast!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Not doubt C&R will dramatically shrink that ...

mx
0
 
Shanan212Author Commented:
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!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
cool.  For fun .. Zip it up and note the size ...

mx
0
 
Shanan212Author Commented:
It came down to 100mb :o

What does this means though? (I mean going down in size by this much?)
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
It means there is a LOT of dead space ... and that Win Zip is an AMAZING tool ... seriously.

mx
0
 
Shanan212Author Commented:
oO aah I see...there are dead space among rows and such! Thanks!

0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now