Re: [MS_AccessPros] SQL SERVER EXPRESS

 

hi Kevin,

when you use a DSN file to link, it is just like you filled out the
information in the dialog boxes yourself. The DSN file is not stored in
the connection string. Advantage of having it on the network is that you
don't have to take it with you.

Other computers may need to be initially set up manually so they have
the driver. Also each user needs credentials, depending on how users are
set up for the back end.

~crystal

On 27/04/2019 04:24, Qingqing qingqinga@yahoo.com
[MS_Access_Professionals] wrote:
> Dear All,
> I have created a file DSN, and put it in a shared folder. After linking MS Access application with SQL Server via this DSN, everything was fine. Then I disposed the front end to other computers within the same network. Then the front end won't connect to SQL Server. By the way, there's no sql server installed in the front end computers. Anything wrong with my approach? Thanks in advance.
> Best Regards,
> Kevin
>
>
>
>
> ------------------------------------
> Posted by: Qingqing <qingqinga@yahoo.com>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>

__._,_.___

---

Posted by: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___