Access 2002 to 2003 problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wrote a multi-user application in 2002. The database is split into a back
and front ened. I then upgraded to 2003. I ran the application just like any
normal user would, which means that I didn't make any code changes.

A user still using 2002 opened the database and receives the error
"Undefined function...", which a few users have asked about in news group.
Users who have upgraded to 2003 do not get this message.

So, the question is - If I haven't changed anything, and haven't converted
the database to 2003, so why is it picking up the errors? Has Access done
something behind my back?

Thanks, Christine
 
It could be that you have an issue with a Reference. Press Ctrl-G, then
select Tools|References...while you are in the database on a PC with the
problem. Then note any reference that indicates MISSING. If you're
distributing your database with anything other than the default references
(Access, VBA, and DAO), you need to make a proper installer. Or determine if
the extra reference is even needed (and remove it, if not). Or use late
binding (i.e., CreateObject/GetObject instead of a reference)
 
So, the question is - If I haven't changed anything, and haven't converted
the database to 2003, so why is it picking up the errors? Has Access done
something behind my back?
Click to expand...

It is possible it has. Allowing different versions of code to run with
different users not a great programming practice at all..and you are just
asking for trouble.

If the file just has data..then no problems..but with an actual application
with code etc does not take well to being run with different versions.

I would do a compact, and repair. I would then make sure the code compiles.
And, if you continue to have different versions of ms-access opening the
file, then I would split the database, as this ensure the problem goes away.
If you split, then you can share the application with access97, access 2000,
access2002 and access 2003 ALL AT THE SAME TIME!!!!

you can read up on splitting here:

http://www.granite.ab.ca/access/splitapp.htm
 
Paul and Albert - Sorry for the delay; just wanted to say thanks for
responding to my query. The database was split, there were no errors when
compact and repair was run, nor were any references missing. Fortunately, our
MIS department upgraded everyone to 2003 and the problem went away!
 
Back
Top