Board index » delphi » Adjust Access 97 security with Delphi 3

Marinus den Breejen

Delphi Developer
Mon, 07 Aug 2000 03:00:00 GMT

Adjust Access 97 security with Delphi 3

How can I change table rights for Access 97 from Delphi? Access does not
support the SQL Grant statement. Can I use VBA script in my Delphi
Applications?

MDB

 
Team

Delphi Developer
Tue, 08 Aug 2000 03:00:00 GMT

Re:Adjust Access 97 security with Delphi 3


Access uses the JET SQL statements, not necessarily ANSI SQL. You need to
look at the Access help file and determine how to do that under JET SQL. You
can't use a VBA script under Delphi. Another possible solution is to use a
TStoredProc tied to a stored query in the Access database and have it do the
rights change.

Juan

Quote
Marinus den Breejen wrote in message

<01bd3d4d$f528a660$05000...@bohr.harley.nl>...
Quote
>How can I change table rights for Access 97 from Delphi? Access does not
>support the SQL Grant statement. Can I use VBA script in my Delphi
>Applications?

>MDB

Other Threads

1. MS Access 97 - security and user rights

2. MS-Access 97 security problem

3. D5-ADO-MS ACCESS 97 database-MS Office 97 Access ODBC driver-Autoincrement probs

4. Accessing Delphi (Paradox?) data using Microsoft Access 97

5. Accessing MS Access 97 data from Delphi 3

6. Delphi 4 + Native Ms Access 97 driver + MS Access queries

7. DELPHI 3.0 and ACCESS 97

8. Delphi 5 and MS Access 97 passing of Strings

9. delphi to access 97

10. Autoincrement field and Access 97 with Delphi 5