Re: Access vs SQL

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Cor,

I think this is a symantics issue. I will agree that throughout the user
populance, many people refer to Access, MS Access, an Access DB, etc. as
being a database. While this has been / is acceptable for most people, I
believe what TC said is technically correct.

Most people open MS Access, create some tables, queries, forms, modules,
etc. and the language used to drive the front end is VBA (forms, modules,
etc). Most are unaware that the actual DB engine is not Access (as there's
no such thing), it's Jet (by default).

After loading MSDE, since it doesn't have a GUI, I am using MS Access, via
an ADP project, to make modifications to the MSDE DB (SQL Server DB). If MS
Access were, as you're implying, a database engine, you wouldn't be able to
change database engines in the product. Therefore, MS Access should really
be thought about and talked about as an IDE that supports several DB engines
(similar to VS.NET being an IDE that supports several programming
languages).

Again, I believe this is a symantics issue. Everyone knows/knew what I was
talking about, but, from now on, when I catch myself refering to an Access
DB, I'll replace that with a Jet DB with a front end built in MS Access, or
whatever DB engine I happen to be using.

Of course, if I talk to my clients about a Jet DB, I'll just get blank
stares and questions about what happened to the Access DB. ;-)

Cheers
Lee


"Cor Ligthert" <notmyfirstname@xxxxxxxxx> wrote in message
news:O7KASNaPFHA.164@xxxxxxxxxxxxxxxxxxxxxxx
> lgbjr,
>
>>And I also agree that MS Access as a product is not a database, it's an
>>IDE for developing a DB front end.
>
> As I wrote in my previous message this is not true, I have the idea you
> are talking about the MS office Access product. You can create an access
> database using ADO in your program as a part of your development.
>
> Cor
>


.

Relevant Pages

  • Re: I dont know how to link VB to database (ODBC) table.
    ... The Provider/Driver -> Uses a Connection String to access a Database engine ... The Jet engine -> Uses your data store. ... Under TextBox Property ...
    (microsoft.public.vb.general.discussion)
  • Re: Using python for a CAD program
    ... relational database models. ... While it might be possible to do this fast enough with Python, ... Basically what the retained mode engine does for you is it ... The retained mode engine will take care of things such as ...
    (comp.lang.python)
  • Re: I dont know how to link VB to database (ODBC) table.
    ... If you are using VB6 have you installed service pack for VB? ... Would try using ADO Data Control to check whether you can connect to ... whether I can connect to database or generate a connection string using this ... (In your case the "Jet Engine") ...
    (microsoft.public.vb.general.discussion)
  • Re: sorter script [was: Frustrated newbie question]
    ... was from the "perldoc -q sort" as a way of ... most 'elegant' of looking algorithms. ... that bogged the database engine down. ... was due to bad implementation on the db engine. ...
    (perl.beginners)
  • Re: Question about an embedded database engine
    ... I am looking for an embedded database engine for our analysis application. ... The requirements include a good SQL implementation and TDataset ... currently implemented as a user-interface module that can execute multiple ...
    (borland.public.delphi.thirdpartytools.general)