ACCESS FEED: Re: [MS_AccessPros] Re: Link ms access frontend to tables in SQL Server.

Selasa, 03 November 2015

Re: [MS_AccessPros] Re: Link ms access frontend to tables in SQL Server.

Kevin-

Why do you want to provide internet access to your database? Perhaps you need a subscription to Microsoft Azure and / or Office 365 Pro (including Access).

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Nov 3, 2015, at 3:31 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John-

Is there any online tutorials to learn this technic? Thanks.

Best Regards,

Kevin

在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年11月3日下午8:12写道：

Kevin-

You would need a real web server for that and your own IP address.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Nov 3, 2015, at 12:53 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Bill-

I have found the DSN file, and I connected the front-end to tables in SQLServer. My next question is how to connect SQLServer via internet, other than local area network? Thanks in advance,

Best Regards,

Kevin

在 "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年11月3日上午5:45写道：

Good luck using a PC as a server. Performance will be terrible. But to link to the tables all you have to do is create a File DSN through your Control Panel>Administrative Tools>ODBC Admin. Follow the steps to conenct to your SQL server instance and make sure you set the default database to the one that has your tables.

Save the DSN file to a shared folder and lilnk the tables using that DSN.

As you get more advanced skills under your belt, you can write code to link without a DSN file.