Jill,
Then use a connectionstring like:
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;UID=admin;Pwd=whatever
Cetin
>Hi,
>
>I have an Access database, w/a "SECURED.MDW" and i think it is keeping me from getting in to the data, using your FAQ code.
>
>Running interactively, i can use the name and pasword i have.
>
>Running w/the code in the FAQ, I get the error:
>
>"You do not have the necessary permissions to use the ______.mdb object. Have your system administrator or the person who created this object establish the appropriate permissions for you."
>
>Is there anything i can do from my end, or do i have to ask my prospective client to modify something?
>
>Thanks for any input.
>
>J
>
>>>I have an MDB file but don't know what tables it has. What is the most effective way to convert the entire Access database to VFP?
>>>
>>>(I don't have Access so I can't even open the MDB file).
>>>
>>>Thank you.
>>
>>Dmitry,
>>FAQ #8039
>>Cetin