VB Forum / Database Access / September 2008

I have taken over a VB6 project and making some minor modifications.
The VB program connects to an Access 2000 database through DAO and a
data control.  I am getting this "Can't find Installable ISAM" error
when the form loads.

I use an Access DB to store data for my app and to stop people messing I've
changed the ext of the db to .cyp and my installer changes the icon of .cyp
to an icon of my choosing.
Problem is when my app connects to the db, an .ldb file is created alongside

I have a db with a string field "dwgname"
as many records will share a common value i'm considering "normalizing" that
field to it's own table
then instead of the string "dwgname" I'll store the foreign key of the

I have
Working
.Find "Feild1 = '" & Var1 & "'"
What i need to do is

Please redirect me if there's a better location for general architectural
issues re: object oriented design
vb6 and ado (or sqlite)
I have a couple vb6 objects

"SELECT imageguid,imagedevname,id,imagedevname FROM images WHERE
STRCOMP(imagedevname='" & SQLExpr(Trim(sTitle)) & "',0)=0")
SQLExpr is just a function that wraps apostrophes.
When sTitle is 'a', but there is only 'A' as an "imagedevname" then my

sHello, everyone
My question is: How or what do I have to set for ODBC driver to open only
one session?
I'm working in Visual C++ with ODBC driver.  The problem is that for each

when i try to sign in i get an internal message of 102/1001 what can i
do about this

We have a large number of db systems using VFP which we would like to
convert.
We know we want SQL server backends, but our question is is it easier to do
front-end work in VB.net or in another dbms like MS Access?

I want to save the Picture object into a Long Binary (OLE Object) field in a
mdb database without using the data control. Could not find any direction
searching the web.
Anyone knows an example?

Hi there I need assistance on how to connect to a Miscrosoft Access Database
which is stored on an online server through VB
Can anyone help.
Regards

When the user clicks a button on my not-data-bound control, he will
insert, delete or update an Access MDB table within VB6.
I need to implement an Undo function. The changes that are related to
these insert, delete or update events are so very "big" that I cannot

what 's the difference between Package and Deployement?

I have 2 questions:
1. Can I can remove the primary key from a table by code (and if yes, how)
2. I have a SQL command that will create a table with a primary key:
"CREATE TABLE cells (ID  COUNTER  NOT NULL CONSTRAINT   id   PRIMARY KEY

I've developed a Window app using VB .Net 2005 with an Access 2003 database
for the back. It works if run on one computer.  When I load teh app on a
shared server and try to run it from a remote client the app boots up, but
when ever it tries to connect to the database the ...