Hello Mohammed.....
Here is some code I cut from a program. This block is executed when the user indicates that they want to browse an Access Database file. It has been tested some and seems to work ok and should be enough to get you started.
Notes you need to consider:
ma_mdbfile is the name and path etc of the access database file.
m_mdbtable is the name of the table they wish to browse.
mdbq="Dbq="+alltrim(ma_mdbfile)
lcConnectionStr = "DRIVER={Microsoft Access Driver (*.mdb)};" +;
"&mdbq" + ";" +"UID=admin" + ";" + "PWD="
nAccess = SQLSTRINGCONNECT(lcConnectionStr)
msql="Select * from "+alltrim(m_mdbtable)
mtbl=alltrim(m_mdbtable)
SQLEX(nAccess, "&msql", "&mtbl")
browse noappend noedit nodelete
Hope it helps
Tom Gahagan
Alliance
Computer Solutions
"Music, like sex, is much too important to be left to professionals."
Robert Shaw