Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB 6
|
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 15th, 2004, 10:04 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 121
Thanks: 1
Thanked 0 Times in 0 Posts
Default Crystal Report creation problem

Hi Experts,
I have ASP application that has Crystal Report capabilities to view reports connected over ODBC DSN to the "Access 97" database. This application used to work OK before they replaced the server PC. Now if I run this application it works fine except Crystal part. I am getting the ERROR in the browser:
"Error Occurred Reading Records: Logon failed. Details: HY000:[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data."
I gave all possible permissions for IUSER to the MDB file and to entire folder and to C:\WINNT\TEMP folder, but it did not help???
Any input will be appreciated.
Thanks in advance,
   Dmitriy :(
 
Old April 19th, 2007, 10:14 AM
Registered User
 
Join Date: Apr 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That's Easy
Add a USER (yes, the USER Username) read permission to the MDB file, and that's all.

 
Old April 19th, 2007, 10:17 AM
Registered User
 
Join Date: Apr 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by rickybsb
 That's Easy
Add a USER (yes, the USER Username) read permission to the MDB file, and that's all.

CORRECTION: ADD A USERS (USERS GROUP)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Report problem donsls Crystal Reports 0 October 10th, 2006 09:27 AM
Crystal Report Problem HELP ! Melibe Beginning VB 6 2 August 23rd, 2005 02:09 PM
Crystal Report Problem harland Crystal Reports 0 November 19th, 2004 02:09 AM
Crystal Report Problem harland Classic ASP Professional 0 November 18th, 2004 10:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.