Re: Reinstall Microsoft Jet 4.0

I don't think there's any uninstall for Jet. I expect if you uninstall
office, it will leave Jet installed. I think if you need to repair Jet, you
need to do it somewhat manually, and MS will have knowledge base articles
about this. Having said that, I would guess that the issue is probably Jet
settings and/or connection string settings rather than Jet being corrupted.
I don't know all the settings that well, but I know there's a whole bunch of
settings you can use for an OLEDB connection string (I expect that's the
type of connection string you're using). I'd have a look at the Jet
documentation, and the OLEDB connection string options for Access first.

Just googling, I also found this:
http://forums.overclockers.co.nz/showthread.php?p=287604

It mentions having problems dealing with Access memo fields unless you
update them in a particular order. Is it possible that something like this
is your issue, and the reason the component vendor doesn't have the same
issue is his table structure/query is different than yours and thus able to
avoid the problem? Looking at your table structure from the BDE newsgroup,
maybe it would work if you modified your table structure to be:

Method: String 255
Description: String 255
Category:: String 255
Comment: String 255
Author: String 255
Code: Memo

I put the Memo field as the last field in the table. Also I think I
mentioned before that you didn't have an obvious primary key field for your
table. Making sure your table has a primary key field may also help solve
the problem. Aside from giving Access better performance, a lack of a
Primary Key seems to cause issues in a number of database formats.


.

Relevant Pages

  • Re: Use ADO.net 3.5 to connect with Excel 2003
    ... I try to google and everywhere give me the same connection string. ... The OLEDB providers for JET shipped separately from the standard MDAC. ... In some versions of .NET, if not all, you have to install JET ... I cannot find the download page, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Use ADO.net 3.5 to connect with Excel 2003
    ... I try to google and everywhere give me the same connection string. ... I still get the sam message in my output window. ... The OLEDB providers for JET shipped separately from the standard MDAC. ... I cannot find the download page, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Use ADO.net 3.5 to connect with Excel 2003
    ... I try to google and everywhere give me the same connection string. ... The OLEDB providers for JET shipped separately from the standard MDAC. ... In some versions of .NET, if not all, you have to install JET ... I cannot find the download page, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO, ODBC, Service process
    ... I downloaded Jet engin 4.0 and used the connection string as you showed. ... (LocalSystem here who has no permission on the file server). ... >> ODBC dBase]'' is not a valid path. ...
    (borland.public.delphi.database.ado)
  • Re: Jumpstart using JET
    ... > It was an invalid timeserver entry, I assumed Mac OSX Server would do it out ... The best idea is to let JET look after the timeserver entry for you. ... The vast majority of settings in JET can be left at their default settings ...
    (comp.sys.sun.admin)