MS Access QUERY which retrieves records for an authenticated user???

  • Thread starter Thread starter SimpleTechie
  • Start date Start date
S

SimpleTechie

Hi all,
I have a MS Access QUERY which retrieves records based on
3 parameters and outputs it to a data access page. Now, I
want users to be able to delete an erroneous record. How
can I make this secure?

Can I make the query look up an employeename-password pair
stored in a table and then display the records only if
valid. And then if they even delete it, I can be assured
that it is an authenticeted user.

Please do reply.
Thank you.
SimpleTechie.
 
If you have your users signing on to the database (secured with user-level
security) then you can simply include a criteria in your query to only pull
up records that they entered. You would need to store the userid in the
record and then in your query only pull their records....


= CurrentUser


Rick B

Hi all,
I have a MS Access QUERY which retrieves records based on
3 parameters and outputs it to a data access page. Now, I
want users to be able to delete an erroneous record. How
can I make this secure?

Can I make the query look up an employeename-password pair
stored in a table and then display the records only if
valid. And then if they even delete it, I can be assured
that it is an authenticeted user.

Please do reply.
Thank you.
SimpleTechie.
 
No, the users submit data through data access pages and
nobody has direct access to MS Access database.
So, how?
 
Back
Top