Data provider could not be initialized

C

Chris

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data provider could not be initialized 1
Office add-in registration error - Component not correctly registered 0
Data Provider Could not be initialized 3
PLEASE HELP: Design Students Screener in Access 2
Data Access Page 1
Data provider could not be initialized 0
Connection String to SQL Server in VBA 3
PLEASE HELP: Design a Student Screener in forms module 4

Top