Re: From .mdb to .adp database

Hi Norman,

Thank you very much for your response.
I understand how things work better now.
Because i'm used to work with mdb files, it was difficult for me to
understand that ADP files are just an interface that is not directly
connected with databases, like it is in mdb (for example, the queries).
The reason why i got interested into ADP files is that i'm trying to find
the best way (with less changes to do ans without great changes in
interfaces) to convert my mdb into SQL.
But, as you say ADP is dying, maybe this way is wrong.
I know i can convert my tables and stuff into SQL and still use mdb
interface (by changing the link of the bases), but if i want to
redistribuate my application, i will have to create the dbo connection on
every computers, isn't it ?
Do you have a better solution ?

Thanks by advance.

Nesta


"Norman Yuan" <NoAddress@xxxxxxxxxxxx> a écrit dans le message de news:
%23Xr2UEcEIHA.3332@xxxxxxxxxxxxxxxxxxxxxxx
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: Upsizing design considerations
    ... reports, with a ADP, or mdb (actually, it should be mde, or a ADE when you ... you would LINK the tables to sql server, and NOT USE a adp (the reasons is ... the first two remote users ...
    (microsoft.public.access.gettingstarted)
  • Re: Official Status of SQLServer 2005 ADP
    ... solution might be to use ADP. ... With MDB and Linked tables, the only ways of accelerating things are the use ... of Views and the cumbersome use of SQL passthrough queries. ... > SQL Server, and carry on using Access like I aways had. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Official Status of SQLServer 2005 ADP
    ... My motivation for using ADP files is more for the end-user performance, ... "Linked Server" functions on the SQL server, this way you only have ONE ... with other data sources, such as data from your line of business app, which ...
    (microsoft.public.access.adp.sqlserver)
  • 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)
Loading