Re: Converting from ADP to MDB/ODBC linked tables

It shouldn't be. ODBC linked tables worked fine for years before ADP's and
they still do (and it's a lot less buggy than ADP's). I have used them to
successfully build huge multi-user systems with hundreds of server objects
and hundreds of Access objects. There is always the option of using
passthrough queries for the (quite rare) occasions when you encounter some
limitation of ODBC linked tables; or, you can build a server view and link
to that.

If you abandon this approach without seriously trying it you are really
shooting yourself in the foot: either you battle on with ADP's and just pray
that MS doesn't pull the rug out from under you, or you change to VB.Net or
Delphi and increase your development costs by several multiples at least..

"Reese Watt" <reese@xxxxxxxxxxxxxxxxx> wrote in message
news:efcQZLu0HHA.3848@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the responses.

I don't like what I read about the limits of ODBC queries. I think that
would be a deal-breaker for me as far as converting to and MDB/ODBC
combination.

"Reese Watt" <reese@xxxxxxxxxxxxxxxxx> wrote in message
news:u9gNzAG0HHA.1100@xxxxxxxxxxxxxxxxxxxxxxx
Hello all,

Does anybody have any experience converting an ADP file to an MDB file
using linked SQL tables via ODBC?
(By the way, is linking via ODBC the same as using a pass-through
query?)

For example, assume I took these steps:
1) Create new mdb file
2) Import Form1 into the newly created mdb file from my existing adp
file,
which was bound to View1 (in SQL server)
3) Link to View1 via ODBC
4) Bind the Form1 in the new mdb file to the linked View1

Would my Form1 need to be modified to work under the new structure?
How difficult would it be to modify it?

Thanks,

Reese





.

Relevant Pages

  • Re: Read data from Access MDB file?
    ... was having trying to do this via ODBC. ... My mdb file is on a remote share, and I use an UNC path. ... That means it needs a valid local user account on the remote computer. ...
    (comp.lang.php)
  • Re: ODBC connection to mdb for MacIntosh
    ... As long as the computer has ODBC drivers for an Access database, it does NOT have to have Access installed. ... Office 98 and 2001 it was possible to control several different types of databases directly on a single Mac without having the application on the computer. ... No, you can not put the mdb file on a mac and connect to MS Access via ODBC because MS Access only runs in windows, not on a Mac. ... If you search Google on this topic about 2 years ago there was a complete thread in the Excel for Mac newsgroup about ODBC drivers. ...
    (microsoft.public.mac.otherproducts)
  • Re: DBI and DBD::ODBC and MS Access
    ... <ignoring questions I don't know the answers to> ... http or ftp) and apparently you can access a remote mdb file in this ... The server software doesn't matter for ODBC, ... the Access driver is freely available and distributable. ...
    (comp.lang.perl.modules)
  • Re: Converting from ADP to MDB/ODBC linked tables
    ... I don't like what I read about the limits of ODBC queries. ... Does anybody have any experience converting an ADP file to an MDB file ... Bind the Form1 in the new mdb file to the linked View1 ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Converting from ADP to MDB/ODBC linked tables
    ... abandon Access when it's still perfectly usable. ... I don't like what I read about the limits of ODBC queries. ... Import Form1 into the newly created mdb file from my existing adp ... Bind the Form1 in the new mdb file to the linked View1 ...
    (microsoft.public.access.adp.sqlserver)