cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
371
Views
0
Helpful
1
Replies

ACS4.0 authenticating against MS Access DB

with_joerg
Level 1
Level 1

Hello,

Via ODBC I would like to have ACS 4.0 authenticating against a simple Microsoft Access Database which contains Usernames and Passwords in the table "users".

I cannot get it to work. It seems to me as if the AccessDB requires a special structure / layout or so.

Has anyone got a small (might be empty) sample DB for me which works? Or can anyone point me the way to better dosumentation?

Thanks,

--JF

1 Reply 1

darpotter
Level 5
Level 5

ODBC authentication was one my bits... and for testing I remember using Access so it can be done.

You should be able to build a query with input parameters matching those supplied by ACS (see the docs).

I have to admin my query just did returned pass or fail using a "select into" and nothing more complex than that.

I had a look but cant find the old db...

Darran