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!
LVL 13
Shanan212Asked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Well, 14 is 2010.  Can you upload. I have A2010 ... I can see what message I get ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
What version of Access are you using to do this C&R ?

mx
0
 
Shanan212Author Commented:
The current version is 2007.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
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 Access MVP)Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.