Re: How To Return Record Number From AddNew


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:uw3PF5L6HHA.5316@xxxxxxxxxxxxxxxxxxxxxxx
Jeff Gaines wrote:
On 27/08/2007 in message <ecOJhlJ6HHA.5160@xxxxxxxxxxxxxxxxxxxx> Bob
Barrows [MVP] wrote:

<snipped>
Since this works then presumably I have version 4?

No, but it's backward-compatible in my experience. I have read some
admonitions here and there against using the 4.0 driver against an A97
(Jet 3.51) database, but I have never run into any issues.


To amplify on this a bit.

There is a difference between Jet Database Engines and Jet Formatted
Databases. (And to some extent the data access library employed.)
Unfortunately, programmers tend to think of them as the same and assume they
are using a particular Engine just because the Database is a particular
format. That's because one can mix them and through the services of
translators come out just fine.

Note the table in the following article (required reading whenever you work
with MDBs):
http://support.microsoft.com/kb/303528/

Problems can occur if different 'Engines' (or translators) are used at the
same time on the same database file. Data corruption was a practical
certainity if Jet 3.5 and Jet 2.0 are used to access the same Jet 2.0
database, due to datatype differences. Later Engine/Formats combinations are
less sensitive, but it is still dangerous to mix 'n match and best to avoid.

-ralph





.

Relevant Pages

  • Re: Database Connectivity
    ... Never was Jet mentioned anywhere at anytime. ... >> Microsoft Access Database Solutions, with not a single mention of Jet. ... front end, and the underlying database engine, JET. ... like SQL Server, Sybase, MySQL, etc. ...
    (comp.lang.python)
  • Re: Do not want data to auto sort
    ... you are deluding yourself if you think viewing data in the Access ... > in for a shock here but Access is not a database. ... The 'database' in question in usually Jet (it could be ... > then open a recordset write a the first portion of the data to a grid ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Any reason why accessing Access should slowdown?
    ... On the MSACCESS / JET OLEDB front, you responded to a query I had about the ... Declared connection to Access database using string based on Jet OLDB ... Set up recordset filter in response to earlier input / selection ... ¤ I am writing a VB6 App using an Access database backend ...
    (microsoft.public.vb.database)
  • Re: Explorer CPU Usage while accessing database
    ... Since Jet is a file-based database, the answer is: ... I suspect you are seeing the Jet delayed-write system in action. ... creates an idle period, during which Jet (and any other processes that are ... opening your connection before each insert and closing it immediately after ...
    (microsoft.public.scripting.vbscript)
  • Re: Do not want data to auto sort
    ... > semantics are interesting, but don't really add anything to the topic. ... in for a shock here but Access is not a database. ... 'Access database' you can usually take it as read that they mean 'Jet ... then open a recordset write a the first portion of the data to a grid ...
    (microsoft.public.access.tablesdbdesign)