>As I sad before this is a VFP database on the same computer. I dont think it's an access level issue.
>Mark

You say it is a VFP database on the same computer?? Is this a dbf on the local PC. Or is it on the same machine as the SQL Server. If it is on the same machine as the SQL Server, it can still be an access issue. Do you have select rights to the table? You can grant separate select/insert/update/delete rights. SQL Server is independent of anything else on the same PC.