Use DBGrid on secured Access Database?

[GDGarth]

I want to use the DBGrid control on a table in a secured Access Database.

How can I pass the user name and password to the database so I can read and write records? I get the message "No Read Permissions on Table".

I can get around it by assigning full read, write, edit, delete permissions to all users, but I'd just as soon not do that.

 

[johnwm]

If your Datagrid is bound to an ADODC control, just right click on the ADODC, select ADODC properties, Use Connection String and hit the Build... button. It does it all for you.

If you are doing it in code, then you can stick in a (temporary) ADODC control. It's connection string will give you syntax for your connection object.
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[GDGarth]

I don't have that option, it seems.

I'm using the Data Control, and the DBGrid in VB5.0 to edit data in an Access 97 table.


I don't know what an "ADODC control" is, but I don't think that's what I'm using.

 

[johnwm]

Sorry I can't remember the answer in VB5 - I foolishly assumed VB6
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'