2002 Project dead after opening in 2003 Beta

  • Thread starter Thread starter Brad Adams
  • Start date Start date
B

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
 
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.
Click to expand...

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.
 
Back
Top