No read permission on access database odbc connection

[mdirect]

I've developed a number of coldfusion pages on my local machine and had a
number of problems with the dreaded error:

Record(s) cannot be read; no read permission on 'xxxx'.

I eventually managed to sort the problem on my local machine by re-creating
all the databases from scratch and importing all the records from the old
database. This eventually worked after several attempt going around in circles.
However I've now come to publishing the pages on our web server but cannot get
around the "no read permission on xxx" error again when connecting to tables in
the database, I've tried the trick of re-creating the databases and copying all
the data into the new tables but this time its not worked.

I've set up a test database called TEST1.MDB it has one table in it called
TEST with one field called TESTFIELD, the database has protection via a
workgroup administration file and I've set up a user called WEBSERVER within
User and Group Accounts within Access 2002. I've used User and Group
Permissions to make the user a member of the Admin group and have also assigned
Read Design, Modify Design, Administer, Read Dada, Update Date, Insert Data and
Delete Data permissions to table TEST to user WEBSERVER.

I've set up a datasource name using Coldfusion administrator to the TEST1.MDB
database, the connection tests OK.

When using the following cfquery tag:
<cfquery name="Recordset1" datasource="test" username="WEBSERVER"
password="WEBSERVER">
SELECT *
FROM C:\DATA\Work\Shared\wwwroot\scweb\Databases\test1. TEST
</cfquery>

i get the error: Record(s) cannot be read; no read permission on 'TEST'.

I don't think the problem is with access to the TEST1.MDB database file itself
as if i change the cfquery tag to look for table TESTDUMMY then the error
changes to: "The Microsoft Jet database engine cannot find the input table or
query 'TESTDUMMY'. Make sure it exists and that its name is spelled correctly.
" - indicating the connection has managed to at least get inside the TEST1.MDB
file and see what tables are there.

I'm pulling my hair out now with this as I can see no logical explanation as
to why this is now working. Any help most gratefully received.

Yours,

Simon

[mdirect]

Hi Everyone,

I managed to sort this one in the end myself - it was the System Database File
missing under the Coldfusion data sources. I had created a .mdw workgroup
information file which contained the security information. I was presuming that
the odbc connection to the database would have picked up and access default
..mdw file however this obviously wasn't the case, I would image it was using
the default system.mdw file on the server. I put in our own .mdw file and now
works ok.

Great stuff.

[BKBK]

Typo?

<cfquery name="Recordset1" datasource="test" username="WEBSERVER" password="WEBSERVER">
SELECT *
FROM C:\DATA\Work\Shared\wwwroot\scweb\Databases\test1. MDB
</cfquery>