Privet vsem.
Sudia po razgovoru v teme "Pochemu nikto n hochet ispolzovat adp", poniala chto rebiata dovolno uspeshno s etim rabotau. ia pitaus peretashit ACCESS2000 na MSSQL7, i ACCESS front_end na ACCESS project(adp). Ispolzuia Upsizing wizard, DB peretashila na MSSQL server(tablici, relationship), problema s Query. nekotorie ACCESS Query perepisalis kak Stored proceduri ili View, a nekotorie net.
Moi vopros sleduushii: kak peredat parameter s ACCESS Poject v Stored Proceduru na MSSQL.
naprimer: Select Customer_ID from Customer where Project_ID = @Project;(znachenie dli @Project nuzno brat s formi).
Esli kto znaet, pomogite pozaluista.

Spasibo Pavel, za sovet
Formu seichas zagruzaet s pravilnim parametrom, no ona prosit vvodit etot parameter.
Mozno li sdelat tak chtobi peredavale etot parameter avtomaticheski???

Esli ia pravilno poniala, to nuzno v Input Parameter postavit :@TEST int = [Forms]![TEST]![Pole],
Sozdat proceduru:
Create procedure ProcTest @Test int
as
select Customer_no from Customer
where Customer_No = @TEST

I potom v Properties dlia polia Customer na forme vizvat etu proceduru: EXEC ProcTest

Chto ne pravilno?
Spasibo

I tak i ne nashla otveta, kak peredat parameter s odnoi formi dlia otkritia voroi. Prichem eto rabotaet kogda pereadu parameter kotorii v Form1 bil ishodnim. Naprimer:Form 1 otkrivaetsia dlia opredelennogo "Project_No" i pokazivaet informaciu ob etom Projecte("Customer_No", "Supplier" i t.d.) , i kogda ia otkrivau Form2 parametrom dlia kotoroi sluzit "Project_No"(no drugaia informacia budet poiavliatsia), to vse rabotaet normalno. etom sluchae ia ispolzuu VBA code. A vot kogda mne nuzno otkrit Form2 s parametrom "Customer_ID", t. pokazat informaciu ob etom Customer, to ne otkrivaet.
Kto-nibud stalkivalsia s etoi problemoi.
Budu blagodarna za lubie predlozenia