>Hello,
>
>Can you tell me if I can put a username and a password on Visual Foxpro database ? (ODBC)
>I want to access my vfp database using SQL (and ASP) and a secure connection with username and password (like with ACCESS database).
>
>Thanks everybody.
VFP currently has no built in security. With version 7 and the added DBC events it will probably be easier to create this.
VFP uses the permissions set at the OS level on its files. If you have NT you can specify file-level permissions for a specific network account.
Note that when using ODBC directly from ASP, the system is going to use the guest user IUSR_MyMachineNameHere account. You will need to grant access to this user.
Another option (there are always other options) is to create an MTS package and add a COM server written in VFP or VB. You can configure MTS to use a specific account when instantiating your COM object and you could set the permissions to only allow that user access.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao