how can I restrict the data tables

[Andrej]

I'm working with the Access 2007 program but the data base is in .mdb extension (2003)
My question is how to restrict parts of data base for the various users.
I tried to restrict by tool of access data base but the users are restricted just on my pc and on the pc where I put the replicas restriction doesn't work.
any idea...or established protocol that I can use?

 

[dfenton]

It's not clear what you mean. If you want to limit users to certain data, and all users have their own individual replicas, you could use partial replication, which filters the data in a replica according to a filter you define when you create the partial replica. That said, I've never used it, as I don't like having replicas with only part of the data. Instead, I build my application to restrict access to the data for the particular user.

However, it's not clear if either of those solutions is relevant to what you're asking. More details would help us answer your question.

 

[Andrej]

yes,I tryed to use ULS but probably I didn't implemented it properly.
Is there any way to turn it off.
I also was trying to implement partial replication and probably doesn't work because of ULS

 

[Andrej]

I also mess up with the database password...now I know that it's totally useless ...is there any way to turn it off...

 

[Andrej]

Also I mess with a database password. Is it possible to turn it off, it start to annoy me, writing the password and user name and know that is totally useless

 

[MSAccessRookie]

Please get the Security FAQ and read it.

I think Pat might mean one like this one.

http://64.233.169.132/search?q=cach...+2007"+Security+FAQ"&hl=en&ct=clnk&cd=8&gl=us

 

[MSAccessRookie]

Not that one.
This is the link to the security FAQ -
http://support.microsoft.com/kb/207793

Sorry about that, Thanks for correcting the misunderstanding

 

[dfenton]

Replication and ULS work fine together. However, you can't use database passwords with replication. Why anyone would want to use such a useless feature, I can't say, though.