Re: JRO replacement?

An 'Access database' is a Jet database. You can't use an 'Access database'
and not use Jet. If you don't want to use deprecated components, you'll have
to stop using an 'Access database'. Alternatively, you could just stop
worrying about it. Deprecated or not, Jet is not going to go away anytime in
the foreseeable future.

--
Brendan Reynolds (Access MVP)

"JMB" <JMB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:48BB183D-FD21-4B34-ADE3-A6DA2E091525@xxxxxxxxxxxxxxxx
> 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: Multi user VB6 Access Backend Database
    ... the UI and development tool for Jet and other DB engines) is why there ... It deals, more often, with multiple users of Access sharing datatables in a ... HAVE "multiple users OPENING an Access database". ... There's an introductory presentation on Access in a Multiuser Environment ...
    (microsoft.public.vb.database)
  • Re: Fastest record create method with JET 4.0
    ... need to push records into an existing Access database. ... and so am trying to use the Jet 4.0 engine. ... This makes it sound as if you are using a cursor. ... I understand that DAO would be faster, as it is Access / Jet specific. ...
    (microsoft.public.data.ado)
  • newbie - VB.net and MSDE / JET question
    ... front end for an Access database (Jet). ... The texts that I've purchased all show how to connect to an Access Database ... have the first clue at using MSDE or SQL Server (not to mention that I can't ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Custom Functions in SQL
    ... In this case Jet can't recognize your function, because it is located in VB, ... > I have created a access database with a module containg a custom ... > be used in a sql query. ... > native VB string functions such as instr, ...
    (microsoft.public.vb.database.ado)
  • Re: update 500000 records with adodb.recordset resize the mdb from 140M to 2G
    ... >I have an access database with one table ... I believe there is a 2GB file size limit on Jet files. ... > text and numeric fields are updated. ... to SQL Server.) ...
    (microsoft.public.vb.database.ado)