How to set a password for database and tables?

I have a table:
Table name : Student.dbf
Field : StudCode
Values for StudCode:

Is there a timestamp at VFP database?

What is the advatages for setting relationship between tables at database
designer?
Is it to make the Select Sql statement much more faster?

I need some help on a query I'm trying to run.  I am working with an
employee table.  When a change is made to an employee, for example a pay
rate change, the software adds a new record in the table instead of changing
the existing record. ???.  So here's my query question.

I have following tables with the structures and sample data
1.    Accounts.dbf
=============
AcctId,        AcctName,        CntBalance  AcctType

Hello everybody. I have and app (VC++ 6.00) and it uses FoxPro tables with
ADO, I'm triying to modify date-time fields but ADO gives me the error: "Data
type mismatch"
My SQL statement is:

I need some clarification with VFP.
I run the following query:
    SELECT     jobcode,deptid,jobname,clinical
    FROM     jobimport

I'm accessing a foxpro table in ASP via ADO unfortunatly i'm having a
bit of an issue. I have a very simple SQL statment thats returning only
one column, strange becouse i'm selecting three. The problem is in how
i'm using the subselect, but it runs quite well in foxpro6 IDE (latest

I have a .bat file to copy files from my local hard drive over to our
server. Is there a way to tell foxpro to run this batch file for me?
I've tried running the ms-dos commands form within foxpro but the copy
is extremely slow for these large files. It takes about 10 minutes to

I have to do more than 10 joins in a query but the Windows ODBC driver
returns an error.
So I tried to use a subselect like:
SELECT field1 FROM (SELECT field as field1 FROM table)

I've got two tables, named Order and Customer. I want a query that let
me see during a period per month wich customer bought something for the
first time.
Table Order contain a field Customer_ID and OrderDate

Does anyone have an easy way to give experienced users a “MODI QUERY” type
capability inside of an executable without programmatically building it from
scratch?  We have a client that is experienced in FoxPro and knows how to
create queries using MODI QUERY from the command box.  ...

Here is a sample of data from the purchases table of my database:
purchaseid , customerid , trackid , date , available , invoice
32   7   CGA001M   8/23/2006   0   41
33   6   CGA001M   8/25/2006   0   42