Can't overwrite Access frontend

N

NCRga

I have a strange situation. A co-worker has created a split database in
Access 2003. Recently he made changes to the front-end and emailed the new
version out to the users requesting them to replace their old version with
this new version. All went well execpt for 2 users that are not in this
building. These 2 users have deleted all references to the old version, but
everytime they copy the new version to their computer and open it, it opens
up the old version! One of the users even tried to open the newer version
from a copy on a server and it still opened the old version. We can't figure
this out...can anybody help????
 
N

NCRga

I just learned that this front-end was created in Access 97. Access 97 users
can open the newer version of the front-end with no problem. It is the Access
2003 users that are having problems. In the past we have always been able to
create in 97 and open it in 2003 with no problems...even multiple versions of
the same interface. But in this case, Access 2003 is only wanting to open the
first version created in Access 97. Any updates to the front-end are not
visible to 2003 users. I hope I haven't made this too complicated to
understand. We are beside ourselves trying to figure this out.
 
D

Douglas J Steele

Why not convert a copy of the new Access 97 front-end to Access 2003, and
let the Access 2003 users try to open that?
 
N

NCRga

Thanks, but we were trying to keep from having to keep multiples of the same
interface. This is version 6...we hadn't had this problem before.

UPDATE: Just found the problem. There is a macro that is named "autoexec"
that opens up a specific form automatically when the database is opened. I
told the developer to delete that macro and re-create it. My thought was that
somehow the macro was opening the old version of that form (which is really
weird since that version of the form was deleted in the database). He just
came and told me it worked! Evidently the developer copied the form, made
changes and then replaced the old form with this new form. I have never seen
this before and I have been developing in Access for about 10 years! But it
appears the old form remained in memory and that macro was opening the OLD
FORM. I'll have to remember that!
 
Top