Jet OLEDB:Link Provider String to secured db 
Author Message
 Jet OLEDB:Link Provider String to secured db

Use DAO to delete the existing tabledef objects and re-create them,
setting the .Connect property. users running the code only require
open/run on the database, and no perms on the underlying tables.
there's a code sample in the Access Security FAQ or post back and i'll
dig it out for you.



Quote:
>Hello all:

>Trying to refresh the links to a secured db and can't seem to get the syntax
>correct. Of course, the Jet DB Engine Programmers Guide on MSDN has DAO
>samples.

>Anybody know how to do this???

>Thanks,

>Tom Nelson



Sun, 23 Feb 2003 06:25:02 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Jet OLEDB:Link Provider String

2. Microsoft.Jet.OLEDB.4.0 OLE DB provider

3. Replace OLEDB provider Jet 3.51 with Jet 4.0

4. Create Jet 3.5x DB with OLE DB Provider 4.0

5. Microsoft.Jet.OLEDB.3.51 provider not registered

6. Microsoft Jet OLEDB Provider 3.51: Does it support parameterized querys

7. Problem using OLEDB provider for Jet 3.51

8. Jet OLEDB provider: Valid wildcard SELECT returns nothing in ASP

9. How to set Format property in ACCESS2k thru ADOX using JET OLEDB 4.0 provider

10. Updating child recordsets using the Microsoft.Jet.OLEDB.3.51 provider

11. Jet OLEDB.4.0 and MSDataShape Providers

12. Field properties bug in Jet.OLEDB provider SP5

 

 
Powered by phpBB® Forum Software