Why Access 2002 hangs in Windows 98/me

  • Thread starter Thread starter Vic Spainhower
  • Start date Start date
V

Vic Spainhower

Well I've managed to re-create the problem in a small database with 2
unbound forms. The problem is created by opening an external database but I
don't know how to fix it. The following code demonstrates the problem on 2
different laptop computers. One is running Windows 98 and the other is
running Windows ME. It doesn't fail on XP or Windows 2K machines. The
external database does exist in the current path.

Dim strDBname As String
Dim db As DAO.Database
Dim rs As DAO.Recordset

strDBname = CurrentProject.Path & "\dbRegistration.mdb"
MsgBox "** FAILS HERE*** About to open database " & strDBname
Set db = DBEngine.Workspaces(0).OpenDatabase(strDBname)

This sure appears to be a bug in Access 2002 but it certainly seems strange
that it appears noone else is having this problem! I would appreciate it if
someone could test this or if you'd like I can email the test database to
you. I haven't tried ADO yet but I will be doing that. The database where
the problem exists has a lot of DAO and I would like to see if I can get a
solution without converting everything to ADO.


Vic
 
You sample code looks ok. Does it compile ok before you try and run it?

Are you sure you have a DAO 3.6 reference set in your references?
 
Albert,

Thanks for the reply! Yes it compiles ok and the reference is set to DAO
3.6.

Vic
 
Back
Top