CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Protected (read only) access to access db

Print topic Send  topic

Author Message
wegmann

Posts: 3
Posted: 03/26/2006, 12:43 PM

Hello

I would like to use the CCS as reporting tool only, so I need no write access to my mdb files.

I got a P.O.S. System where the db is in two mdb files. For realtime Inventory, I created a CCS report.

If I do this for tests purposes with the daily backup mdb - it's no problem.

If I try to do this with the actual working mdb, I got access problems. When I open the db with access, it works fine. When I use MS Sharepoint to generate reports it works also. But with CCS ther's allways the same:

[OleDbException (0x80004005): Das Microsoft Jet-Datenbankmodul kann die Datei '\\Spielbar\intercafe\DATEN.MDB' nicht öffnen. Sie ist bereits von einem anderen Benutzer exklusiv geöffnet, oder Sie benötigen eine Berechtigung, um die Daten lesen zu können.]

Can I set CCS to open the db only in (shared) read mode?

Thank you

Peter
View profile  Send private message
wegmann

Posts: 3
Posted: 03/26/2006, 10:43 PM

Just found by trial & error

I had to set the share for the mdb folder to EVERYONE FULL ACCESS and to do the rest on the security page of that folder.

Thank you
View profile  Send private message
Oper


Posts: 1195
Posted: 03/27/2006, 7:52 AM

Do not use Everyone is not needit

Assigne Write/Create/Delete to the use IIS user
IUSR_whaever is the name.


The isue come casue the user will need to handle the recordLoking file .LDB and deleted after end if needit

Everyone is nasty
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.