>>Hello,
>>
>>I have a Fox app that I need to link to an MS Access table for output. I select a driver for MS Access and create a Connection in the VFP database. I then make a Remote View using the connection info, and all works well.
>>
>>The only trouble is, every time I try to verify the connection or use the remote view, it puts up a dialog that asks me (again) where the MS Access database lives. This occurs even though the full path and database name are saved in the Connection.
>>
>>Any ideas?
>
>See if this
Re: SqlStringConnection Thread #
884310 Message #
884312 can help.
Thanks, Naomi. I discovered I had failed to specify a database (MDB) while creating the connection in the Fox DBC. So it was having to ask each time.