>I want to convert a application from fpd26 to vfp6. I want the databases to be stored in MS Access. I need to create new tables dynamically create tables in MS Access at runtime.

Not sure why you would do this instead of just leaving all the data in VFP DBC and tables. But if you must, why not create all tables in MS Access? Then use ODBC connection in VFP to remotely connect to the MS Access database.