>I have create a small class that exports a dbf directly into an MS-Access database that I create with an instance of Access within VFP.
>This all worked like a charm within my test enviroments.
>
>On a users machine, however, I have come accross the fact that he is using a system.mdw file. When creating the instance of Access the user is confronted with a user-dialog so he can enter his userid and password. If he fails to enter the correct one the system terminates.
>This is of course a very nice feature in Access. In my export, however, I do not want to be bothered with this.
>
>I have created a new security.mdw with nothing in. My question now is: how can a create an instance of Access in VFP while using this security.mdw?
>I'm using the createobject('access.application') to start the instance of Access.
>
>Regards,
>
>Ron Brahma
Hi Ranjan,
You can export VFP into an Access database using ADO and Jet OLEDB provider. You can also prompt a user to enter Login name and password. It may be a better way than manipulating with an instance of Access.
HTH, Igor
Igor Gelin
Database Developer