Connecting to Access

Hi. I want to connect to an Access database. I have tried doing it, it works, but everytime I start the program, it asks for a login & Password. I can click enter (The database is not secure) but it's annoying. The Best way would be if I COULD put a password, but let my application enter it automatically. Another solution, is to use the users protection scheme. Because I WILL use users in my application, I CAN use the login to the Database as my user's account (It can ever save me some time, and password encoding...) But How do I know, in runtime, in my program, which user is using the database?

I hope I am clear,
Who is Participating?
ellessarConnect With a Mentor Commented:
You can use the GetUserName function to find out what
the name of the current logged on user is, alternatively
you can prompt your user for a password and username
and assume that this will hold true for the entire
session. In your TDatabase component just add the following parameters
  user name = (add user name)
  password = (add password)
then set the loginprompt property to false (to prevent
the database component for prompting for a connection)programatically once the user has logged on. You may
also want to use a generic read only logon and password
to access a users permissions tables prior to actually performing the logon.
ShadowHawk071998Author Commented:
Thanks. But I have to say that I had one trouble: YOu have to write it without spaces :
user name=

or it doesn't work (And it took me the better part of an hour to get it right...)


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.