suppressing paradox passwords when application loads 1

[mjsof84]

hello again...last question i promise!

i've got several paradox tables, one of which is a table of usernames and passwords. i have my program set up to query the users.db table when it receives input from the login form.

anyway, point being that in the current state the tables are hopelessly insecure, anyone can open them. easy solution to that is to put a password on each table, which i've done. however, when my program runs, it comes up with a password prompt for each table. of course, this is similarly useless, as for all users to know the password for the paradox tables would defeat the point somewhat.

so, essentially, i'm looking for a way to hard code the database passwords into my program and then automatically suppress the paradox password prompts when my application attempts to open the tables.

help much appreciated.

 

[hilfy]

If you're using the BDE, you'll need to connect your tables through a TDatabase connection.

- Set the LoginPrompt property to False.
- In the Params for the TDatabase, include the following:
USERNAME=<your user id>
PASSWORD=<your user password>

These values will be the ones you set up for the tables, NOT the ones from your users.

Connect all of your TTables/TQueries through this TDatabase and it will automatically log in to the tables for you.

-C