RE: 0x80004005 - you need permission to view its data
From: Jeff Grundy (JeffsGrundy_at_nospam.nospam)
Date: 09/02/05
- Previous message: Vishal Gandhi: "RE: Script User Rights"
- In reply to: Sophie Guo [MSFT]: "RE: 0x80004005 - you need permission to view its data"
- Next in thread: Sophie Guo [MSFT]: "RE: 0x80004005 - you need permission to view its data"
- Reply: Sophie Guo [MSFT]: "RE: 0x80004005 - you need permission to view its data"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 2 Sep 2005 12:35:04 -0700
Actually the database is Access 2000
I looked at the 3 links you provided.
The first one says to install the latest Jet service pack on the server, I
did that
The second one says to create a folder "in the operating system installation
directory". I assume that to be c:\winnt. I created the folder c:\winnt\temp
and gave 'everyone' full control. I also set temp and tmp envir variables to
that folder.
The third link deals with connection to an Access DB from asp. I am using
the linked server functionality of SQL to avoid this whole issue.
When I use enterprise manager to browse the linked server from the SQL
server machine I can see the tables in the database. When I try to browse the
same linked server from my dev workstation I get the error 'Error 7399: OLE
DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].'
This seems to be a related problem.
Jeff
"Sophie Guo [MSFT]" wrote:
> Hello,
>
> Access 97 has been out of support boundary and is not officially supported.
> I suggest that you refer to the following articles:
>
> 818182 PRB: Error Message: "Unspecified error" Occurs When SQL Server
> Accesses
> http://support.microsoft.com/?id=818182
>
> 814398 PRB: Error 7399 When You Run a Linked Server Query That Uses the OLE
> DB
> http://support.microsoft.com/?id=814398
>
> 306269 PRB: Error 80004005 "The Microsoft Jet Database Engine cannot open
> the
> http://support.microsoft.com/?id=306269
>
> Sophie Guo
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
- Previous message: Vishal Gandhi: "RE: Script User Rights"
- In reply to: Sophie Guo [MSFT]: "RE: 0x80004005 - you need permission to view its data"
- Next in thread: Sophie Guo [MSFT]: "RE: 0x80004005 - you need permission to view its data"
- Reply: Sophie Guo [MSFT]: "RE: 0x80004005 - you need permission to view its data"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
