Will my program run?

[Carl]

I am an amateur. I bought some books and made a VB4 program using an Access
97 MDB database and MS DataGrid which gets data from the MDB. I use the
program more than any other because it keeps family medical records.

The program served me well thru Win 95, 98, 98SE and ME. Also an automatic
convert to VB6 along the way. I had Office 97 Pro and used Access 97 to
examine my MDB database, make changes if necessary, and compact the MDB
occasionally.

Then I bought a new computer with XP. I installed my program and it seems to
work OK.

I also installed Office 03 Pro, which has a new version of Access. Access 03
will open my MDB so I can read it but not alter it. Access 03 offers to
convert my MDB so it can be altered, but I am wary of doing that. I have now
forgotten most of what I knew about VB programming and don't want problems
that I cannot solve.

If I convert the MDB database, will my existing program still access it OK?
This is the sub that I use to connect to the database.
--------------------------
Public Sub SetConn(AdoCon As Adodc)
'Set Adodc connection string
With AdoCon
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51; " _
& "Data Source=C:\Program Files\Medical Record
Keeper\MedRec.mdb; " _
& "Persist Security Info=False"
.CommandType = adCmdText
.Visible = False
.BOFAction = adDoMoveFirst
.EOFAction = adDoMoveLast
End With
End Sub

 

[Douglas J. Steele]

The connection string you're using won't work with Access 2000 or higher. If
you do convert (and realistically there's no reason to), you'll have to
change it to

..ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=C:\Program Files\Medical RecordKeeper\MedRec.mdb; " _
& "Persist Security Info=False"

 

[Tony Toews]

I am an amateur. I bought some books and made a VB4 program using an Access
97 MDB database and MS DataGrid which gets data from the MDB. I use the
program more than any other because it keeps family medical records.

The program served me well thru Win 95, 98, 98SE and ME. Also an automatic
convert to VB6 along the way. I had Office 97 Pro and used Access 97 to
examine my MDB database, make changes if necessary, and compact the MDB
occasionally.

Then I bought a new computer with XP. I installed my program and it seems to
work OK.

I also installed Office 03 Pro, which has a new version of Access. Access 03
will open my MDB so I can read it but not alter it. Access 03 offers to
convert my MDB so it can be altered, but I am wary of doing that. I have now
forgotten most of what I knew about VB programming and don't want problems
that I cannot solve.

If I convert the MDB database, will my existing program still access it OK?

No, it won't. Unless you change the references from Jet 3.4 to Jet
4.0. Or is it DAO 3.6? I can't recall exactly.

PRB: Error "Unrecognized Database Format" When You Upgrade to Access
2000 or 2002:
http://support.microsoft.com/?kbid=238401

HOWTO: Modify the Visual Data Manager (VISDATA) to Work with Access
2000 Databases:
http://support.microsoft.com/?kbid=252438

FIX: Unrecognized Database Format Error with Data Control or Data Form
Wizard:
http://support.microsoft.com/?kbid=257780

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm