This is a discussion on "MSAccess query error" within the Databases section. This forum, and the thread "MSAccess query error are both part of the Program Your Website category.
|
|
|
|
|
 |
||
MSAccess query error
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
|
#1
Sep 15th, 2005, 19:55
|
|||
|
|||
|
MSAccess query error
With ColdFusion and MSAccess 2003, the following query
SELECT A.*, B.entry_id FROM A.blog_entries, B.blog_subscriptions WHERE B.blog_id = #variables.blog_id# AND B.user_id = '#variables.userInfo.user_id#' AND A.user_id = B.user_id returns this error : [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\WINDOWS\system32\B.mdb'. Please advise. Thank You.        
|
|
|
|
#2
Sep 15th, 2005, 23:09
|
|||
|
|||
|
The problem with it isn't your SQL statement, it's with your connection string. I'm guessing it's looking for the database somewhere other than where it should be. Are you using the full path to the file?
|
|
| Tags |
| msaccess, query, error |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Keep getting error message Microsoft VBScript runtime error '800a01a8' | cpando1974 | Classic ASP | 2 | Aug 7th, 2007 12:00 |
| MySQL query query | dangergeek | Databases | 3 | Apr 12th, 2007 12:45 |
| ASP & MSAccess | joshlindem | Classic ASP | 1 | Jul 19th, 2005 07:43 |
| converting msaccess > sql | spinal007 | Databases | 3 | Sep 29th, 2004 17:22 |
