VB6 query to SQL2000

[StormbringerX]

Hi all,

This question may more suited to the SQL forum, please pardon me if it is.

I'm looking for a way, through VB6, to give the users limited query capability on an SQL2000 database.

Ideally, I would simply like for them to be able to query tables in whatever manner they choose with no option at all to modify or delete either tables or rows. The users aren't savvy enough to create their own select statements for me to pass on and I hate to reinvent the wheel if someone out there has done something similar. Is there a VB OCX/DLL that will allow me to set somethinhg like this up? Or maybe another vendor that provides that type of control that someone in this forum has used and can recommend?

As always, thanks for your time...

Dave

 

[stoolpigeon]

MS Access - with linked tables to views.

Do the rights on the SQL 2K side.

 

[harebrain]

Depends on how much versatility you want to provide. At the low end, you could write stored procedures (maybe parameterized) that are SELECT queries. Then just let them pick the proc they want. Granting permissions just to the stored procs would also prevent them doing anything to the underlying tables.