Re: JRO replacement?

Thanks for your response, but I'm still confused. The Data Access
Technologies Roadmap lists Jet right along with JRO as a deprecated component
that shouldn't be used. The solution in the article you referenced says it's
using Jet 4.0.

Also, I don't know C++ so don't really understand the sample code in the 2nd
article. Is there a VB.NET or C#.NET code sample?

"Frank Hickman [MVP]" wrote:

> "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

  • Re: JRO ActiveConnection Property
    ... Since ADO and JRO ... >>> when you move to ADO as your standard data interface to Jet. ... since there's absolutely no reason to use ADO with Jet ...
    (microsoft.public.access.replication)
  • Re: Type mismatch in 2007 but not in 2003 version
    ... gift of an enhanced DAO, so I notice DAO is now the default data ... back in the mid- to late1990s, Jet was important to ... Microsoft's Universal Data Access movement via ADO, ...
    (microsoft.public.access.forms)
  • Re: Export relations from SQL Server Database to MS Access
    ... You wouldn't use DDL with DAO, you'd just use DAO, which is the ... needed to connect to something other than Jet). ... DAO, unlike ADO, ... all Jet objects as well as perform data access against the Jet engine. ...
    (microsoft.public.sqlserver.programming)
  • Re: QUESTION: Jet Engine Database Sizes???
    ... I've a hand-me-down App... ... I tracked it down to Jet 3.5 has a database size limit of 1.0gb... ... While VB, the Data Access Objects library, and the Jet ...
    (microsoft.public.vb.general.discussion)
  • Re: How to compact and repair by code
    ... I correct the jro error that you say, ... all the SP of jet, ... The DAO way is still not working, ... > In your JRO example, you need to get the value of the variables into the ...
    (microsoft.public.vb.database)