VB Forum / Database Access / August 2004

I'm sorry if this question has been asked before, but I did a search and
didn't find anything...
I'm getting to really hate ms.com (and pretty much all internet search
engines), but I can't blame them because there is soooo much information

I have a program I've created in Access 97 and I'm migrating it to VB 6.0. I'm
attempting to get the images that are in an external file to show up as the
database records are cycled based on the "txtBreed.text" and I'm stumped.
In Access this works:

If my "If...Then"  statement is too long, how can I break it down into
several lines for easy reading?
e.g. Break "If a=b and c=d and e=f..............................then"
into

I am trying to port a VB -Access-DAO application to a SQL Server 2K-ADO
environment.
Is there any chance to replace the DAO Seek method with a SQL-Server 2K ADO
method ? I've tried some cursorsettings but the DBengine still reports that

I am using the OleDbDataAdapter object linked to a Microsoft Access
database and during runtime when the code attepmts to update the adapter
with the code:
       oleMovieLibAdapter.Fill(dsMovieLib, "movielibrary")

I wrote a script that puts a variable into a access database when i
run my script on my computer it works fine.
When i copy ALL the files to my laptop i get an run-time error.
Does any one know if i did something wrong ? i copyd all the files

using vb6, I am connecting to an Access 97 using
set dbs = dbEngine.workspace(0).Opendatabase("c:\myDb.mdb)
All works well however the user gets a blank Access session in the
background.  Due to the nature of the app I cannot use bound controls.

I've been using ADO for years and don't remember ever seening this.  When I
open the connection (which is successful), it changes the connection string,
adding all the Jet OLEDB properties.  This causes a "Syntax error in FROM
clause." (error -2147217900) when I later try to run a ...

We use fox table as database engine (vfp2.0 - 2.6), vb as front end. The
problem we had in last a few months was the intermittent not reading a
record which was just saved. ADO works fine if program exit and restart. The
method of writing to database we try both ado or codebase but ...

After upgrading to SQL Server 2000 SP3, our VB app is encountering a really
nasty bug.
The error is:
"Key column information is insufficient or incorrect. Too many rows were

If this is a dumb question, bear in mind I am new to MDB.
A customer has approx 6 computers (win9x) connected together.  One win98
computer has some shared folders on it's C drive which everyone can access.
They call it the server and no one sits at that station.

I have a VB5 application that uses a MSJet database located on a machine in
the office. Some users would like to be able to use the application on the
road for reference. So I added a command which copies the database from the
office machine to the user's laptop. I told the users ...

I have Outlook 2000 set for Internet email and want to access my calendar
items via ADO
I have found the code below from the MS site but I get the error "MAPI
folder or Address book not found"

We are saving 100 byte to 6 mb BLOBs in a SQL Server database.
If the size reaches about 2mb I am apruptly experiencing very long delays
when calling the .Update procedure of the recordset. It does not make any
difference If we use AppendChunk or not. I also tried ADODB.Stream.

I need to write an application that takes data from a user on a Web page and
puts it into an Access DB.  I can't seem to find any examples of how to do
this.
Any simple example would be great help!