querying/updating linked visual foxpro tables with Access 2003/ODBC

Hot Topic

Hiding the Database Window
Office 10 \ winword.exe runtime error
List box issues
Can't open regedit
AutoExec will not execute properly
Password question
Can i embed MS Access database inside Visio and query it using VBA
Outlook Contacts
Can you tell me why Int(1.4 * 100) = 139
Worksheet.Copy causes execution to stop

Microsoft ISV

Microsoft Office Document Imaging Printer Missing in Office 2007 (RFP) (86)
Sum of hours using select statement & VBA
Strange problem with saving to a FTP-server
Order by in select statement not working
Workbooks.Open (... problem
Help with looping process excel macro
Find and Replace Carriage Return in Excel with VBA
CRM 3.0 Error: Subreport could not be shown
whats wrong with this code?
Count and display in cell

querying/updating linked visual foxpro tables with Access 2003/ODBC

Using ADO 2.8 SP1 and tables linked to VFP, I get an error # -2147467259 that says "Could not delete from specified tables". I've downloaded latest VFP ODBC driver. The tables are part of an application developed in VFP, and although there is a dbc file, the tables are loose. Any insight or suggestions will be greatly appreciated.

Thanks.

cbrack

Answer this question

querying/updating linked visual foxpro tables with Access 2003/ODBC

Tdar

You can't delete a table that in linked to other database in MS Access. You can delete the link, but not the table itself.

Hope this can help.
querying/updating linked visual foxpro tables with Access 2003/ODBC

Answer this question