Shrinking Access database size

[jasjol]

My Access database GBPVR.MDP is 224MB - and I guess I should be able to shrink it.

Does anyone know of a tool to do this?

(I do not have MSaccess)

[sub]

Yes, it will shrink significantly. I'm not aware of a tool that does it other than MSAccess.

[Ericwiz]

Microsoft has a tool for this.
Check this out
Jet Database Compact Utility

Hope that helps you out!

[KingArgyle]

This thread should give you the answer:
Could put this in PostUpdateEPG.bat and have it run after the episode guide is done updating:

http://www.experts-exchange.com/Database...81859.html

[smeghead]

OK, to save us all registering with experts exchange, what's the line in postupdateepg.bat?

[bgowland]

Quote[/b] (smeghead @ Feb. 11 2005,19:43)]OK, to save us all registering with experts exchange, what's the line in postupdateepg.bat?

<path>\msaccess.exe <mymdbname> /compact

You don't have to subscribe to EE to find this - try http://support.microsoft.com and search on the following...

msaccess command-line

Just went to EE, couldn't remember my password - they e-maled me a new one. Seems I've been subscribed since Nov. 1998 but the statistics show I've never answered any questions. Some expert that makes me!  

Cheers,
Brian

[bluesxman]

Quote[/b] (smeghead @ Feb. 12 2005,00:43)]OK, to save us all registering with experts exchange, what's the line in postupdateepg.bat?

No need to register, you just needed to scroll down a little bit!

[Ericwiz]

KingArgyle's answer is good if you have msaccess. If not look at the MS tool I mentioned above.

Or....

Go into your admin tools from control panel and select ODBC sources. Click the add button and select msaccess. One the next screen you can select the gbpvr.mdb and compact it right from there.

Using either method will cause you to have to stop the recording service and any MVP server or gbpvr client you have running.

Eric...

[Ericwiz]

Hey Sub,

I came across code to shrink an mdb from a .net project (see tek-tips.com). Because gbpvr has exclusive access I dont know if a plugin could be used but the code is easy. Is this something you might consider adding to the core?

Info follows:

Step 1:
Need to have MDAC2.6 installed on the computer (VS.NET insta­lls MDAC2.7) -> That works


Step 2:
write-click References in your VB.NET or C#.NET project, sel­ect Add
Reference. Click Com Tab and double click on "Microsoft Jet­ and
Replication Objects 2.6 Library" then click "OK" button twic­e. This will
add ADODB and JRO references to the project.


Step 3:
Use the following code (VB.NET):


Dim jro As JRO.JetEngine
jro = New JRO.JetEngine()
jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.­0;Data
Source=C:\...\nwind.mdb", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\...\newnwind.mdb;Jet OLEDB:Engine Type=5&quot


Engine Type = 5 for Jet 4.0 database (Access 2000 format).

[sub]

Yes, I'm aware of the code to shrink the database. The first public release of v0.23(.7?) included this shrink function, using pretty much the code listed above, but trying to distribute the JET/JRO runtime files with GB-PVR caused all sorts of problems. In the end I decided it was more trouble than it was worth, so I took the functionality out again.