Asp & Access Db

[COSIDUS]

Hi,

Is it possible to use ACCESS Requests with ASP please ? I know how to use ACCESS Tables but not the Request... It could be VERY useful for me...

If someone could help...

Thank You

COSI

[alexmac]

What are Access Requests?

Alex

[COSIDUS]

Hi,

err... sorry I'm french and my technical english is not very good...

Access Requests = Access QUERIES (I forgot the word for queries)

Is it Better ??


COSI

[alexmac]

Hey your English is alot better than my French!

I am not sure how to use the queries stored in Access but all an Access query is is some SQL statements (okay sometimes it has some Access stuff as well but dont worry about that).

SQL is not that hard to learn. You can get the SQL version of the Access query from the Access DB by right clicking when in Design view of the query and selecting SQL view. You could then paste the code directly into the SQL statement.

For example the following code uses a SQL statement to select only customers called steve:

'define connection and open connection
set conn = server.createobject("ADODB.Connection")

'open ODBC connection
conn.open "connCustomer"

SQL="SELECT customerName From customerTbl WHERE customerName ='steve'"

set customerTbl=conn.execute(SQL)

Hope this helps.

Alex

[COSIDUS]

I know SQL a little...

But my problem is resolved now, because we can use Access Queries in SQL, as Access Tables...

Thank you

Cosi