VB Forum / Database Access / February 2005

Could someone tell me how to reset a date field to blank or null in an sccess
database using VB 6.0 and dao 3.6?
Thank you
H.T.

pardon my ignorance, I am new with this programming.
using a .mdb file is there a way to tell Visual Basic that the .mdb file is
on a ftp page?
Like this?

I am a database consultant in need of developing an application in VB in
order to access the API in a leading data modeling application. I require VB
(com) expertise in accessing and manipulating data from the data modeling
application, and then packaging it for commercial resale ...

I have a report I have to generate where the higher ups are being
anal...I'm sure you know what I mean.
I have a field in the report that contains a numeric character of
anywhere from 1 to 5 numbers.  The higher ups would like it to read

When I type in the following  for a defines recordset and database
For i = 1 to 10
    Debug.print i , rs1.fields(i).type
Next i

I have developed a program in VB and my database with the SQL Server. I
installed it on client's machine with no problems, but when I try to run it I
get the following error message. "ActiveX component can't create object". Can
some please help me solve this problem. I have ...

I have a function to search for a value in a specific field, but I need to
search every fields, like we can do in Access.
How can I search for something in all the fields of a table?
The code I have now is:

I opened Access database through Connection String (
"Provider=MSDATASHAPE;Data Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Data\pubs.mdb" ) successfully.
But now i protect the pubs.mdb with password=123456 (From Access tools)

When I try to connect to an SQL Server developer edition database using
server explore I get the following message:
Unable to connect to database.  It is only possible to connect to SQL Server
Desktop Engine databases ..with this version of Visual Studio

I occasionally get an error when I execute a SQL command:
"Could not update. Currently locked."    
Apparently, this happens when the previous command has not yet
completed.  This is happening with an UPDATE statement.  The statement

I have been trying to connect to an .mdb file protected by a password
created using Access 2003.
I fond some information on Microsoft DAO Database:
The connect argument is expressed in two parts: the database type, followed

I have a VB app which opens a database with the following code snippet:
(Please don't jump all over me about this -- I didn't write it! <g>)
It works on many computers on our network.  But on ONE computer, it only
works if you are logged in with admin privileges.  If you are not, ...

This is the error I get, now, when I try to connect to an access database. I
have not done any updates other than Windows Critical updates and I have
XPHome SP1, with VB6 SP6 installed. Everything was fine up until about a week
ago.

I have a SQL DTS that i am trying to run in a visual basic 6 executable.  It
needs to run on a machine that does not have SQL installed.  Is this
possible?  I am getting a message that says "Active X Component can't create
object" when it tries to run.  I have added ...

I am building a desktop application that needs to connect to an Access
database online.
Can someone tell me what is the prefered way of doing this? I have found a
couple of alternatives but I do not know which is the best one.