Error 1004- Query did not run or a database table cannot be opened

ProdOps

New Member
Joined
Feb 27, 2009
Messages
3
I have an end user in Korea who is encountering an error when they execute a ListObject.QueryTable.Refresh from Excel VBA against an Access Db Query. There are three Excel worksheets with ListObject.QueryTable.Refresh updates in the workbook. Two are linked to Access Queries and one is linked to an Access Table (that is a linked Excel file in the Access Db).

The Korean user can execute the Refresh against the Access Table successfully but receives the following error message when trying to run the Refresh on either of the Access Queries:

Error 1004- Query did not run or a database table cannot be opened.
Check the database server or contact your database administrator.
Check you can use an external database, the database has been moved or reorganization, and then try the operation again

Since the Excel QueryTable refreshes for the Access queries run on multiple PCs in the US and not in Korea I assume it has something to do with Language or Locale but I am not sure and would appreciate any suggestions.

Excel 2007 and Access 2007

Thanks,
ProdOps

Current Connection String:


Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin; Data Source=\\rshbgfs1\business\Human Resources\International\Korea\Kiosk\KRW-Kiosk.accdb; Mode=Read;Extended Properties="";Jet OLEDB:System database=""; Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=6; Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2; Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=""; Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False; Jet OLEDB:Don't Copy Locale on Compact=False; Jet OLEDB:Compact Without Replica Repair=False; Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False




</PRE>
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,224,584
Messages
6,179,693
Members
452,938
Latest member
babeneker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top