This topic is locked

what am i doing wrong?

2/27/2004 8:14:18 AM
ASPRunnerPro General questions
author

OK so what am i doing wrong?
Every time i edit or delete a record it updates ALL records!!!

501022 2/27/2004

OK think i know what the problem is but dont know how to fix it...
I want users only be able to view/edit their own records.
In the advanced security section i set it so that this is possible but this is where i think i'm going wrong and dont know what to do.
What do i enter in the
Users Table OwnerId field

and the

Main Table OwnerId field
I want user to be able to login via a username field (not the id auto added by access) and a password field in the database.
Anyone out there how can help?

D
DNS Hosting 2/27/2004

think you set them both as the id you want to recognise the user by..
i.e username

Sergey Kornilov admin 2/28/2004

Hi,
make sure you selected correct field as a key field. Key field value should be unique for each record and cannot be NULL or empty.