How can I use my queries?

[hanski]

I'd like to make an Access Project (.adp). My datebase is in MSDE and
it is working, but in my old Accessa (.mdb) I had a lot of queries and
in project there a no queries at all!! I suppose instead of queries
there are Stored Procedures? How can I use my old queries in a new
project? Is it possible to convert my queries to Stored Procedures?
How??

Hanski

 

[Duane Hookom]

Consider changing the queries to Views.

 

[hanski]

ok. I tried, but one problem.

In Access query if I want the user to input parameter I write: [Give
your name:] and when the user starts the query it will ask his name and
the user writes it, but in sql views it do not accept that kind of
asking. How do I ask, in sql views, parameters for the query?

hanski

Duane Hookom kirjoitti:

 

[Duane Hookom]

You might want to read up some on ADPs. There is some good info and examples
at
http://msdn.microsoft.com/library/d...n-us/odc_2003_ta/html/odc_landAccess00_ta.asp.
Possible read the "Access 2000 Project Guide" at that site.

--
Duane Hookom
MS Access MVP

ok. I tried, but one problem.

In Access query if I want the user to input parameter I write: [Give
your name:] and when the user starts the query it will ask his name and
the user writes it, but in sql views it do not accept that kind of
asking. How do I ask, in sql views, parameters for the query?

hanski

Duane Hookom kirjoitti: