mdb to adp conversion

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Is there a wizard that can convert a mde to adp? Third party tool?
I found a lot of documentations on converting older mdb to newer ones, and
upsizing to sql server. But since adp is a relatively new file type, other
than building it from scratch, there ought to be some ways to bring the
existing MDBs to this new form.
Thanks!
.



Relevant Pages

  • 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)
  • Re: A2007 ADPs
    ... to an ADP from an MDB when A2000 ... Frankly whilst I know some Access developers don't like ADP's, ... complexity of the few reports. ... Please convince me that Linked Tables work as well as an ADP. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: A2007 ADPs
    ... queries with an MDB and these are ideal for complex queries and reports ... I admit I had forgotten about this feature, not having done much MDB work ... On many occasions, it's with reports ... Please convince me that Linked Tables work as well as an ADP. ...
    (microsoft.public.access.adp.sqlserver)