Access Database Homepage

Question: How to name parameter for access database in query builder of vs?

(Posted by: sadiq khoja on 2010-06-01 10:04:37)

I have a access database; In query builder how to name parameter for filtering. For sqlserver we can use '@xyz' so what is for access database.

Posted by: The Sinister Minister on 2010-06-02, 21:23:28

It has been a while since I worked with any parameterized Access databases, but it seems to me that I put the text to display in square brackets like so: SELECT * FROM table WHERE field = [What would you like to search?] Then, running the query would pop up an input box with the prompt: What would you like to search?

Posted by: Ben on 2010-06-04, 23:42:42

How to name Parameter for access database in query builder of VS? To understand and create a parameter query, please take a look at the following link: about-access-databases.com/ parameter-query.html It explains the concept and process of creating one. You can then always view the SQL to see how this will be added to any script or code for your database. Thanks Ben