VB Forum / Database Access / June 2005

Kind of a repost of an old post:
I have built a VB app that interacts with an MSAccess97 database
via DAO. The app basically goes through a specified folder and saves
a bunch of file info to the database. My question is this:

Here's the issue:
There's an app that doesnt know if its database will be SQL, or ACCESS or
even what versions. ( It's coded to interact at a high level, but needs to
avoid compatibility issues from Microsoft).

Im trying to open a Report with Docmd.OpenReport and im specifying a WHERE
statment, like this:
   sReport = "[Resortes].[Acero] = Forms![FormName]![ComboBox]"
   DoCmd.OpenReport "ReportName", acViewNormal, , sReport

When an ocx/dll file is registered (using regsvr32.exe) it occupies a
registry address which is always unique for that ocx/dll. I mean if we
re-register another copy of the same ocx/dll from any other folder it
will be registered at the same registry address.

Hi, I'm developing an application in vb6 and sql server 2000. It will be used
by several users at the same time, therefore I'm using a timestamp column
(rowversion) to detect if a row has been edited by someone before saving any
changes. If it has, then I tell the user someone ...

Hello --
I need to use the CASE structure in a query to make some calculations, so I
can't use a SQL2000 View.  I think I can handle the coding of the query.
Being a newbie to VB6 I don't know what combination of techniques to use to

I am trying to finish an HNC Computing which involves VB6 and I have ran
into a problem with a form that I had to produce, I have copied the code
straight from  one of the tutorials but I cant get it to run. Here is the
first part of the code:

I'm getting the following error when I execute an UPDATE method:
------------
Run Time Error =80004005
Key column information is insufficient or incorrect. Too many rows were

I have a database in Access 2003 (Access2000 file format).  There are
two tables that are being used: Employees and Items.  It is linked by
the Employee field so that one employee can have many items.
I have a VB6 application that is tied into this database using an

I am trying to add a record to a field in Access which is picked from a
combobox (cboOther1). How do I call out the combobox text in the code
shown below? I am using VB6.
Set VS = DB.OpenRecordset("Tithes")

How to Create Password in MDB File while running application , I create
MDB via ADOX Library but I don't know Coding to insert User ID and Password.
I hope anybody that can help me.
Best Regards

I receive the following error from an ADO open connection statement:
The 'VFPOLEDB.1' provider is not registered on the local machine.
Where do I find this driver(what is it called)? And making an assumption
that it may not be on the local machine where do I get it?

I have a vb application that is used by a variety of clients (xp and win2k)
that connect via ADO to a MS Access 2000 db on a network directory.
Once a client has successfuly completed a transaction, the other clients
suffer serious speed problems when recovering information from ...

Please Help me...I have Personel Tabel in MyDatabase when I used ADODB
connection with SELECT * AS nMount FROM Personel WHERE City LIKE 'MED*'
I didn't have anything in recordset but if I used DAO 3.6 Object
Library,it could do .

I have a VB6 app linked to a Access db which was working fine. However I had
to do a format of my hard drive and a reinstall. Now the startup form of the
app does not work. My error handler gives the following message
Authentication failed -2147217843