no read permission on 'tblQuickQuote'.

[scroce]

here is the full error message:


Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'tblQuickQuote'.

/njsbaig/QuickQuote/QuickQuoteProc.asp, line 44


I'm trying to do DSN-less data connection. I am running PWS on windows95

line 44 is this:

rsQuickQuote.Open Query

This is supposed to open up a recordset in an access database and add records from a form. I've gone through and made sure that the virtual directory exists on PWS and that it has read, write and execute properties checked. What am I missing? Where do I set this supposed persmission?

How much water would there be in the ocean if it weren't for sponges?

 

[scroce]

OK, I found the resolution for my own question.

In this case, the solution was in the access database itself.

In Access97 from the Database Window, you have to go to Tools>Security>User and Group Permissions. You will see two windows side by side. The one on the left is called "user/group name" and the one on the right is called "object name". "Admin" is the default user name, and if it's permissions aren't set (of course you have to be using the admin user name in your connection string), then the aforementioned error message will be generated. If you assign appropriate permissions in the check boxes below in that screen and save them, your db connection may indeed work.

How much water would there be in the ocean if it weren't for sponges?