Problem accessing Access DB through ASP

From: Harry (Harry_at_discussions.microsoft.com)
Date: 10/30/04 

Date: Sat, 30 Oct 2004 00:20:02 -0700

Hi

I have a MS-Access 97 and IIS installed on my Win 2000 server. I have an
Analysis Software which analysis the composition of the clinker and other raw
material that are used in our company. I wanted some reports out of the data
that the analysis software database so i made a new database that is
basically a link to the analysis databases that also are Access 97 databases.
So now I have made the cross-tabbed reports but I want the access anywhere on
my intranet. So tried to access the pages through a simple ASP pages which
basically run the queries that my reports in access uses. But now here is the
problem I am not able to access the database through the ASP pages it gives
me error "Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read
permission on 'SampleTable'.
/Analysis/test.asp, line 25"
This SampleTable is there in the linked table of my database. I have done
everything from changing the permissions of my database and the base database
but of no use.

If anyone can help me out with this permissions problem i would be greatful

Cheers

Harry

Relevant Pages

  • Re: Protecting Database frm being Imported into a new Database
    ... The permissions that you set on forms, reports, etc in an MDB file can ... users can see the design of the ... However, users can create a new database, import an object, and play ...
    (microsoft.public.access.security)
  • Problems with ULS, i.e., removing permissions from tables
    ... My database is almost ready to be distributed to my users so I’m working on ... and queries and changing queries properties to run with owner’s permissions. ... current database as open/run ... other forms or reports results in the error “There was an error executing the ...
    (microsoft.public.access.security)
  • Problem acessing Access DB through ASP Pages
    ... Analysis Software which analysis the composition of the clinker and other raw ... that the analysis software database so i made a new database that is ... So now I have made the cross-tabbed reports but I want the access anywhere on ... If anyone can help me out with this permissions problem i would be greatful ...
    (microsoft.public.access.security)
  • Re: New Security Add-In Available For Download
    ... >> My latest Access MVP add-in is now available for download. ... >> This one is called the "Sandra Daigle Permissions Wizard." ... >> There are times when it is necessary to import the database objects ... >> The add-in has supplemental features of creating very slick reports ...
    (microsoft.public.access.security)
  • Problem acessing MS Acess Db from ASP Pages
    ... Analysis Software which analysis the composition of the clinker and other raw ... that the analysis software database so i made a new database that is ... So now I have made the cross-tabbed reports but I want the access anywhere on ... If anyone can help me out with this permissions problem i would be greatful ...
    (microsoft.public.access.externaldata)
Loading