Re: DSN less link to SQL

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 03/16/04 

Date: Mon, 15 Mar 2004 21:35:03 -0500

It sounds like a permissions issue, as opposed to any driver being missing
from the user's machine.

Unfortunately, I don't have SQL Server available to me at the moment, so I
can't suggest what you need to check. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
"Ngan Bui" <anonymous@discussions.microsoft.com> wrote in message
news:d87001c40ae2$b396d5f0$a301280a@phx.gbl...
> Ok, I have a test user part of the ADF group and I added
> the ADF group to the SQL login with Public checked.
>
> When I open the mdb file with the SQL linked tables (I ran
> your code with no errors) and try to open one of the
> tables, I get the following error:
>
> ODBC - call failed
> [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT
> permission denied on object 'tblComplaintType',
> database 'ComplaintsdataSQL', owner 'dbo'. (#229).
>
> Did I miss a permission?  Do I have to check to see if the
> user's computer have a certain driver?
>
> Ngan
> >-----Original Message-----
> >Are you getting any error messages when you use my code?
> >
> >Lots of people have used it, so I doubt that the code is
> the culprit.
> >
> >-- 
> >Doug Steele, Microsoft Access MVP
> >http://I.Am/DougSteele
> >(No private e-mails, please)
> >
> >
> >
> >"Ngan Bui" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:aaee01c40acc$cc771960$a601280a@phx.gbl...
> >> Ok,
> >>
> >> I've done this before, but unfortunately, I can't find
> the
> >> code to do it.  Can someone help me?
> >>
> >> I have Office XP and SQL 2000.  I've upsized the Access
> >> tables to SQL.  In a new front end .mdb file, I used the
> >> file/system DSN to link the SQL tables.  However, it
> would
> >> only work on my machine since I have the DSN file.
> >>
> >> And I don't want to put the DSN file on every machine
> that
> >> uses this front end.
> >>
> >> How can I turn the link into something that every
> machine
> >> can use, without having a DSN file?  I've seen alot of
> >> codes for dsn-less connection, but I can't seem to get
> it
> >> to work. I've tried using the code (page 189) listed in
> >> the MS Access Developer's Guide To SQL server.  I've
> tried
> >> using the code at:
> >>
> http://members.rogers.com/douglas.j.steele/DSNLessLinks.htm
> >> l
> >>
> >> However, nothing changes/works.
> >>
> >> Anyone can help me?
> >>
> >> Ngan
> >
> >
> >.
> >

Relevant Pages

  • Re: Complete Neophyte Question(s)
    ... You should not have to go Google to find out what WITH GRANT means. ... Server comes with online documentation on you hard disk. ... WITH GRANT is one of the more esotheric features in SQL Server in my ... Or does that depend on the permission? ...
    (microsoft.public.sqlserver.security)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.sqlserver.msde)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Object permissions
    ... only the owner can set the RWOP property on a query. ... Once I removed that line from the sql, ... you grant modify permission on the qryAttendanceActual query. ...
    (microsoft.public.access.security)