VB Forum / Database Access / June 2004

Please say me if the size of database become big what happen itcan reduce the speed

i have one database .and i want tah tthe database is not opened or not
accesible to any user when it not run it only  give acess to the
prgramm or no hacker or caracker can broke it for sequrity reason
.what i have to do?

I have placed a list box in an excel file and when I right click to change
the properties I can not because it's not there on the floating menu and no
matter how I try to include these in the menu there is no joy.
has any one any ideas

I would like to wrap some ADO recordset properties in my own class. My
problem is: How can I use the NewEnum property on an recordset just like how
one would do it on a collection?
Thanks,

I am begineer for visual basics but have enough experience of the
programming.
This is first time i am working something with database. What i need
to do is in visual basic pro. import data from excel file and store it

Am tired of manually updating my documentation files on tables and stored
procedures so am trying to automate the process.
Have an application that via OpenSchema etc gets me the tables and columns
and column info fine.  Write out a nice formatted page for each table to a

Help... I need some assistance with this.  I normally manipulate data on a
SQL Server with ADO and stored procs.  This time I have to dump the data
from an ADO recordset, into an Microsoft Access table.  All the code is
written and I have the recordset available, but I can't figure ...

I'm trying to open an ADO recordset with the following SQL:
SELECT * FROM tbl_Article
INNER JOIN lookup_section ON tbl_article.sectionid = lookup_section.id
WHERE  Instr(1,lookup_section.SECTION,'articles')>0 ORDER BY

I tried to delete and pack two tables of visual foxpro with the following
code, 1st table records are deleted and packed successfully while 2nd table
records ar deleted but not packed, any idea please what could be the
problem,

Guys,
I am getting this stubborn error anytime I try to do
anything with my recordset: '3704' Operation is not
allowed when the object is closed.

I have to find the value of my sequence after the insert in an oracle database, I'm using ado and vb6:
     Set rs = New ADODB.Recordset
     rs.CursorType = adOpenForwardOnly
     rs.CursorLocation = adUseClient

I am using ADO from a VB program to update a table in a Generic ODBC driver.
My VB program is the following:
Private Sub Command1_Click()
   Dim conn As ADODB.Connection

I created an Access database using VisData and now want to make changes to the database.  In doing
so, I have to create another db, but want to retain the files that were saved in the original db.  I
want to increase the number of characters that are saved to the db.  Right now I ...

Could someone please tell me how to do a date comparison. I have
txtCheckDate (a text box), and cmdCheckDate (a command button). I would like
the user to enter a date in mm/dd/ccyy format, and then I would like to see
if the date entered is either => the current system date

hi i am trying to read data frm 52 worksheets the code below doesnt
wor
any ideas
Dim rst As ADODB.Recordset