Bill said:
Is the SQL Server engine essentially
a version of JET?
Well, it not a version of JET. So, no it not the same thing However, JET is
a database engine that ms-access uses to read the database. And, you can use
sql server with ms-access.
So, in the sense that both are just database systems that retrieve data,
then yes, they are similar.
However, JET is a file based system, and sql server is a server based
system. What this means is that JET is client only based. (the code and
system to gab data from the file runs on YOUR computer). with sql server,
the database engine runs on the server ONLY, and you make requests to that
server, and it gets the data.
If so, can one
access an SQL Server database
using VBA?
yes, you can. Not only can you use VBA, but you can build your forms as you
do now, but the data from the form can come from sql server. No code is
needed to do this. so, you can link your tables to a jet based file (a mdb
file), or you can link to sql server for your table data. once done, the
process of building a form is the same in both cases.
Neither JET, or sql server provides a interface option. To build a interface
to JET, or to sql server, you can use a tool like c++, VB, or in our case
ms-access to build the application side and interface.
