BruceFrey
Registered User.
- Local time
- Today, 03:14
- Joined
- Dec 12, 2002
- Messages
- 20
I am a teacher in a public school system and have developed an Access database that is used in 3 different schools in our city for after school programs. Everything started out good as all the schools had Access 97 which I developed it in. However, in the last several months several of the schools have switched some of their machines to Access XP (2002). Generally I’ve been able to deal with the problem of different versions within each school using the database but today I reached my wits end in trying to get my database to work correctly on both 97 and XP.
The problem started when I created a new form which is called out in my switchboard. 97 recognized the form but XP didn’t. To troubleshoot the problem I converted the database to XP format and tested it with XP. That worked fine but my problem now was to get it to work with 97. To do this I converted the database back to 97 format. (This technique allows me to keep it in 97 format but still open it in XP. ) To my dismay, when I tried to open with 97 I got a compile error “can’t find project or library” message with the screen opening up to a page that resembles scroll showing the code behind the scenes.
I tried and tried but since I don’t know VBA, I’m at a loss for what to do. My goal would be to get the database to work with 97 and XP with both recognizing the new form (object) that I created and call out on the switchboard.
The problem started when I created a new form which is called out in my switchboard. 97 recognized the form but XP didn’t. To troubleshoot the problem I converted the database to XP format and tested it with XP. That worked fine but my problem now was to get it to work with 97. To do this I converted the database back to 97 format. (This technique allows me to keep it in 97 format but still open it in XP. ) To my dismay, when I tried to open with 97 I got a compile error “can’t find project or library” message with the screen opening up to a page that resembles scroll showing the code behind the scenes.
I tried and tried but since I don’t know VBA, I’m at a loss for what to do. My goal would be to get the database to work with 97 and XP with both recognizing the new form (object) that I created and call out on the switchboard.
