Re: JRO replacement?



"JMB" <JMB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7623BEF3-61B6-4FEA-B2F5-C613E11A7022@xxxxxxxxxxxxxxxx
>I was just reading Microsoft's Data Access Technologies Road Map. It says
> that JRO is a deprecated component and that new applications should not
> use
> it and existing applications should be modified to not use it.
>
> I've also read that ADO.NET does not include the ability to compact an
> Access database. I use JRO to do this task. The roadmap says I shouldn't
> use
> JRO, but doesn't say what I should use instead. I need the ability to
> compact
> an Access database from my application. How should I do this instead of
> using
> JRO?

The Jet 4.0 Provider exposes a IJetCompact interface for this purpose.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprovjet_ijetcompact.asp

example;

http://support.microsoft.com/default.aspx?scid=kb;en-us;230496

--
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.


.



Relevant Pages

  • JRO replacement?
    ... it and existing applications should be modified to not use it. ... I use JRO to do this task. ... I need the ability to compact ... an Access database from my application. ...
    (microsoft.public.data.ado)
  • Re: JRO replacement?
    ... An 'Access database' is a Jet database. ... If you don't want to use deprecated components, ... >>> that JRO is a deprecated component and that new applications should not ...
    (microsoft.public.data.ado)
  • Re: MS Access Synchronization Problems using JRO
    ... > We are having problems replicating an Access database across servers using> JRO? ...
    (microsoft.public.data.ado)
  • Re: error message on ISAM
    ... I am trying to compact an Access database in VB 6.0 using code for jro. ... I'm seeing articles that indicate I have a dll not correctly entered in Windows registry. ... Any ideas on why I'm getting the ISAM error message? ...
    (microsoft.public.vb.database)
  • Re: Aus C# eine Access DB kompremieren
    ... siehe http://support.microsoft.com/?kbid=306287 ... How to compact a Microsoft Access database by using Visual Basic .NET ... JRO.JetEngine jro = new JRO.JetEngine; ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)