Re: Do I need to use a Web Service to hook up An Access Front End to SQL Server?

"R Tanner" <tanner.robin@xxxxxxxxx> wrote in message
news:a7a82b2b-f475-4d0c-a1da-ce969cd5cee4@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

Do I need to use WCF to hook up an access front end to a sql server
database? My IT department doesn't allow direct connections to my
machine...

No you don't need a web server, nor do you need to use web services to have
ms-access use the data from sql server. You do need permissions, and of
course a network connection to where the sql server is located (and, that
connection can be an IP address).

So, in place of linking your tables to a back end "mdb" (assuming your
application was split), you now simply link those tables in your front end
to sql server....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx


.

Relevant Pages

  • 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)
  • ASP.NET 2.0/SQL Server 2000 Connection Problem.
    ... Now, When I open the web page on the Web Server itself, I am able to successfully connect to the Database which confirms that the connection string is correct. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ... (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ...
    (microsoft.public.dotnet.framework.aspnet)