Showing posts with label advise. Show all posts
Showing posts with label advise. Show all posts

Sunday, February 19, 2012

connection an access db to sql express backend

can someone advise me as to what i have to do to connect an access frontend to an sql server express backend db on another server.

can i somehow link the tables so a user can enter in data in the access db they are familiar with but it will actually go into sql server.

please help

Hi,

you can either click right in the tables area and add a linked table using an ODBC connection or use a ADP project which can directly access the objects of a SQL Server database. But it is important that you enable remote connections on the SQL Server side using the Surface configuration. See the screencast on my side for more information.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Friday, February 17, 2012

Connecting web pages to SQL Server

Can anyone advise me how connect web pages hosted by our ISP to an SQL
Server that is hidden behind our Company Firewall.
We are able to connect to the SQL Server using a VPN, but we are unable
to connect or using web pages that are hosted by our ISP.
Thanks
LC
Hi
Check out
http://support.microsoft.com/default...b;en-us;287932
John
"Lyndon Cushing" wrote:

> Can anyone advise me how connect web pages hosted by our ISP to an SQL
> Server that is hidden behind our Company Firewall.
> We are able to connect to the SQL Server using a VPN, but we are unable
> to connect or using web pages that are hosted by our ISP.
> Thanks
> LC
>

Connecting web pages to SQL Server

Can anyone advise me how connect web pages hosted by our ISP to an SQL
Server that is hidden behind our Company Firewall.
We are able to connect to the SQL Server using a VPN, but we are unable
to connect or using web pages that are hosted by our ISP.
Thanks
LCHi
Check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;287932
John
"Lyndon Cushing" wrote:
> Can anyone advise me how connect web pages hosted by our ISP to an SQL
> Server that is hidden behind our Company Firewall.
> We are able to connect to the SQL Server using a VPN, but we are unable
> to connect or using web pages that are hosted by our ISP.
> Thanks
> LC
>

Connecting web pages to SQL Server

Can anyone advise me how connect web pages hosted by our ISP to an SQL
Server that is hidden behind our Company Firewall.
We are able to connect to the SQL Server using a VPN, but we are unable
to connect or using web pages that are hosted by our ISP.
Thanks
LCHi
Check out
http://support.microsoft.com/defaul...kb;en-us;287932
John
"Lyndon Cushing" wrote:

> Can anyone advise me how connect web pages hosted by our ISP to an SQL
> Server that is hidden behind our Company Firewall.
> We are able to connect to the SQL Server using a VPN, but we are unable
> to connect or using web pages that are hosted by our ISP.
> Thanks
> LC
>