Re: From .mdb to .adp database

ADP file, not like MDB, does not contains query. The queries you see in ADP file are SQL Server objects (Views, Stored Procedures and UDFs...). When converting, the queries in MDB may or may not be converted to corresponding SQL Server objects, depending on what is in the mdb queries. In your case, your query was conerted as stored procedure, which sits in SQL Server back end, and has no knowledge of your ADP front end (and it should not be tied to any specific front end at all), so the conversion smartly enough to a sptored procedure and converted the two required inputs as input parameters. Now, when you call this stored procedure in an front end application, such as ADP file using it as a form's data source, you need to get user input and pass the input as the stored procedure's parameters.

If you already have an Access application done in MDB file, the better approach would be to only convert data back end to SQL Server, and still use your MDB front end, with possible minor modification. After all, ADP type of application is dying.


"Nesta" <nestaman@xxxxxxxxxxx> wrote in message news:ul6lgVaEIHA.3916@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,

I'm testing migration from Acess database to ADP Project.
I have this query wich criteria of selection is the value of a textbox, in a form.
In my mdb database, the syntax was like : [Forms]![F_MyForm]![MyTextBox].

In my ADP project, i have noticed theses changes :
- my query was transformed into a function ;
- the syntax ro reach the value of my TexBox has changed (and obviously does not work) : = @Forms_F_MyForm_MyTextBox.

1) How to find the good syntax ?
2) Where can I find ressources on ADP syntax ?


Thanks by advance !

Nesta



.

Relevant Pages

  • Re: How do I create an MS SQL Server stored procedure from MS Access V
    ... MDB or ADP? ... Dim cnn As ADODB.Connection ... SQL Server stored procedure from Access 2002. ...
    (microsoft.public.access.modulesdaovba)
  • mdb to adp conversion
    ... I found a lot of documentations on converting older mdb to newer ones, ... But since adp is a relatively new file type, ...
    (microsoft.public.access.conversion)
  • Re: From .mdb to .adp database
    ... I decided to go on with adp project, and i have created a store ... But queries are different stories. ... In SQL Server, there are Views, Stored Procedures, UDFs. ... Also, when you decide to use MDB front-end, you can choose use MDB ...
    (microsoft.public.access.adp.sqlserver)
  • Re: From .mdb to .adp database
    ... there is no exact equivalent query object in SQL Server to MDB's query. ... Most likely, the wizard converts MDB queries to Viwes or SP, if the queries are convertiable. ... Also, when you decide to use MDB front-end, you can choose use MDB queries in the front end or use SQL Server side query objects. ... SQL Server is very powerful server software, whether you use MDB, ADP or anything else to access data from it, you MUST learn how to use it and almost for sure you need to learn another programming environment. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: From .mdb to .adp database
    ... there is no exact equivalent query object in SQL Server to MDB's query. ... Most likely, the wizard converts MDB queries to Viwes or SP, if the queries are convertiable. ... Also, when you decide to use MDB front-end, you can choose use MDB queries in the front end or use SQL Server side query objects. ... SQL Server is very powerful server software, whether you use MDB, ADP or anything else to access data from it, you MUST learn how to use it and almost for sure you need to learn another programming environment. ...
    (microsoft.public.access.adp.sqlserver)