Classic ASP Discussion - access database

Print Page | Close Window

access database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=23561
Printed Date: 29 March 2026 at 5:16am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: access database

Posted By: raudet
Subject: access database
Date Posted: 19 June 2007 at 5:26pm

I want to make a query or a search in an access database without sql.

Is it possible

Replies:

Posted By: KCWebMonkey
Date Posted: 19 June 2007 at 6:36pm

SQL statements are the language to interact with databases.

Why would you specifically NOT want to use SQL?

Posted By: raudet
Date Posted: 19 June 2007 at 6:55pm

Because it cost $60.00 a month on the server.

Posted By: KCWebMonkey
Date Posted: 19 June 2007 at 7:28pm

You're thinking of SQL server... you don't need that because you said earlier you're using an Access database... SQL statements are just code that you use to interact with the database... see here for more info: http://www.w3schools.com/sql/default.asp - http://www.w3schools.com/sql/default.asp

Posted By: KCWebMonkey
Date Posted: 19 June 2007 at 7:29pm

and... $60/month for SQL server is ridiculous :)

</off topic>

Posted By: raudet
Date Posted: 19 June 2007 at 8:59pm

When I use statements like this on a server with no SQL possibilities it never works but when I use them in a server with SQL possibilities it works

strSQL = "SELECT nom2 " _
& "FROM [table2] " _
& "WHERE nom2 LIKE '%" & Replace(strSearch, "'", "''") & "%' " & "ORDER BY nom2;"

Set rstSearch = cnnSearch.Execute(strSQL)

Posted By: KCWebMonkey
Date Posted: 19 June 2007 at 9:23pm

what's the error when you try to execute the page?

Posted By: raudet
Date Posted: 19 June 2007 at 9:32pm

No errors just plain white page

Posted By: KCWebMonkey
Date Posted: 19 June 2007 at 9:49pm

hmmm....if the code had an error it should show up when you try to execute the page...

can you post a URL where you're running this code?

and, i'm assuming you have code to loop through the recordset to display results on the page?

Posted By: raudet
Date Posted: 20 June 2007 at 2:03pm

Hi I am back. I was out of town. And this morning I found my problem with strSQL="SELECT *.

Thank you so much helping me. You are great.

Posted By: raudet
Date Posted: 20 June 2007 at 2:06pm

Oh by the way, back to the first question, is it still possible to do the same thing but without sql statement?

Posted By: KCWebMonkey
Date Posted: 20 June 2007 at 4:31pm

nope