I am developing a VB6 program using the Microsoft ADO Control with a
bound grid (True Grid Pro 7). The table I am accessing is in a
Pervasive 2000i database. I am accessing it thru ODBC.

The table has an OWNER on it. When I try to update the table using
the grid, I am getting a status code 46: Access to the requested file
is denied.

Does anyone know how to set the OWNER when using a grid bound to an
ADO control?

--
Posted via http://dbforums.com

Newer versions of PSQL2000 allow you to access owner-based files from
ODBC (which is essentially what ADO is doing for you), but they require
database security to be enabled. (Without security, of course, there is
no sense to having an owner name.)

Look in the manuals regarding the GRANT command for full details, but the
command is essentially:
GRANT ALL ON TABLE table-name owner-name TO user-or-group-name

Then, anyone logging in with proper SQL access rights can access that
file. (The SQL security info will likely be coded into the DSN, or into
the app itself, so there should be no user interface issue with this.)

Of course, you can also simply remove the owner name. If an app exists
that expects the owner name to be there and it is not there, it will
still work as if nothing is wrong. (They are not very secure, anyway.)
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: September 16-18: See our web site for details!

Michael Baugh wrote: