Re: Access front end for sql server

Thanks. ODBC works fine for me. At least, it works fine if I can
make the connection.

I have tried a few different tricks to create a connection, but the
connection fails. Could this be because I am working with Access 2003
and my sql server is SQL Server Express 2005?

(My client has a full SQL Server copy at his location, but here at my
office on my PC I am dealing with SQL Express 2005.)

Gwindor



On Sat, 28 Jun 2008 08:22:35 -0700, Tom van Stiphout
<no.spam.tom7744@xxxxxxx> wrote:

On Sat, 28 Jun 2008 10:52:40 -0400, Gwindor <gwindor@xxxxxxxxxxx>
wrote:

No, you can also create an ODBC connection to the SQL Server and stay
within the familiar MDB environment.
It appears MSFT is phasing out support for ADP.

-Tom.


I have been doing programming in Access for about 10 years. I am now
being asked to make an Access front end for data that is stored in SQL
Server.

My impression is that the only way to do this is to use a .adp
application, rather than an .mdb file. Is that correct?

Is it possible to use DAO or ADO with .adp objects?

Also, is there a good manual on making access front ends for SQL
server data?

Gwindor
.

Relevant Pages

  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: Access and processor usage
    ... and you are using an ODBC connection, that would be your bottle neck. ... bottleneck - need to step up to Sql Server. ...
    (comp.databases.ms-access)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()) er
    ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ... SQL Server instance and see if there is a connection reset when this issue ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... remote connection. ... should I just check named pipes only or both TCP/IP and ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ...
    (microsoft.public.sqlserver.connect)
  • Re: Performance of ODBC
    ... ODBC / MDB is a waste of time. ... Usiing Access front-end to connection a back end through ... the database via ODBC with the Jet database engine. ... that Access is the front end, and the SQL server is the back end. ...
    (microsoft.public.access.adp.sqlserver)