Compact Access DB using ADO & VB6 
Author Message
 Compact Access DB using ADO & VB6
I am trying to add a compact & repair utility to my application using the
method outlined in the article "HOWTO: Compact Microsoft Access Database via
ADO (Q230501)" on the MS support site. However, when I try to implement the
code, I get the following: "Runtime Error 2147467259(80004005) Cannot
perform this operation; features in this version are not available in
databases with older formats."  I working with an Access2000 database and
VB6.  Any suggestions on how to get around this?


Mon, 18 Oct 2004 02:46:35 GMT
 Compact Access DB using ADO & VB6

Hi Jeff,

Are you using Jet 4.0 provider. If you are using Jet 3.512
it will not work with Access 2000. Also check next link

http://www.able-consulting.com/ADOX_Faq.htm#Q7

Val

Quote:
>-----Original Message-----
>I am trying to add a compact & repair utility to my

application using the
Quote:
>method outlined in the article "HOWTO: Compact Microsoft
Access Database via
>ADO (Q230501)" on the MS support site. However, when I

try to implement the
Quote:
>code, I get the following: "Runtime Error 2147467259
(80004005) Cannot
>perform this operation; features in this version are not
available in
>databases with older formats."  I working with an

Access2000 database and
Quote:
>VB6.  Any suggestions on how to get around this?

>.



Mon, 18 Oct 2004 02:58:41 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to compact an access-db using ADO?

2. How to compact an access-db using ADO?

3. VB6, Access, ADO, and Compacting

4. Compact Access 2000 DB with VB6 Code

5. export data from one access db to same db on another machine using vb6

6. Problem with ADO accessing Access DB in VB6

7. How to compact ACCESS db in ADO

8. Compacting Access-db with ADO

9. Compact password-protected Access DB through ADO

10. ADO, Compact and Repair, Access Db

11. ODBC Repair & Compact problem with Access DB

12. Compact & repair Access 97 db from VB


 
Powered by phpBB® Forum Software