Re: Problem converting a VB6 program to use an Access 2000 db instead of an Access 97 db
- From: "Lance Wynn" <LanceWynn@xxxxxxxxxxxxxxxx>
- Date: Wed, 14 Feb 2007 12:07:55 -0700
Why did you change your connection string, and to what?
This is the connection string I typically use for connecting to Access (Any
version) and I haven't ever had a problem.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<filepath>;Persist Security
Info=False
<maxime.rainville@xxxxxxxxx> wrote in message
news:1171477879.785450.98870@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I've an old VB6 program design to use a Access 97 database. We've
recently decided to convert the program so it would use an Access 2000
database instead.
So I converted our database to the access 2000 format, changed the
connection string, ... and of course it didn't work.
It looks like part of the program works, but it crashes when we try to
read data from a record set. Were getting this error:
Run-time error '3704'
Operation is not allowed when the object is closed.
Any ideas on what might be causing this?
.
- References:
- Problem converting a VB6 program to use an Access 2000 db instead of an Access 97 db
- From: maxime . rainville
- Problem converting a VB6 program to use an Access 2000 db instead of an Access 97 db
- Prev by Date: Problem converting a VB6 program to use an Access 2000 db instead of an Access 97 db
- Next by Date: Prepared statments still usefull??
- Previous by thread: Problem converting a VB6 program to use an Access 2000 db instead of an Access 97 db
- Next by thread: Prepared statments still usefull??
- Index(es):
Relevant Pages
|
