RE: Transmitting/Receiving Data via MS Access/ADO
- From: Mark Han[MSFT] <MarkHanMSFT@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 16 Sep 2008 00:21:00 -0700
Hello David,
Since our intel tool have some issue, all our responses via the tool cannot
be synchronized; Sorry for that(my reply on 12/9 is public on 15/9). However
we are trying to fix the problem.
Back to the issue, if it is convenient to you, would you please work with me
via email.(v-fathan@xxxxxxxxxxxxxxxxxxxx)(remove online)
I look forward to hearing from you. Thanks.
Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
"Mark Han[MSFT]" wrote:
Hello David.
Thank you for contacting Microsoft Online Community Support. It is Mark.
I'm glad to assist you with the issue.
For this case, you indicated that after transmitting the data from access
to SQL Server via ADO, the information can't be read from the SQL Server
database. Is it correct? If I misunderstand anything, please tell me
directly. It will help us to resolve this issue quickly. Once the issue
resolved, I'll appreciate your verification.
Based on you description, the issue seem to be related to a permission
problem. The user who would like to read the data from SQL Server must has
the "db_datareader" role of the database.
To better understand the issue, please help to confirm/collect the following
1) please describe the symptom in detail. For example: when the user tried
to read the data from SQL Server database, what error happened?
2) Please describe the scenario in detail. For example, what
application/tool you use to transmit data between SQL Server and an MS
Access database via ADO? How many server is involved into the issue?
3) Please help to confirm if the data is transmitted successfully?
4) please describe your method to to transmit data between SQL Server and
an MS Access database via ADO in detail. If it is convenient to you, please
provide me some sample script.
Besides, If the edition of your SQL Server is standard/enterprise, it is
suggested to use SSIS packet to transmit data between SQL Server and an MS
Access database.
If you have any questions or concerns, please let me know.
I look forward to your update.
Thanks.
Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
- References:
- Transmitting/Receiving Data via MS Access/ADO
- From: David M.
- Transmitting/Receiving Data via MS Access/ADO
- Prev by Date: RE: Application role
- Next by Date: Re: error code 0x2B33 for SQL server 2000 KB 948110(MS08-040)
- Previous by thread: Transmitting/Receiving Data via MS Access/ADO
- Next by thread: Need to show that guest id is disabled for Audit
- Index(es):
Relevant Pages
|
