Check user credentials
in [Programming]
|
From: IgorM on 7 Apr 2010 14:39 Hi I have a database in access mdb file. In Excel I created a userform where user inputs a username and password. What's the best way to check if the given credentials are correct - in VBA of course? Kind regards IgorM
From: Bob Phillips on 7 Apr 2010 17:24 Igor, Surely, you would just have a user table with passwords on the database, and check against that? -- HTH Bob "IgorM" <igorm(a)live.com> wrote in message news:F867CAE5-F78D-4ED4-972A-EE85A4D2BDC4(a)microsoft.com... > Hi > > I have a database in access mdb file. In Excel I created a userform where > user inputs a username and password. What's the best way to check if the > given credentials are correct - in VBA of course? > > Kind regards > IgorM
From: IgorM on 7 Apr 2010 18:15 "Bob Phillips" <bob.phillips(a)somewhere.com> wrote: > Igor, > > Surely, you would just have a user table with passwords on the > database, and > check against that? > I have creared users in the database. So i don't really want to query any tables but I want to check if a ceartain user with a provided password exists, ie is created in the mdb file. -- IgorM
From: Tim Williams on 7 Apr 2010 18:46 Just try to run a simple select on the database using the credentials supplied, and check any errors (if generated). Tim On Apr 7, 11:39 am, "IgorM" <ig...(a)live.com> wrote: > Hi > > I have a database in access mdb file. In Excel I created a userform where > user inputs a username and password. What's the best way to check if the > given credentials are correct - in VBA of course? > > Kind regards > IgorM
From: IgorM on 8 Apr 2010 01:44
I know that this is one of the possibilities. But I was thinking about something more advanced.So I just want to know is such and such user has access to database, but I don't want to query any tables in the database to do this. Uzytkownik "Tim Williams" <timjwilliams(a)gmail.com> napisal w wiadomosci grup dyskusyjnych:d69fd656-9a4c-41c7-9669-d637e13a0de1(a)k33g2000yqc.googlegroups.com... > Just try to run a simple select on the database using the credentials > supplied, and check any errors (if generated). > > Tim > > On Apr 7, 11:39 am, "IgorM" <ig...(a)live.com> wrote: >> Hi >> >> I have a database in access mdb file. In Excel I created a userform where >> user inputs a username and password. What's the best way to check if the >> given credentials are correct - in VBA of course? >> >> Kind regards >> IgorM > |