Subject Re: [firebird-support] Re: Access denied!
Author Daniel Rail
Hi,

At January 27, 2006, 10:37 AM, stefanbalzter wrote:

>> System is a built-in account. By default, the Firebird service runs
>> under that account so no user needs to be logged in for the database
>> server to run. Check the properties of the Firebird service in the
>> Services applet in Control Panel to see which account is being used.

> I'll check that, thanks.

>> In a secure system, users should have NO rights to the database file.

> OK, that's the way it SHOULD be... ;-)

>> Ahh. So the original file is also affected? The plot thickens!
>>
>> What was the original problem with the database? Was it fixed on your
>> machine? Copying a database file directly is not a good idea unless
>> the database server is shutdown. The file may have some corruption.
>>
>> If you have a working copy on your machine, you should do a backup. On
>> the client machine, create a new database and restore from your backup.

> That's the problem: Even trying to create a new database causes an
> "access denied" error. The original problem was as follows: I have a
> method that automatically updates the database (if needed) when the
> program file was updated.
[...snip...]
> So I offered my client to do the necessary alterations manually for
> her. She sent me the file, I changed it and sent it back, but the
> error persisted.

> More mysterious, I also have a single user edition of my application
> that works with FB embedded server, so I gave her this one, and it
> works fine with the DB file I sent to her. So, the FB server must have
> some problem that the ES does not have. But which one? It's nothing
> with user name/password at any rate.

Maybe the database path is restricted via Firebird.conf. Check to
make sure that it isn't.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)