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
(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.
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar