Hello, i ported my data from foxpro to mysql 2005
created a few remote views but when i try to access the data in SQL using

USE datamain!useracesscon

(datamain being the name of the foxpro database)
(but Sqlmain being the name of the SQL dataase)

it says useracesscon.dbf isnt found and useracesscon is a remote view IN datamain.

and when i checked the syntax it says database then sQl view


but when i run the form it tells me it cant find useracesscon.dbf and its not a dbf its a remote view