Search results for query: *

It seems to me that it is not to the view to which you grant access but to the underlying table(s). Thus if you GRANT PRIVELEGES on each table that participates in the view to who_ever then who_ever will be able to use those priveleges on the view with no further action required.

1) on the Click event of the treeview - if the selected node is the root then remove it from the selected items collection. 2) on drag and drop - check to see if the target node is the root. If so disable drop and show "no-drop" icon else allow drop

It would be helpful if you were to include a copy of PL/SQL you have written. Or at least include the errors.

What are you using to connect VB to Oracle? OO4O? ADO? RDO? You must create a string and store your SQL statement in it. Then you'll have to use a connection object to instantiate the database so you can create a dynaset based on your query. Does this help?

Perhaps I wasn't clear... We all know that MS Access is limited in that one cannot write stored procedures, rules, or triggers. I was hoping to overcome this limitation by writing functions in modules in MS Access that would behave like stored procedures that could be called from clients...

I am attempting to access a function from VB 6 that returns a string within an MS Access module. I am getting nowhere with the syntax that I assumed to be: "mystring = dba.DoCmd.OpenModule(modname, procname)" I have proven that dba is there by getting the tabledefs count and the...