VB Forum / Database Access / December 2005

I save picture files to an Access DataBase by converting them to byte arrays
then saving as a binary field.  The database is getting quite large.  What is
my limit and will the large size slow down my application when accessing the
database.

Have a big ASCII text file of one char
field (code)
that contains a dump of all SAS code from
IBM machine.

Anybody tell me whats the error here?
My Access database resides in the same machine Of   App.(VB6)
1.On deleting a record from inside a
    con.begintrans  --Con.committrans

Have a very Merry Christmas everyone.
Jim Y

When trying to add a user to a group I get the following error when calling
this method dbGroup.Users.Append(dbUser).
Invalid Operation
FYI: Using DAO 3.6

Hello, i am creating a system where i add, amend and delete data from my
database. i have been looking at vb6 and ado and dao. i have been told to go
for ado objects such as recordsets and connection. (adodb).
I have used VBA before and have managed to create a system using it. I ...

I'm trying to use the SQL Server 2000 Service Procedures to detach and attach
a database. The code works great and actually does do the detach and attach
again. However, when it does each command, it returns an Error 13 - Type
Mismatch. I've been ignoring the error because (like ...

Context: using vb6, ado/adox 2.8, writing to .mdb format, Jet 4.0 Provider
(no Access), win2k
Objective: create a table with Sql statement, then confirm that operation
worked

Hi, i want to connect my database to vb6, and using vb6 to manupulate the
database. i found the following code that shows how to use adodb to show some
data from the database. can anyone pls explain what the main lines of codes
are doing. and what is ADODB? also, why does this ...

I have an issue where I stepped on the mdac of a Windows 2003 Server SP1
running MDAC 2.8 SP2.  I want to reinstall the correct version of MDAC to
fix the problem, but can't find it any place for download. The error I get
when trying to open a connection to a SQL Server using ADO ...

I am writing a program in vb6 to move a database and its log file from one
directory to another using sp_attach_db and sp_detach_db.
I used 'sp_detach_db mydb' to detach the database, moved it to the new
directory location and then tried to attach the database using the command:

Hi i have a program that was created in Visual Studio 6 Pro, which links to
an access 97 Dahe database! everytime i try to access the database from the
program i get the following error
ADODC1

I have a recordset which is basically returning say 10 columns (fields) and
20 rows.
At one point I want to return a recordset with only 2 columns (fields) and
all the rows it fetched.

I have a recordset say which has 20 fileds and 20 rows.
I want to get my final recordset with only 2 fields and 20 rows..
how can I restrict the fields or filter out the rest fields...
thansk

I have a program (written in VB6) running in a Win2000 server with SQL
server 2000 in it. However, the program runs very slow or even "Time Out
Expired" many times. My connection string is:
strConn = "Provider=SQLOLEDB;Data Source=myServer;Initial Catalog=myDB;User