Data provider could not be initialized

's Computer Specifications

The code below works fine in a form of MS Access 2000 but it fails to run in
Access 2003 with an error message "Data provider could not be initialized."

Code:
'-------------------------------------------------------------------------------------------
strSQL1 = "Select * from RAW_HOUSE_PRICE_INDEX_TEMP IN '' [MS
Access;Database=C:\Db_v2.mdb;Pwd=234];"
Me.Form.RecordSource = strSQL1
'-------------------------------------------------------------------------------------------

If i copy the SQL and run in MS Query, i can obtain the results correctly
but i just could not put it into the "Form.RecordSource"

Thanks for your kind help in advance!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data provider could not be initialized	John Q	Microsoft Access Form Coding	0	14th Feb 2008 09:37 AM
Data Provider Could Not Be Initialized	Alan Z. Scharf	Microsoft Access ADP SQL Server	2	1st Mar 2007 06:31 AM
ADE: data provider could not be initialized	=?Utf-8?B?QXVicmV5?=	Microsoft Access ADP SQL Server	9	14th Jun 2005 02:40 PM
Data provider could not be initialized	=?Utf-8?B?RGF0YSBQcm92aWRlciBjb3VsZCBub3QgYmUgaW5p	Microsoft Access Security	0	29th Dec 2003 01:36 AM
Data Provider could not be initialized	=?Utf-8?B?WXZvbm5lYg==?=	Microsoft Access VBA Modules	0	29th Dec 2003 01:31 AM