hi Kevin,
then use this driver for the other machines:
https://www.microsoft.com/en-us/download/details.aspx?id=53339
You have to set up a data source on each machine that uses the driver.
What Is an ODBC Driver?
https://www.progress.com/faqs/datadirect-odbc-faqs/what-is-an-odbc-driver
What Is ODBC?
https://docs.microsoft.com/en-us/sql/odbc/reference/what-is-odbc
have an awesome day,
crystal
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=36434What 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: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar