Sabtu, 27 April 2019

Re: [MS_AccessPros] SQL SERVER EXPRESS

 

Dear Crystal,
I am using SQL Server 2017 Express.
Best Regards,
Kevin

On Sunday, April 28, 2019, 10:01:42 AM GMT+8, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

hi Kevin,

you're welcome. Go to (or connect to) the other computers and do the steps on those machines. There must be a driver installed. Perhaps this one?

https://www.microsoft.com/en-us/download/details.aspx?id=36434

What version of SQL Server are you running? 

have an awesome day,
crystal

On 27/04/2019 19:34, Qingqing qingqinga@yahoo.com [MS_Access_Professionals] wrote:
Dear Crystal,
Thanks for sending the youtube video. I have already correctly linked to the sql server on the server computer, and it runs smoothly as well. My problem is when lunching the front end in other computers, it won't work. Any solution for this? Thanks.
Bet Regards,
Kevin




On Sunday, April 28, 2019, 1:22:50 AM GMT+8, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

hi Kevin,

You're welcome. Each computer needs to be set up to connect to SQL Server. Here is a video tutorial that may be helpful:

How to Configure ODBC to Access a Microsoft SQL Server
https://www.youtube.com/watch?v=tUiaK5fRH7k

~crystal

On 27/04/2019 10:55, qingqinga [MS_Access_Professionals] wrote:
Dear Crystal,
Thanks a lot for your reply. Would you please explain a little bit on how other computers are initially set up manually?
Best Regards,
Kevin

?????? WPS???????????????
??? "crystal [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>???2019???4???27??? 21:41?????????

??

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??
[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: zhao.liqing@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

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.


SPONSORED LINKS
.

__,_._,___

Tidak ada komentar:

Posting Komentar