I have an existing database imported from MS Access that is functioning with no problem. I want anyone to be able to view, but registered users can modify only their own record. All I was given with this db that was unique was a "member number" that is already assigned so I've used that as "user id" and the last name as a password and converted into .pass with no problem.

The problem is, although I can login using this combination fine, when I click modify I get 'no matching record'. After hours combing this forum and FAQ's etc I'm assuming the problem is in the db_key or auth_user_field area, I just totally can't figure it out.

Can someone point me to anywhere that explains this in detail or offer any advice?

Some good DBMan links are:
JPDeni's DBMan-ual: http://www.jpdeni.com/dbman/
LoisC's Unofficial DBMan FAQ: http://webmagic.hypermart.net/dbman/

In short though, in order to allow members to only modify their own records, you will need a "username" field to store the owner of each record, and set $auth_user_field to that field number.

Good luck!

- Mark


Astro-Boy!!
http://www.zip.com.au/~astroboy/

http://www.jpdeni.com/dbman/

OR the Unofficial DBMAN FAQ linked in the Resources section of this web site.

Regards,

Eliot Lee

Thanks folks. I've spent hours in the links you provided but no luck so far.

If anyone has spare time and wouldn't mind looking here's my default.cfg file.

http://www.raleighmusic.com/temp/default.txt

My ultimate goal is to have:

Admin-view add delete modify
Default-view
registered user-view all - modify own only

Again, this is a exisiting database that I will be updating myself, I just need people to be able to modify their own info once it is there if needed.

The problem may be in the way I setup registration. The member number is the only 100% unique field in the db, so I used that as user id and their last name as password in .pass to login. I can login using any member # and last name that I have with no problem, but when I hit modify and get the search screen, no matter what I enter I get 'no matching record'.

thanks for the replies so far!

You MUST have the following settings in the default.cfg file:



Replace FIELD NUMBER with the NUMBER of the field that is used for the UserID.

Then in your default.pass file, the records SHOULD look like the following:



NOW, if you have the SECURE PASSWORD MOD installed, then the default.pass file should look like the following:



I would HIGHLY recommend using the DBMAN Configurator located at http://www.jpdeni.com/dbman/ that WILL allow you to set-up DBMAN step-by-step!


Regards,

Eliot Lee