> >In a scenario where our client will be using our program as a "closed" > system, however, we want of course to put VFP databases on the server. We > have downloaded the latest VFP ODBC driver from Microsoft and seem to be > doing everything according to the book, but all of the generated SQL code > causes errors of various kinds. However, if I build a remote view to an > Access database or a SQL server database, using the respective ODBC > drivers, everything works perfectly. > > > >Why doesn't VFP want to let us do this with VFP databases? Have you tried running all of the database stuff outside of the application -- that is, opening the connection, retrieving data, updating data, etc., from the Command Window. /Paul