473,324 Members | 2,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Compacting and repairing access 2000 db

Hi

Is it possible to compact and repair an external access 200 database via
code?

Thanks

Regards
Mar 25 '08 #1
5 1012
"William Vaughn [MVP]" <bi**********@betav.comwrote in news:F207E931-
0C*************************@microsoft.com:
Ah, no. It takes JRO.
Isn't JRO part of ADO?

That's what the knowledge base article says. Ha Ha.

--
sp**********@rogers.com (Do not e-mail)
Mar 25 '08 #2
Not in any build/deployment I've seen... but it's been awhile.

--
__________________________________________________ ________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
__________________________________________________ __________________________________________
"Spam Catcher" <sp**********@rogers.comwrote in message
news:Xn**********************************@127.0.0. 1...
"William Vaughn [MVP]" <bi**********@betav.comwrote in news:F207E931-
0C*************************@microsoft.com:
>Ah, no. It takes JRO.

Isn't JRO part of ADO?

That's what the knowledge base article says. Ha Ha.

--
sp**********@rogers.com (Do not e-mail)
Mar 25 '08 #3
"William Vaughn [MVP]" <bi**********@betav.comwrote in
news:1C**********************************@microsof t.com:
Not in any build/deployment I've seen... but it's been awhile.
>That's what the knowledge base article says. Ha Ha.
BTW, I was just being sarcastic ;-)

--
sp**********@rogers.com (Do not e-mail)
Mar 25 '08 #4
>
BTW, I was just being sarcastic ;-)
I thought it was meant to help Bill.

As is proven is everybody using forever the same ways to solve things (and
tell about that).

In my idea does another light on that helps to improve that.

Cor

Mar 26 '08 #5
On Tue, 25 Mar 2008 19:44:16 GMT, Spam Catcher <sp**********@rogers.comwrote:

¤
¤ Ah, no. It takes JRO.
¤
¤ Isn't JRO part of ADO?
¤

Different library, actually an extension to ADO since it lacks the functionality - but they're both
installed via MDAC.
Paul
~~~~
Microsoft MVP (Visual Basic)
Mar 26 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Peter Verhelst | last post by:
Hello, Currently I am running an Access database on a windows WTS server, running Microsoft Windows 2000 server 5.00.2195 Service Pack 3. This database should be accessible for everybody in our...
0
by: John H | last post by:
I have an Access 2002 database (1 table, 250 fields, 220 records) from which I can't export to .csv format. It exports about half the records, and then I get a dialog that tells me that the...
5
by: lappy | last post by:
Hello, I have written a small programme to compact an access 97 database. Dim je As New JRO.JetEngine ' Compacts database Data.Mdb to Data2.mdb. je.CompactDatabase...
3
by: Ken Davis via AccessMonster.com | last post by:
I get this error message when trying to compact and repair my database: (Could not find field "Description"). When I clicked on Help, the error message number comes up as (Error 3799) It's the...
2
by: shalini0702 | last post by:
Hi, I am facing problem of Missing Records in Table after Compacting and Repairing. Suppose my table had 486 records before compactig and after compacting I see only 485 records, One records has...
2
by: gibsonsgman | last post by:
hello, i have a question about compactin/repairing a database at runtime. i have code that will do this, but when it runs i get the error "You can't compact the open database while running a...
5
by: MightyAC | last post by:
Corrupt data in an access database seems to occur far too often. What's worse is that compacting an access 2000 or later db with corrupt data can result in the destruction of relationships. It...
1
by: Slez via AccessMonster.com | last post by:
I do a routine compact and repair on a back end MS Access 2002 database. This time I had something peculiar occur. The compact started as normal, than the following error message popped up (I...
3
by: DSSMaster | last post by:
I am trying to use windows scheduler to compact a database. In the task run line I have the following: "C:\Program Files\Microsoft Office\OFFICE11 MSACCESS.EXE" _ "C:\Files\Access\Sacroc.mdb"...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.