Dear Ashish,

The first thing you should do.... you must have now the database created from MSACCESS then go to VFP and follow the steps

from the command window

assuming that we are using FOLDER C:\BPSAP

type the following

set defa to d:\bpsap
creat data accessdata
modi data accessdata

---- Database Container will appear (ACCESSDATA) (do not close this one)

from the menu go to DATABASE =>CONNECTIONS

Click NEW button from the CONNECTION SCREEN
after clicking a new screen will appear (connection designer- Connect1)
FROM the connection designer- Connect1

Specify DATA SOURCE choose
* Connection String

CLICK NEW DATA SOURCE button and new screen will appear

(ODBC Data Source Administrator)

Select MS ACCESS DATABASE (Microsoft Driver (*.mdb)) then click CONFIGURE button

Specify now the ff:

DATA SOURCE NAME : < can be anything> e.g. SAMPLEACCESS
DESCRIPTION .

Then Click SELECT button and specify now the MSACCESS table

EG.
sample1.mdb (SELECT the item and click ok)

Click ok button from (ODBC Microsoft Access Setup)

click all OK button for the rest of the screen

Then connection will prompt to specify your connection name

GIVE ANYTHING like SAMPLEACCESS

after specifying the connection name CLICK close and

from the menu again go to DATABASE =>NEW REMOTE VIEW

click VIEW WIZARD button
CHOOSE
* CONNECTION (select SAMPLEACCESS)
and check the check box (include SYSTEM TABLES)
then follow the steps now...


be sure that from the connection string
some value must be there eg.

DBQ=D:\BPSAP\MSO\sample1.mdb;DefaultDir=D:\BPSAP\MSO;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=D:\BPSAP\MSO\sample1.mdb.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitS



Regards
Reymund