ADO/ULS problem

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?

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/ex...ributors2.html for contact
info.


"salmonella" wrote in message
...

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

worked fine- thanks!






"'69 Camaro" wrote:

Hi.

is there a way to use a RWOP query to generate the record
set?

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/ex...ributors2.html for contact
info.


"salmonella" wrote in message
...

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

You're welcome. Glad it helped!

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/ex...ributors2.html for contact
info.


"salmonella" wrote in message
...
worked fine- thanks!






"'69 Camaro" wrote:

Hi.

is there a way to use a RWOP query to generate the record
set?

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/ex...ributors2.html for contact
info.


"salmonella" wrote in message
...

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