Re: ODBC Driver error

From: Ivan Debono (ivanmdeb_at_hotmail.com)
Date: 10/30/04 

Date: Sat, 30 Oct 2004 05:25:22 +0200

It's working again :)

"Jeff Dillon" <jeff@removeemergencyreporting.com> schrieb im Newsbeitrag
news:OsklDDevEHA.4076@TK2MSFTNGP14.phx.gbl...
> What database are you using? If file based, set Everyone Full Control on
> the
> directory where it resides, as a test, as well as your TEMP/TMP
> directories
>
> Jeff
> "Ivan Debono" <ivanmdeb@hotmail.com> wrote in message
> news:ugESF3dvEHA.3856@TK2MSFTNGP10.phx.gbl...
>> The SQL statement is correct.
>>
>> When I remark from adOpenKeySet onwards I get an error that I don't have
>> read permissions on the table. Locally I'm using a different MDW than the
>> standard one, but I gave read permissions to the users group on all
> tables.
>>
>> Ivan
>>
>>
>> "Jeff Dillon" <jeff@removeemergencyreporting.com> schrieb im Newsbeitrag
>> news:uQ7IEedvEHA.3916@TK2MSFTNGP10.phx.gbl...
>> > As always. put your SELECT statement into a variable first, then
>> > response.write the variable to veryify syntax
>> >
>> > Or just hardcode a simpler SELECT statment, and verify that it's
> working.
>> >
>> > Jeff
>> > "Ivan Debono" <ivanmdeb@hotmail.com> wrote in message
>> > news:OajcvbdvEHA.1520@TK2MSFTNGP11.phx.gbl...
>> >> Hi everbody,
>> >>
>> >> Getting this strange error all of a sudden.
>> >>
>> >> Microsoft OLE DB Provider for ODBC Drivers. error 80040e21
>> >> ODBC driver doesn't support the requested properties.
>> >>
>> >> and the line is:
>> >>
>> >> tRST.Open "SELECT id FROM " & sTable & " WHERE " & sField & " = '" &
>> > vValue
>> >> & "'", oConn, adOpenKeyset, adLockReadOnly
>> >>
>> >> I'm using vbscript and this was working before I changed some tables
> and
>> >> relationships, which should not affect the above line though.
>> >>
>> >> Any ideas?
>> >>
>> >> Ivan
>> >>
>> >>
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Re: How to go from 2 secure MDBs with 1 workgroup to 2 workgroups
    ... All 3 database files were ... which also resides on the server in the same folder with the back-end ... Blow may have admin permissions in secureapp1.mdb and no permissions ... workgroup file for secureapp1.mdb however, when I do that I loose my ...
    (microsoft.public.access.security)
  • Re: VS 2008 Data Access Issues
    ... The permissions you have to watch are the permissions for the account that ASP.NET runs under. ... The reason for write on the folder is the lock file is created when someone opens the database file, even from a website. ... The datanavigation control shows no records either and when I attempt to add a record it is not saved. ...
    (microsoft.public.dotnet.framework.adonet)
  • =?Utf-8?Q?How_to_go_from_2_secure_MDB=E2=80=99s_wi?= =?Utf-8?Q?th_1_workgroup_to_2_workgroup
    ... All 3 database files were created and secured using the same ... workgroup file which also resides on the server in the same ... permissions in each of the two applications. ...
    (microsoft.public.access.security)
  • Re: Enterprise Manager and Windows Account
    ... giving "db_owner" rights to the new user gives him complete control of ... the database. ... --add permissions to it ... --write restore code in VB program ...
    (microsoft.public.sqlserver.security)
  • Re: Can I Set permissions for a .mdb using Windows login?
    ... Just to clarify. ... While that will limit who can access the database, it won't control what ... are desired in terms of permissions for those who can access the database ...
    (microsoft.public.access.security)