VB Forum / Database Access / March 2007

Is it possible to check programaticaly if MDB database is encrypted?
Thanks in advance.
Paulo

I'm using VB6/ADO with SQL to query an Access database.  I'm trying to
find all records with a text field called 'Comment1' that is empty.
I've tried 4 x double-quotes within the normal double-quotes: -
 "SELECT * FROM [OPC Tasks Due]" _

i want to select between 100th and 200th records on a table.
is there any sql statement for that like TOP statement.
I know TOP statement returns absultely (or percently when use TOP
PERCENT) top records. But i need between 100th and 200th records or other.

i want to select between 100th and 200th records on a table.
is there any sql statement for that like TOP statement.
I know TOP statement returns absultely (or percently when use TOP
PERCENT) top records. But i need between 100th and 200th records or other.

I am quite new with VB6. I just wondered, does anybody have any ideas how a
knowledge management system can be implemented using databases in vb6?
Any help is appreciated. Thank u

I'm trying to do a gap analysis of our ODBC  provider driver.  It's
hard to establish from the MS docs when certain properties must be
supported.
For example, PageSize,

I am definitely a newbie concerning Access 2003 and Visual Basic but until
now I was able to write by small tools etc.
I had a working sample last week but after my Storage Profile has been
renewed my VB procedures crash when I call

I have a large legacy Access 2002 database that connects to a SQL
Server backend. As it stands, it connects fine. But, we're trying to
upgrade to SQL Server 2005.
We actually have tables from three different SQL Server databases as

I am trying to retrieve User information when he is submitting the form in
vb.net. The variable is a string and it is:
Requester = System.Web.HttpContext.Current.User.Identity.Name. It returns
the domain/login info in the local .net environment but it does not return

I am trying to execute a stored procedure  for use into a datareport,
but i getting the error of above.
When i open the connection  of the DE(dataenviroment), the stored
procedure produce the error and show no field fron the SP(stored

I have created a VBA application in PowerPoint that concludes with a
comma-delimited text string as output. I would like to place an ADO or
DAO or other
command after that point that appends the data into an Access table.

please let me know  how can i transfer data from a RTF file to Sql
Server table through VB.Net coding..
thanks
regards/Shabih

I posted a question before and it really helped me to progress in my
project. Now I'm stuck again :( but this time it is a much simpler issue than
before. I have a total of 4 drop downs which are interconnected with each
other. Each drop down is connected with a datasource which ...

this is my problem:
I have an unbound form; through this form I want to write data to a
table called "Project".
The next code is attached to the button "Save data":

can someone suggest a better implementation that my sqlescaptestr function
below?
unfortunately this function throws an outofmemoryexception when i am
inserting multiple rows in a loop (str in such cases can be quite large...