Database Question

M

Muriukis

I have a database which had tables with data but I deleted the data but the
database keeps growing and yet there is no data. Am developing it adding
forms and queries
without data. I have tried compacting but the size is the same.

Question2
I have a table with users and a login form but I have set the password in
code but I would like to change that and lookup the password according to the
username.But still I want the user to type the password but the system should
verify that its the correct password stored in the table.How can I achieve
this .Help appreciated
 
A

Albert D. Kallal

Muriukis said:
I have a database which had tables with data but I deleted the data but
the
database keeps growing and yet there is no data. Am developing it adding
forms and queries
without data. I have tried compacting but the size is the same.
Click to expand...

If the taables are small, and only a few 100, or few 1000 records, then they
likey take up such little room, that compacing the database likey is not
much noticlaple.

Where as during the day during delvpeument, I likey compacpt a fews times
durhing each hour of work. So, when devepiong new forms etc, your compact
alot during the day.....

You might want to consider breaking out the applcation part from the data
part. That way, any devlepuemnt and compacting of the code and forms will
NOT eff3ect he data file. Just like word, or excell "opens" a data part, you
can adoopt the same approach for your appcation, and seperate out the code
from the data. Not only does this protect the data better, but also means
you can update peopoles software without haveing to touch their data. Try
splling your database, and you get an idea as to how small (or large) the
data part is compared to the applicaton part. I expain the splitting concpet
here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
Question2
I have a table with users and a login form but I have set the password in
code but I would like to change that and lookup the password according to
the
username.But still I want the user to type the password but the system
should
verify that its the correct password stored in the table.How can I achieve
this .Help appreciated
Click to expand...

In any given appcation, you likely wind up with LOTS of code that reads data
from tables. This is par for the course.

The simply way to grab data from a table is to use dlookup()

eg:

strPassWord = dllookup("PassField","tblTablePassrds","user = '" & strUser &
"')

You can also write code to create a recordset, but I don't see the need in
this case. Using recordsets is how you read and manipulate tables in
code....
 
Top