Why connect to an access database?

[dominover]

Why do I need to connect to an Access database in my application? I can't seem to find a reason to.


If I can run expressions and queries without establishing a database connection then why do it?

Is it to update records only? I'm not sure.

[CJ_London]

think you need to clarify the background to your question - why do you think it is not necessary - provide an example of what your mean

[dominover]

Well this part is the crux of my question.

If I can run expressions and queries without establishing a database connection then why do it?

I know it's a technical question and I can understand if nobody understands it so please see the link below.

http://www.w3schools.com/asp/ado_ref_connection.asp

Is this the only reason to establish a connection to a database?

The ADO Connection Object is used to create an open connection to a data source. Through this connection, you can access and manipulate a database.
If you want to access a database multiple times, you should establish a connection using the Connection object. You can also make a connection to a database by passing a connection string via a Command or Recordset object. However, this type of connection is only good for one specific, single query.

[CJ_London]

If I can run expressions and queries without establishing a database connection then why do it?

you need a connection for data - ADO is just one way of doing it. If you are accessing tables within your db for your expressions and queries, you don't need ADO, instead you are using DAO. ADO can be used on internal tables if you are looking for specific functionality such as disconnected recordsets (something you can't do in DAO)

[dominover]

Ok. Thanks very much. I have been reading allot about ADO and DAO which has been the source of my question.
Thanks for the help.