开发者

Linking SQL 2005 tables in Access (Client file) and distributing to users

I've used the Access 2007 upsizing wizard to move my files to a SQL server. A problem I'm experiencing now is that when I try to link the tables in either Excel or Access, it requires me to create a DSN or a machine data source connection. In either case, when I do this, it makes the connection only useful on the current PC.

What I'm trying to do is create an access file and an excel file, both of which link to the newly upsized tables on the sql server, which I can distribute to users across the netw开发者_Go百科ork (let's assume they all have sufficient user rights on the SQL server to read data).

Any suggestions?

Chuck


Use Doug Steele's code to convert your DSN's to DSN-less connect strings:

http://www.accessmvp.com/DJSteele/DSNLessLinks.html

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜