Re: Access front end for sql server

On Sat, 28 Jun 2008 14:22:15 -0400, Gwindor <gwindor@xxxxxxxxxxx>
wrote:

No.
Likely a permissions issue. Are you getting any error messages?
Compare your connectionstring with those posted at
www.connectionstrings.com

-Tom.


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: Access Front End & SQL Server Back End Connection
    ... I believe that if you're using SQL Server, unless you have a need for the ... additional capabilities afforded by use of a .mdb (e.g., ... tabling, heterogenous data source linking, etc.), then stick with an .adp. ... > grips with the options and settle on a good approach to making the connection ...
    (microsoft.public.access.modulesdaovba)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)