ACCESS FEED: April 2019

Selasa, 30 April 2019

[AccessDevelopers] File - Monthly_Notices.txt

Monthly notices:

Hi Kids!:

Don't forget to check out our "Links" section at the website for helpful sites. Also take a peek at books that others have found worthwhile in our books database under the 'Database' link of the main AccessDevelopers page. Feel free to add any books or links that you have found useful.

__._,_.___

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (178)

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.

Please zip all files prior to uploading to Files section.

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Minggu, 28 April 2019

Re: [MS_AccessPros] SQL SERVER EXPRESS

you're welcome, Kevin ~ happy to help

have an awesome day,
crystal

On 28/04/2019 18:46, qingqinga qingqinga@yahoo.com [MS_Access_Professionals] wrote:

Dear Crystal,

Thank you a lot.

Best Regards,

Kevin

?????? WPS???????????????

??? "crystal?? strive4peace [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>???2019???4???28??? 10:33?????????

__._,_.___

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 (11)

Have you tried the highest rated email app?

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: [MS_AccessPros] SQL SERVER EXPRESS

Dear Crystal,

Thank you a lot.

Best Regards,

Kevin

发自 WPS邮箱客戶端

在 "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2019年4月28日 10:33写道：

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

On 27/04/2019 21:04, qingqinga@yahoo.com [MS_Access_Professionals] wrote:

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: qingqinga <qingqinga@yahoo.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (10)

Have you tried the highest rated email app?

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Sabtu, 27 April 2019

Re: [MS_AccessPros] SQL SERVER EXPRESS

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

On 27/04/2019 21:04, qingqinga@yahoo.com [MS_Access_Professionals] wrote:

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: crystal 8 <strive4peace2008@yahoo.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (9)

Have you tried the highest rated email app?

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

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?

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___