access and Sql

I changed the archive of a program in VB6 that used
Access 97 Database via DAO USING JET 3.5 passing it to SQL
server (sqloledb1 driver) and using ado 2.7 and with
surprise (The file structure and data is not grown) I find
now the program slower than before using access file' It
is possible? Sql server is slower to access the file than
access' or i make something wrong"davidex" <anonymous@.discussions.microsoft.com> wrote in message
news:318901c3b033$a560efc0$a601280a@.phx.gbl...
> I changed the archive of a program in VB6 that used
> Access 97 Database via DAO USING JET 3.5 passing it to SQL
> server (sqloledb1 driver) and using ado 2.7 and with
> surprise (The file structure and data is not grown) I find
> now the program slower than before using access file' It
> is possible? Sql server is slower to access the file than
> access' or i make something wrong
Don't multi-post. See thread in .programming.
David

Access / SQL Server currency datatypes

When linking a SQL server 2000 table to Access 2003 using the standard MS
ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney
are blank in Access.
If I use a DataDirect ODBC driver the money fields are displayed correctly.
Any Idea if there is a MS ODBC driver that displays money correctly?
You might want to ask this question in one of the Access newsgroups
since it isn't an ODBC or a SQL Server issue. Someone there may have
the answer you seek.
--Mary
On Tue, 14 Mar 2006 06:02:26 -0600, "Simon
Lampert"<ureader@.byteaccess.com> wrote:

>When linking a SQL server 2000 table to Access 2003 using the standard MS
>ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney
>are blank in Access.
>If I use a DataDirect ODBC driver the money fields are displayed correctly.
>Any Idea if there is a MS ODBC driver that displays money correctly?

Access / SQL Server currency datatypes

When linking a SQL server 2000 table to Access 2003 using the standard MS
ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney
are blank in Access.
If I use a DataDirect ODBC driver the money fields are displayed correctly.
Any Idea if there is a MS ODBC driver that displays money correctly?You might want to ask this question in one of the Access newsgroups
since it isn't an ODBC or a SQL Server issue. Someone there may have
the answer you seek.
--Mary
On Tue, 14 Mar 2006 06:02:26 -0600, "Simon
Lampert"<ureader@.byteaccess.com> wrote:

>When linking a SQL server 2000 table to Access 2003 using the standard MS
>ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney
>are blank in Access.
>If I use a DataDirect ODBC driver the money fields are displayed correctly.
>Any Idea if there is a MS ODBC driver that displays money correctly?