VB Forum / Database Access / January 2004

I'm creating databases with ADOX 2.8 in visual basic 6 sp5
I have no problems creating the databases.
What I have a problem with is the size of text which I can put inside the
fields I created which are of type adLongVarWChar.

I was wondering if there is any free zipcode database out there, or is it
only available commercially?
Thanks!!
SHAMAN

I am using DAO, in a VB6 project with Access97. is there anyway to set the
Access 97 database Password, and open the databse that is protected by a
password from VB ie using opendatabase, and also using data control, If I
set the password it cant't open the database .

I have searched google for this error message and found a lot of people 2000/2002 were asking
about it.  Generally it appears sporadically, just often enough to make users consider your
software broken.  It occurs when you issue a recordset update in vb or asp.  The database can ...

Hey Guys!
I'm new to the VB database world, but have successfully created an
Attendance Management program in VB 6 that compiles with no errors.
The program tracks employees names and numbers and when you click on a

I just read that:
adOpenDynamic: This cursor type isn't supported by the Microsoft Jet 4.0 OLE
DB Provider.
What can I do to achieve the same behavior (meaning - when user1 adds a

we use a sql server database and stored procedures. We
call them as follows
   Cmd.CommandText = "proc_AttestSocFran3"
   Cmd.CommandType = adCmdStoredProc

This is a little project for school, a simple database, in a mdi style
application. My problem is when i make change to the DB with my DBform and
the MSflexgrid is open at the same time, the grid didn't refresh. How i can?
Thank.

This is a little project for school, a simple database, in a mdi style
application. My problem is when i make change to the DB with my DBform and
the MSflexgrid is open at the same time, the grid didn't refresh. How i can?
All the application is using ADO code, not ADODC.

I have a windows database application which uses Ado data
control. Every time refresh method is called, the memory
adds up and eventually my machine runs out of memory. Any
clue how to deal with it? Thanks!

I have the next code and it is running very well but with one question I do
at the end after the code:
I have an excel sheet called test with three columns (F1, F2 and F3)
Public Sub Form_Load()

We open an ado connection, change some fields with
queries, followed by .update. Then we close the recordset
and continue on with other code, which opens another
recordset pointing to the table what was updated.

I'm trying to teach myself VB.Net and my question is where can
I download a copy of VB.Net Standard trial version or Visual
Studio .Net trial version.
thanks

In an VD6 Application we use mdb shared Files which are placed on a Server
Share and are opend simultaniously by about 5 Users, usally Read only. We
use DAO 3.51.  Erverything worked fine for years, but now, since we
installed some Service Packs (VB6 SP5), accessing the mdb Files ...

I am trying to connect to our Access databases on our LAN
and WAN but the Jet Engine is not connecting. All
permissions have been properly set.
The Microsoft Jet database engine cannot open the