Re: query difference

On Apr 29, 3:18 pm, "Larry Linson" <boun...@xxxxxxxxxxxxx> wrote:
"bobh" <vulca...@xxxxxxxxx> wrote

> I'm talking about a JET backend............... so, are you
> saying that if I only select 5 fields(of a 35 field long
> record in a JET back-end table) in my query that it will
> bring back all fields of the records or will it only bring
> back the selected fields of the records??

I thought I was clear in saying that the Jet database engine resides and
executes on the user's machine, and that is where all extraction and
manipulation is done. Yes, you are correct: it will bring back all fields
of the entire record (and nearby records in the disk "page") and then,
locally, extract the 5 fields you requested. It uses the remote backend
just as it would an .MDB file on the local hard drive, only a lot slower.

Even if you have Jet installed on the back-end, it is not built to operate
as a server, so loading it there would not help.

Please note that I did NOT say, it brings back the entire database over the
network.

If you want the field extraction to be done on the server, so only the
requested fields will be returned across the network, you need to be using a
server DB for the back end: MS SQL Server, MySQL, PostgreSQL, Informix, one
of the Sybase products, Oracle, or one of many others. In that case, you
request the data from the server DB, it does the retrieval, manipulation,
and extraction, and then (mostly) sends you just what you asked for (there
are some minor exceptions if you are linked via Jet and ODBC).

Larry Linson
Microsoft Office Access MVP

That being said, regardless of what is serving up the data, you are
better off selecting only the fields you need rather than using a
wildcard (*) to pull all of the fields from the table.

Bruce
.

Relevant Pages

  • Re: query difference
    ... record in a JET back-end table) in my query that it will ... If you want the field extraction to be done on the server, ...
    (comp.databases.ms-access)
  • Re: 80004005 Unspecified Error
    ... every update that comes down the pike restricts access and hardens security. ... Just because your Jet database has none of Jet's security ... it has associated launch and activation permissions. ... It worked just fine (I had to restart my win2000 server) TILL I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Use DAO or ADO?
    ... SQL Server is more popular than Jet. ... real world of development, Dot Net", ADO has been superceded by ADO.NET ...
    (comp.databases.ms-access)
  • Re: [Access2003, VBA] Use DAO or ADO?
    ... One of the reasons my clients preferred Access / Jet / ODBC was that they ... Autonumber or its server equivalent and could have been shown to the users ... real world of development, Dot Net", ADO has been superceded by ADO.NET ...
    (comp.databases.ms-access)
  • Re: Access oder SQL-Server
    ... läuft die Jet Engine auch mit mehr als 20 Nutzern völlig rund und prima. ... Ein SQL Server ist technisch auf jeden Fall die bessere Variante. ... nicht nur 'nen Grundkurs belegt hast, hat mySQL fast 99% der MSSQL ...
    (microsoft.public.de.vb.datenbank)