Alternative JET ?-VBForums
Results 1 to 15 of 15

Thread: Alternative JET ?

  1. #1

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    120

    Alternative JET ?

    Does anyone know of an alternative JET driver? I'm aware of VistaDB so alternative(s) do exist.


    Anyone know of any apart from VistaDB? .Net Managed. ie 'AnyCPU' capable able to read/write MDB file.

    Cost isn't the problem so not (necessarily) looking for a freebie.

    Thanks
    Ian
    Last edited by Axcontrols; Jul 17th, 2017 at 09:04 AM. Reason: Highlight word "AnyCPU"

  2. #2
    PowerPoster
    Join Date
    Oct 2013
    Posts
    2,711

    Re: Alternative JET ?

    You want to use MDB files, but you don't want to use ADO?
    Any specific reason for this?

  3. #3

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    120

    Re: Alternative JET ?

    I guess you didn't see my mention of "AnyCPU"? (ie able to run 64bit)

    .Net's build in driver is ONLY 32bit so applications developed to use that must be built to target x86.

  4. #4
    PowerPoster
    Join Date
    Oct 2013
    Posts
    2,711

    Re: Alternative JET ?

    Sorry I think I don't understand your request.

    Do you want a specific 64 bit driver or do you want your application to run on both 32bit and 64bit WinOS?


    https://www.altova.com/Access-Databa...bit-64bit.html

  5. #5

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    120

    Re: Alternative JET ?

    Sorry if I did not give enough information. I thought the word "AnyCPU" would be enough for any .net developer to understand my original question.

    The link to Altova is their page explaining how to install a 64bit version of ACE. But (unless I missed it) it did not explain what happens if the user already has a 32bit version of ACE installed. Instead it says:-

    There is currently an unfortunate limitation of the 64-bit ACE driver – it cannot co-exist with 32-bit versions of Microsoft Office.


    I have no control over what version of office the user may have installed or wish to install in future. So, in my mind, ACE is not the solution.

  6. #6
    PowerPoster
    Join Date
    Oct 2013
    Posts
    2,711

    Re: Alternative JET ?

    But I thought if you used ADO.Net on an MDB file then this would be independent of the used MS-Office version.

    Maybe we'll need to wait for the real .Net / DB developers to jump in.

  7. #7

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    120

    Re: Alternative JET ?

    Quote Originally Posted by Arnoutdv View Post
    But I thought if you used ADO.Net on an MDB file then this would be independent of the used MS-Office version.

    Maybe we'll need to wait for the real .Net / DB developers to jump in.
    Yes. Using the Ado/OleDB/Jet driver that is built into the .Net framework is fully independent of any version of MSOffice installed on the machine.

    But ADO/OleDB/Jet drive is ONLY in the 32bit framework. It does not exist in the 64bit framework so any attempt to call it while running in 64bit mode will crash.

    Your other suggestion, ACE won't work either. ACE is not part of the .net framework. ACE is the access driver installed by MS Office. .Net applications can use ACE but problems will occur if the .net application is not the same 'bit-ness' as the version of office installed on the machine. Currently default install of office is 32bit so, in most cases, 32bit office will be installed which means a .net application that relies on ACE can not run in 64bit mode.

    I suspect a few of the .Net developers won;t even read this thread now that there's a lot of answers on it.

  8. #8

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    120

    Re: Alternative JET ?

    So. to clarify once again

    Apart from VistaDB does anyone know of a replacement for the .Net OleDB/Jet driver. One that is .Net Managed. ie 'AnyCPU'.

    I repeat. Target "AnyCPU"

    Please don't suggest ACE

  9. #9
    PowerPoster
    Join Date
    Oct 2013
    Posts
    2,711

    Re: Alternative JET ?

    And you can't just create a 32bit application? These work on both 32bit and 64bit versions of Windows.

    Sorry for ruining your thread.

  10. #10

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    120

    Re: Alternative JET ?

    I'm very sorrty Arnoutdv.

    I know I can build x86. I do understand WOW64. But that does not answer the question. I do not want to build x86. As I mentioned at the top.

    I already have an x86 application. After amny years I am now looking to move away from x86 so I am now looking for an alternative to the oledb/jet driver that is NOT x86.
    Last edited by Axcontrols; Jul 17th, 2017 at 09:01 AM.

  11. #11

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    120

    Re: Alternative JET ?

    Quote Originally Posted by Arnoutdv View Post
    And you can't just create a 32bit application? These work on both 32bit and 64bit versions of Windows.

    Sorry for ruining your thread.
    Don't applogize for ruining the thread. You didn't ruin the thread at all. I suspect there is no alternative jet driver. So I have enjoyed our debate.

    and I hope the information I gave you about 32bit OleDB/Jet and 32bit-vs-64bit ACE is of some use to you in future.
    Last edited by Axcontrols; Jul 17th, 2017 at 09:07 AM.

  12. #12
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    39,031

    Re: Alternative JET ?

    JET is not part of the .Net framework, it is part of Windows.

    While ACE used to only allow 32-bit or 64-bit, it now apparently allows both on the same computer. I haven't had a need for several years, so I don't have any useful info to set it up - it should be easy to find tho.


    Also note that there are several alternatives to .mdb files, depending on your circumstances. These include SQL Server Express, and SQLite (which is the current recommendation for local single-user databases from many people, apparently including Microsoft).

  13. #13
    Frenzied Member
    Join Date
    Jun 2015
    Posts
    1,292

    Re: Alternative JET ?

    Quote Originally Posted by si_the_geek View Post
    While ACE used to only allow 32-bit or 64-bit, it now apparently allows both on the same computer. I haven't had a need for several years, so I don't have any useful info to set it up - it should be easy to find tho.
    Really? That's awesome news. MS initially screwed that up so badly, It was comical.

  14. #14

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    120

    Re: Alternative JET ?

    Quote Originally Posted by DEXWERX View Post
    Really? That's awesome news. MS initially screwed that up so badly, It was comical.
    I think it's still screwed. Any solution I've seen to get both 32 and 64 bit ACE drivers involved poking about in the registry to hack it in there so probably not supported by MS and therefore something I wouldn't do to my users.

    But if there is an official method it would be great if somebody linked to it. Thanks. Ian

  15. #15

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    120

    Re: Alternative JET ?

    Quote Originally Posted by si_the_geek View Post
    ..... and SQLite (which is the current recommendation for local single-user databases from many people, apparently including Microsoft).
    Yes. MS are recommending SQLite. I will add that SQLite is fast. Very fast. Faster than Jet I would say. At the moment, that's what I'm developing on. But I'm still interested in the MDB file format.

    But, to get the thread back to the original question - Ignoring alternatives to MDB files. I'm curious to know if there is there any way for an "AnyCPU" .Net application to read/write MDB files.
    Last edited by Axcontrols; Jul 17th, 2017 at 10:03 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.