ADO/ULS problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created an ADO recordset from a table called Students, however the code
will not work for people without permission to read the table. How do I
create a RS from a Table when the USER does not have read permissions to the
table? For example, is there a way to use a RWOP query to generate the record
set?

Once I have the RS, for each record in the set, I am taking the value from
a particular field, creating a record in another table and adding the data
from the RS field to the new record.

Thanks
 
Hi.
is there a way to use a RWOP query to generate the record
set?
Click to expand...

Yes. Have the database owner create the RWOP query and give read permission
on this query to the group the users are a member of, then generate the
recordset using this query as the source, not the table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
worked fine- thanks!






'69 Camaro said:
Hi.


Yes. Have the database owner create the RWOP query and give read permission
on this query to the group the users are a member of, then generate the
recordset using this query as the source, not the table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import File Information 0
dim db as Database 5
Access 2003 to Outlook Task 2
Very basic ADO VB code on a Form 2
Getting the autonumber value after adding new record when dao points to SQL rather than JET 3
Find record using recordsets 1
Recordset merge 1
Problem with Items Selected from List Box 2

Back
Top