Board index » delphi » Changing user rights in MS-Access

MJA van Houtert

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Changing user rights in MS-Access

Hi,

Who knows how you can change the MS-Access user rights from a Delphi
application? For instance: grant users read-only access to a database!!
thanks in advance,

Marcel

 
Sundial Service

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Changing user rights in MS-Access


It's appropriate to refer you to the Microsoft Jet Programmer's
Reference (available from MSDN or from Microsoft Press).

As far as I recall, Jet does not implement the GRANT syntax for managing
user permissions.  Instead, it uses DAO (Data Access Objects) and
provides properties that may be used to manage the permissions assigned
to a particular user.

However, frankly it may be much more convenient to use MS Access itself
for this purpose.  Permissions are not something that I generally think
of as being changed dynamically, particularly since you must be logged
on [to the MDB] as its administrator to do anything.

Quote
>MJA van Houtert wrote:
> Who knows how you can change the MS-Access user rights from a Delphi
> application? For instance: grant users read-only access to a database!!
> thanks in advance,

------------------------------------------------------------------
Sundial Services :: Scottsdale, AZ (USA) :: (480) 946-8259
mailto:i...@sundialservices.com  (PGP public key available.)
Quote
> Fast(!), automatic table-repair with two clicks of the mouse!
> ChimneySweep(R):  "Click click, it's fixed!" {tm}
> http://www.sundialservices.com/products/chimneysweep

M.H. Avegaar

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Changing user rights in MS-Access


You could use DAO (see question 6 on
http://www.islamov.com/diamond/q&a.html).

"MJA van Houtert" <hout...@casema.net> schreef in bericht
news:3982ccca$0$18658@reader2...

Quote
> Hi,

> Who knows how you can change the MS-Access user rights from a Delphi
> application? For instance: grant users read-only access to a database!!
> thanks in advance,

> Marcel

Other Threads

1. MS Access 97 - security and user rights

2. Problem with MS Access 97 database, accessed by group of users

3. User access rights on shared Paradox files

4. Changing access rights to files in NT

5. How to check access rights on MS SQL7

6. MS Access gives right truncated (null) message

7. MS-Access on NT when you don't have adminstrator rights

8. Delphi & MS Access database(multi-user)

9. Help : ODBC - Delphi 1 -Access - Cannot edit record changed by another user-

10. Number of Users with MS Access 2000