How can I use my queries?

  • Thread starter Thread starter hanski
  • Start date Start date
H

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
 
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:
 
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

hanski said:
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:
Click to expand...
 
Back
Top