VB - Database Access

Thread preview

Thread	Last Post	Replies

Operation is not allowed in this context	15 Apr 2004 03:31 GMT	3
I have a quesiton. Rs.close cannot work. It prompt the error that "Operation is not allowed in this context". In form 1, I set the recordset rs and display in the grid.
Authentication failed for Access	14 Apr 2004 21:05 GMT	1
Using VB6 and ADOX I created an Access database. Then I convert the code into ActiveX DLL and call it from another vb program, the error message says "Authentication failed. Please help Thanks.
New version VB.NET	14 Apr 2004 19:27 GMT	2
Is VB.NET version 1) 2002 and 2) 2003. When new version at 2004-2005 ?
any link???	14 Apr 2004 14:04 GMT	4
Do you have any link to learn how work with database in visual? thaks a lot ivan
select max(tbl_id) from my_tbl	13 Apr 2004 23:53 GMT	2
tbl_id is an autonumber column in an Access table. Does this query guaranty to return the tbl_id of the newest record in the table Thanks.
Access 2000 DB Table Name use reserved keyword	13 Apr 2004 23:30 GMT	2
I have an access 2000 db which I am accessing through VB ADO connection. One of the tables uses a keyword - FILTER INVENTORY. So I am having a problem with using a sql select statement for this,
ADO Dsn, Register	13 Apr 2004 19:44 GMT	1
¿Is ado capable of register an dsn equal to registerdatabase o registerdatasource for DAO or RDO?
ADOX - adVarChar	13 Apr 2004 17:38 GMT	2
oTable.Columns.Append "name", adVarWChar, 255 ' O oTable.Columns.Append "name", adVarChar, 255 ' Erro VB6 does not allow me to use adVarChar here, why Please advise. Thanks.
Basic Macro on Excel help?	13 Apr 2004 15:49 GMT	12
Dear Excel experts, I am trying to build a macro in excel (I think that is what it is called) to perform some functions for me on excel. I don't really know how to do this, and was hoping someone could write a quick code for me that does what I am
Set Focus - Newbie	13 Apr 2004 15:12 GMT	2
I am having a minor problem with validation? I am attempting to force a user to enter something in a text box. On a lost focus event I test the textbox for a value. If it is blank I display a message and return him to the text box.
missing data in reports WITHOUT pause or loop for delay	13 Apr 2004 14:31 GMT	8
I am running Crystal Reports 9 and VB 6.0. My report will only display 0 value in one of the data fields if I don't add some type of pause or loop to insert a delay while Crystal fetches and displays the report. I have tried many suggestions I have seen online with nothing working, ...
tables.append fails with -3251 Object or provider is not capable of performing requested operation	13 Apr 2004 14:29 GMT	7
Dim tbl As New ADOX.Table Dim cat As New ADOX.Catalog cat.ActiveConnection = MyConnection tbl.Name = "Testing"
Problem opening a database with OpenDatabse	13 Apr 2004 13:51 GMT	1
I am using Visual Basic in MS Access 2000. I am trying to open a second database to read in some table data. When I write code to open a dbase using the OpenDatabase() method I have a problem:
Cannot open password protected MDB file using DAO	13 Apr 2004 13:23 GMT	3
I've developed an application (VB 6.0, DAO 3.6 Object library, Access 2000). I need to password protect the MDB file. And I made the changes in application also, where I was opening the database. Code is as follows:
Inserting into an OLE Object in an Access Database	13 Apr 2004 04:12 GMT	3
I have an Access database with one field in a table defined as "OLE Object". I can of course insert objects (such as a bitmap image) into this field with Access' "Insert" pull-down menu option, but how do I programmatically do the same thing? Let's say I have a bitmap file ...