I have created a linked server. The code is like this.

sp_dropserver @server = 'MYSERVER'
GO

EXEC sp_addlinkedserver 
    @server = 'MYSERVER',
    @srvproduct='Visual FoxPro 9',
    @provider='VFPOLEDB', 
    @datasrc='F:\MyDirectory\MySubDirectory\app_data',
    @provstr='Collating Sequence=MACHINE'
GO

insert dateformat (adduser,adddate,moduser,moddate,format)
Select * From openquery(MYSERVER,
'Select adduser,adddate,moduser,moddate,format from dateformat')

Once created, I want to execute a query. However, I have an access denied. What am I missing?