VB Forum / Database Access / September 2004

Hi all, the code below report an error when rst.update.
The DB is MySQL and mID (idmessaggio) is the PK bigint unsigned and
auto_increment.
The error says that is impossible to find the row to update, but the

I have multiple users trying to access and update a table of a database
This code gets the current Job Number from a Table and increments, updates
and returns the value.
but then two or more users are using the application I get this error:

I am using VB 6 with an ODBC Connection to a FP 6.0 DB.
I have the following code but get an 80004005:Query-based update failed
because the row to update could not be found. error.
Public Function GetNewJobNo() As Integer

I use VB6+ADO 2.8+ACCESS MDB file
Lets say I have RS1 and RS2.
I used RS1.Open and found the record I need.
Now I want RS2 (an empty recordset) to have the result from RS1 (a single

I am using VB.Net 2003, and struggling to find a way to specify which
workgroup file to use when trying to make a connection to an Access (v2003)
database. Do you have to specify this in the ConnectionString property or
somewhere else? If so, how?

How do I find the maximum value for a field in a database in Visual Basic
6.0?  I am looking for the equivalent of the DMAX function in MS Access.
Thanks,

Can anyone help me with ADO (Command version 2.5), SQL Server 2000 and
Unicode chinese characters?
It seem my Stored Procedure is getting the wrong data from my VB (version 6)
COM object. Does VB Send a string in Unicode format to a stored procedure or

I am evaluating what is the best replacement for the DAO method seek.
I have code like this: (DAO)
Set rcsProducts = dbSalesInfo.OpenRecordset("Products")
rcsProducts.LockEdits = False

I am working on a legacy application using an Access97 database. We are
migrating this to use linked tables connected to a MySQLDatabase. It's
working well (I'm pleasantly surprised at how well!) ... except.
The person that wrote this relied heavily on bound controls. A form has a

What is the difference between these connection strings?
   1) DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=db2.MDB;DefaultDir=C:\SUFFY'~1\SUFFYA~1\V20~1.0\Test;UID=;PWD=;
   2) Provider = Microsoft.jet.OLEDB.4.0;Data Source =

i want to create a printer object at run time, set its paper size, and
orientation and then after i have used it, it will be deleted. the problem
is i do not know what to do.
i tried

Application with code that is below working fine on windows XP but it
doesn't work on
windows 98.
Does anybody know why??

I need some help I'm not much of a database programmer and the guy that
originally set this up is no longer with the company...
The way things are set up is we have a box running Outlook logged on as a
domain account that parses email messages into an Access database. This

I'm not sure what may causing the error, but all of my Database project made
in ADO is giving error. It's saying that "Object variable or with block
variable not set".
Previously before installing .NET and updating Jet database engine, all the

I am getting a timeout error reported from an ASP.NET app on IIS on my
devlopment machine when I try to read data from a seperate SQL Server (not on
the same machine, but same network).
CONFIGURATION: