Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
-----------------------------------------------------------------------------------------------------------------------
"Tym" <spamtrap@ictis.net> wrote in message
news:4693bd66$0$962$ed2619ec@ptn-nntp-reader02.plus.net...
> So under ADO I can't hide the tables on the same jet database that i used
> in DAO when I *could* hide them?
>
>
> "William (Bill) Vaughn" <billvaRemoveThis@betav.com> wrote in message
> news:efSAHslwHHA.4384@TK2MSFTNGP02.phx.gbl...
>> AFAIK, JET has a very crude security system that makes access to the data
>> very easy--even when you assign a password. The net is awash with
>> password cracker routines. That's about all you can do--set up a password
>> on the file.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>>
www.betav.com/blog/billva >>
www.betav.com >> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit
www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "Tym" <spamtrap@ictis.net> wrote in message
>> news:46927902$0$8723$ed2619ec@ptn-nntp-reader02.plus.net...
>>> Jet/Access
>>>
>>> ...and you can see from the original code how I used to achieve it on
>>> DAO
>>>
>>> Tym.
>>>
>>> "William (Bill) Vaughn" <billvaRemoveThis@betav.com> wrote in message
>>> news:eq9adkkwHHA.3796@TK2MSFTNGP04.phx.gbl...
>>>> Which database are you using? Is it JET/Access, SQL Server, Oracle?
>>>> All of these databases have varying degrees of rights management. For
>>>> SQL Server you can grant rights to the user to limit which objects
>>>> (tables, procedures, views--everything) that they can see, read, write,
>>>> change etc.
>>>>
>>>> --
>>>> ____________________________________
>>>> William (Bill) Vaughn
>>>> Author, Mentor, Consultant
>>>> Microsoft MVP
>>>> INETA Speaker
>>>>
www.betav.com/blog/billva >>>>
www.betav.com >>>> Please reply only to the newsgroup so that others can benefit.
>>>> This posting is provided "AS IS" with no warranties, and confers no
>>>> rights.
>>>> __________________________________
>>>> Visit
www.hitchhikerguides.net to get more information on my latest
>>>> book:
>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>>>> -----------------------------------------------------------------------------------------------------------------------
>>>>
>>>> "Tym" <spamtrap@ictis.net> wrote in message
>>>> news:4691d302$0$8724$ed2619ec@ptn-nntp-reader02.plus.net...
>>>>> The problem of hiding the tables in my ADO database :-)
>>>>>
>>>>> The only reason I mentioned DAO and ADO was that I could do it in DAO
>>>>> but couldn't find a way in ADO of doing the same.
>>>>>
>>>>> Basically, I want to hide the tables in my ADO database to keep the
>>>>> end user's pesky hands off them - how do I do it?
>>>>>
>>>>> Tym
>>>>>
>>>>>
>>>>> "William (Bill) Vaughn" <billvaRemoveThis@betav.com> wrote in message
>>>>> news:%23H$8$OZwHHA.1204@TK2MSFTNGP03.phx.gbl...
>>>>>> What problem are you trying to solve by hiding tables? The DAO and
>>>>>> ADO.NET architectures are very different so what might be needed in
>>>>>> one might not be needed in the other.
>>>>>>
>>>>>> --
>>>>>> ____________________________________
>>>>>> William (Bill) Vaughn
>>>>>> Author, Mentor, Consultant
>>>>>> Microsoft MVP
>>>>>> INETA Speaker
>>>>>>
www.betav.com/blog/billva >>>>>>
www.betav.com >>>>>> Please reply only to the newsgroup so that others can benefit.
>>>>>> This posting is provided "AS IS" with no warranties, and confers no
>>>>>> rights.
>>>>>> __________________________________
>>>>>> Visit
www.hitchhikerguides.net to get more information on my latest
>>>>>> book:
>>>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>>>>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>>>>>> -----------------------------------------------------------------------------------------------------------------------
>>>>>>
>>>>>> "Tym" <spamtrap@ictis.net> wrote in message
>>>>>> news:4690bb4e$0$8724$ed2619ec@ptn-nntp-reader02.plus.net...
>>>>>>> IN my old VB6 apps, I used DAO and was able to hide tables using the
>>>>>>> following code:
>>>>>>>
>>>>>>> For Each myTableDef In dbLAILOKEN.TableDefs
>>>>>>> myTableDef.Attributes = dbHiddenObject
>>>>>>> DoEvents
>>>>>>> Next myTableDef
>>>>>>>
>>>>>>> Now I'm on vb.net 2005, and using ADO, I can't find a way of doing
>>>>>>> it...
>>>>>>>
>>>>>>> Can anyone help please?
>>>>>>>
>>>>>>> Tym
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>