2002 Project dead after opening in 2003 Beta

[Brad Adams]

Hi Everyone,

I'm hoping no one else has encountered this, but maybe if someone has they
have a fix or workaround they can share.

I have an Access 2000 project file that I build in Access 2002. All of the
tables and some functions and views are on a SQL Server 2000. The project
was working fine till someone opened it in Access 2003 Beta release 2.
After that whenever I try to open a form other than the main form it dies on
me. I can still access and use the file if I open in 2003. We did notice
one difference in 2003 when we opened a record source that one of the
reports is based on and that is 2003 was able to show the query graphically
when 2002 was not (the query used a case function in the select statement).

Thanks in advance for any input or feedback.

Brad

 

[Steve Jorgensen]

Hi Everyone,

I'm hoping no one else has encountered this, but maybe if someone has they
have a fix or workaround they can share.

I have an Access 2000 project file that I build in Access 2002. All of the
tables and some functions and views are on a SQL Server 2000. The project
was working fine till someone opened it in Access 2003 Beta release 2.

Opened "it"? You have one copy of the front-end, and you let others access that
copy?

Personally, I always keep at least 2 copies of everything, the development copy
where I make modifications, and the production copy that remains unchanged while
I make/test changes in the development copy. Users have read-only access to the
central productio copy so they can make copies of it onto their computers in
order to run it.

Regarding the back-end, that gets backed up at least once a day to at least 2
other places, not on the same computer.