VB - Database Access

Thread preview

Thread	Last Post	Replies

The Vb6 datacontrol can't use Dao3.6 ?	31 Oct 2003 22:59 GMT	1
I must run a VB6 application that uses a DAO datacontrol on XP/OfficeXP pc's that only have Dao 3.6 (and no 3.51) installed. Read in het Ms-KB that the intrinsic DAO datacontrol in Visual Basic 5.0 was written to use Microsoft Jet 3.51 and for that reason wants to have Dao 3.51 ...
N00B NEEDS HELP-Changing desktop images over network	31 Oct 2003 22:44 GMT	1
whats up. my boss just assigned me this task to change all the desktop images on everyones computer over to the new logo of the company. i know im suppose to use VBScript. but: On Error Resume Next
What is wrong with these 4 lines of code ?	31 Oct 2003 22:38 GMT	3
All, Could someone please tell me what is wrong with this code If I hard code the id I get correct answer if I try to read the id from a text box I get this Error
Using Database Passwords	31 Oct 2003 22:22 GMT	3
I am trying to use a password protected Access 2000 database in a VB application but I keep getting error messages that the password supplied is incorrect (even though I know it is not). Please advise what is wrong in the following. Thanks for any help.
Creating Recordset from an ARRAY	31 Oct 2003 21:00 GMT	2
How do I create a recordset from an Array. I tried appending fields to teh recordset, then tried adding new records. Something is missing somewhere, it doenst' work. Any clues ?
How to open password protected excel workbook through VB-6 ?	31 Oct 2003 18:41 GMT	3
How to open password protected excel workbook through VB-6 ? I can open workbooks having no passwords through microsoft jet provider, but I don't know how to open password protected workbook ? Best Regards,
ADO w/Datagrid control	31 Oct 2003 18:37 GMT	2
I hope somebody can help me with this problem as I transition from VBA to VB. I have a form with two ADO Data Controls, a text box, and a datagrid control. ADODB1 is connected to
Executing sql statement with SUM and CASE.	31 Oct 2003 18:23 GMT	2
I have a sql statement as below: SELECT SUM(CASE WHEN DUNAPPL>=5 THEN 1 ELSE 0 END) as TEST from xyz group by a,b,c When I run this sql statement in TOAD or SQLPLUS I get all the data and it
Closing a database in VB .Net	31 Oct 2003 17:47 GMT	2
Hello everone. Can somebody help me? When I run my code I can rear, write to and delete from database, but when I have done one of these things and try to copy the databasefile from my
talk to the hand	31 Oct 2003 17:05 GMT	3
Hi: I would like to implement changing the pointer to the hand symbol for selection. I haven't been able to find any documentation on the subject. Is this possible in VB?
returning key value for inserted record	31 Oct 2003 13:58 GMT	2
vb6, sp5. access 2000, sp3. I have a table with teh key defined as autonumber. i use a sql insert statement to insert the record into the record set. how do i get the keyvalue of the record that i just inserted?
The best way to retrieve table schema info?	31 Oct 2003 13:18 GMT	9
I am trying to find the best way to retrieve a table schema info, mostly column attributes, using ADO. The method I am incorporating right now is the following sql statement: SELECT * FROM HISTORY WHERE 1=0
VB with which database	31 Oct 2003 11:52 GMT	7
What is the best combination of vb6 and some database, in network of cca 20 computers. Is it Access, PostgreSQL or MYSql? Thank you.
I need an Access-based contacts database written in VB.	31 Oct 2003 11:42 GMT	3
Where can I download a contacts database written in VB using Access as the db? -- Julian Milano
Licensing???	31 Oct 2003 08:28 GMT	1
VB6 SP5 and MS Access 2002 I have written an app in VB which uses an Access database. Does anyone know whether, if I distribute it, the user needs an Access licence?