AW: [dba-SQLServer] OLEDB

Michael Brösdorf michael.broesdorf at web.de
Mon Apr 19 04:38:51 CDT 2004


A while ago I had to migrate an Access db to SQL-Server. The Frontend is
still Access, with linked ODBC tables. So far it runs pretty good!

We didn't migrate to an ADP since the app contained a lot of reports with a
complex query structure. Using linked tables we didn't have to rewrite the
whole thing, although a lot of recoding had to be done anyway...

Michael

-----Ursprüngliche Nachricht-----
Von: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]Im Auftrag von Martin
Reid
Gesendet: Donnerstag, 8. April 2004 22:32
An: dba-sqlserver at databaseadvisors.com
Betreff: Re: [dba-SQLServer] OLEDB


ADP

But what if it was a straight forward linked table solution??

Just looking for opinion?

MArtin


----- Original Message -----
From: "Mike & Doris Manning" <mikedorism at adelphia.net>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Thursday, April 08, 2004 9:10 PM
Subject: RE: [dba-SQLServer] OLEDB


> Access ADP or VB.Net with SQL Server drivers
>
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com
>
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin
Reid
> Sent: Thursday, April 08, 2004 3:24 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] OLEDB
>
>
> You have moved your databases up to SQL Server. What would you use for the
> front end connection, for example would you change to OLEDB??
>
>
> Martin
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list