Groups | Blog | Home
all groups > vb.net data > july 2007 >

vb.net data : Hiding Tables...???


Tym
7/8/2007 12:00:00 AM
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

William (Bill) Vaughn
7/8/2007 12:11:06 PM
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)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Tym
7/9/2007 7:17:37 AM
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


[quoted text, click to view]

William (Bill) Vaughn
7/9/2007 9:49:26 AM
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)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

William (Bill) Vaughn
7/9/2007 11:57:40 AM
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)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Tym
7/9/2007 7:05:54 PM
Jet/Access

....and you can see from the original code how I used to achieve it on DAO

Tym.

[quoted text, click to view]

William (Bill) Vaughn
7/10/2007 10:56:43 AM
Ah, hiding TableDef objects in DAO does not really hide the tables from
customers with Access.

--
____________________________________
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)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Tym
7/10/2007 6:09:57 PM
So under ADO I can't hide the tables on the same jet database that i used in
DAO when I *could* hide them?


[quoted text, click to view]

AddThis Social Bookmark Button