Again databases...

[Xmas79]

Ok, now it's time of connecting to a MS Access database. I want to do an access by "user", so some users can only read from the table "Customers", and other users can only read from table "Articles". I tried to create a connection string by dragging into the form the CONNECTION object, but it says me it failed to connect to database. No reserved or strange words in the users name, nor stange passwords. Maybe it's not a .NET problem, but a MS Access one?
Let's start from the beginning?

- How can I create a multiuser database?
- Yes, I know how to do that.
- How do you establish connection with that database?
- I drag and drop the CONNECTION object....

Why these 2 easy step won't work?

Thx, Xmas

[Xmas79]

P.S.

Good night!

[Lunatic3]

Do you mean multi user at the database level? Have you set the security options in the access? If so then you need to set the advanced properties of the connection string and it should know where is the security file of access database that holds the user information. Drag and drop a connection on the form (from the Data tab) and then set the connection string and its advanced settings.

[Xmas79]

Ok, thanks...

I'll try, and then let you know!
Best regards.