We have a system that was using visual basic as front end and mdb as the backend, and we want to update our existing system [this is a foxpro platform] everytime that the system/records validates [this is the one using visual basic]

I am trying to convert mdb table to foxpro but i havent found any solution yet, i tried vb as my front end but still there an errors i was not able to fix, some fields names of the system is reserved word from the microsoft jet 4.0 OLE provider and we no longer change the field name of the system because it was purchased, or we just simply getting data from mdb and append it to foxpro table, how can i do that? the table is a free table.

one thing more, i try to create a macro to mdb to export the a certain table to xls and xls to foxpro, but the database has a password and only the administrator can access that, we want the exporting or getting mdb data and update it to foxpro table eveytime the user open up a the purchased system.

Thanks..