Converting from Access 2000 to 2003 1

[JoPaBC]

Hello,

I have troubles to run/convert MS Access database 2000 in 2003 version; after opening in 2003 I am getting error massage "Visual Basic module contains a syntax error"
I tried to fix some lines with errors like these:

- Dim db As Database, td As TableDef, rs As Recordset (replaced with Object)
- X = fgOpenAllForms() (removed)
- X = fgCloseAllForms() (removed)
- MsgBox Error$
- For I% = 0 To 13
- X$ = "txt" & Chr$(I% + 65)

but had no much success. What references should be added/removed to make it work?
Thx

 

[dhookom]

I would first try to uncheck the utility.mda in the references. Then compile your VBA. Then use more explicit code like:

Dim db As DAO.Database, td As DAO.TableDef, rs As DAO.Recordset

I would probably get rid of all the "$". These are a holdover from a long time ago.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[JoPaBC]

Your solution worked - I unchecked the utility.mda in the references and used explicit code as you suggested.
Thank you!