Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting from Access 2000 to 2003 1

Status
Not open for further replies.

JoPaBC

Technical User
Sep 26, 2017
85
CA
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

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

Code:
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
 
Your solution worked - I unchecked the utility.mda in the references and used explicit code as you suggested.
Thank you!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top