access database security

Thread View: borland.public.cppbuilder.database.ado

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Tom Mon, 13 Mar 2006 17:16

#443

Author: Tom
Date: Mon, 13 Mar 2006 17:16

10 lines
1268 bytes

I protected my database with password in ms access via 
Tools->Security->Set database password, I use ADO connection and I enter 
user name: Admin and password: test; when I click on Test connection I 
get following error message:"The connection faild because of an error in 
initializing provider. Cannot start your application. The workgroup file 
  is missing or opened excusively by another user". I'm using a correct 
password. What am I missing?

Thanks in advance,
Tom

Re: access database security

#444

Author: Vladimir Stefanovic
Date: Mon, 13 Mar 2006 17:35

25 lines
1733 bytes

I can remember that there are *two* places to set the
password under connection string.

You definitely selected wrong one.

The right one is (if I remember well) in the last tab,
and you must search it under some items.



-- 
Best Regards,
Vladimir Stefanovic
"Tom" <tom@net.com> wrote in message 
news:4415a8c8$1@newsgroups.borland.com...
>I protected my database with password in ms access via Tools->Security->Set 
>database password, I use ADO connection and I enter user name: Admin and 
>password: test; when I click on Test connection I get following error 
>message:"The connection faild because of an error in initializing provider. 
>Cannot start your application. The workgroup file is missing or opened 
>excusively by another user". I'm using a correct password. What am I 
>missing?
>
> Thanks in advance,
> Tom

Re: access database security

#445

Author: Tom
Date: Mon, 13 Mar 2006 18:39

20 lines
1418 bytes

Hi,
thanks very much, it works now. Just like you said password needs to ba 
entered in Jet OLEDB:Database Password field on tab All in Data Link 
Properties.

Again thanks,
Tom.

Vladimir Stefanovic wrote:
> I can remember that there are *two* places to set the
> password under connection string.
> 
> You definitely selected wrong one.
> 
> The right one is (if I remember well) in the last tab,
> and you must search it under some items.
> 
> 
>

Re: access database security

#448

Author: Vladimir Stefanovic
Date: Tue, 14 Mar 2006 23:04

12 lines
1271 bytes

> Hi,
> thanks very much, it works now. Just like you said
> password needs to ba entered in Jet OLEDB:Database
> Password field on tab All in Data Link  Properties.

I'm glad to hear that :)



-- 
Best Regards,
Vladimir Stefanovic

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads