Ok. But what if I want to check the group which the user belongs to?


Uzytkownik "John W. Vinson" napisal w
wiadomosci grup dyskusyjnych6tqr5hbqd5l8hheb4hq1tntlr7dohp2gl@4a x.com...
On Thu, 8 Apr 2010 07:52:54 +0200, "IgorM" wrote:

Hi

I build an app in Excel where user is obligated to enter a user name and
password. If the given user name with password exists in an Access
database
the application will start.
But how to check if the given user (with such password) exists in the mdb
file? I wouldn't like to try to run a random query to see if it returns
results. I was rather thinking about something more advanced - a solution
that checks only the user name and password. In VBA of course.


Kind regards
IgorM

So use a query with the desired username and password as parameters.
That's
hardly a "random query". You may also be able to use the DLookUp function.

--

John W. Vinson [MVP]