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

 

Kevin

PC's are not meant to handle loads from multiple users. I've seen small businesses do this with what used to be called peer-to-peer networks, but everything slows down and makes the users very unhappy, not to mention production suffering. 

I realize servers are very expensive but there is a reason for that. Their processors are much more powerful and the hard drives are usually RAIDs (arrays of disks) that are much more reliable than single disks.

-Bill

---In MS_Access_Professionals@yahoogroups.com, <zhaoliqingoffice@163.com> wrote :

Bill-

You mean I should use a real server instead of PC, right? Why is it terrible to use PC as a server? Thank.

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: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (9)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___