Hi,
Please post this question in the microsoft.public.access.externaldata
newsgroup. Access newsgroup is primarily for issues involving Access. We
recommend posting appropriately so you will get the most qualified pool of
respondents, and so other partners who regularly read the newsgroups can
either share their knowledge or learn from your interaction with us.
Jacky Gu
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/common/international.aspx
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Thread-Topic: Access with Linked Tables Authentication
| thread-index: AcVGsFZJmRCCWXcGQqqnW7BuHDCRAw==
| X-WBNR-Posting-Host: 209.191.136.4
| From: "=?Utf-8?B?U3RlcGhhbiBGaXg=?=" <sfix@cybershift_nospam.com>
| Subject: Access with Linked Tables Authentication
| Date: Thu, 21 Apr 2005 13:26:02 -0700
| Lines: 12
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.office.misc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.office.misc:32734
| X-Tomcat-NG: microsoft.public.office.misc
|
| I have a bit of a brain teaser. I have a user that created an Access doc
| that links to tables in a SQL database. Some users can use the doc and
| others fail with an authentication issue. For example, one user that is
able
| to open the doc and run queries has only read permissions to the file and
no
| access to the SQL database, but is given the option to put in a different
| user to get into SQL when she runs a query. I can't run the doc, yet I
have
| read/write access to the doc and an account on the SQL server. There is
no
| ODBC connection set. When I log into my machine as the "other" user I am
| able to run the queries. The permissions in Access are the defaults.
Any
| ideas?
| --
| -Steve
|
