(USE A COPY OF THE DATABASE)
Split the front end from the back end (All forms Queries reports etc = front
end Tables = Back end) There is a wizard to do this it will link the tables
to the queries, forms and reports part.
Once you have done that, copy the front end to the 2003 users. (Each will
have his own front end)
Open a copy of the front end in Access 2007, convert that copy front end to
2007, copy and distribute a copy of that to all the 2007 users (Each will
have a 2007 copy on their computers)
Now you have many front end users both in access 2003 and 2007 which all
address the same tables and hence the same data.
There are pitfalls to entering data in seperate front ends. If two people
enter a new record at the same time, things like sequence numbers or record
numbers can cause problems but there are ways around that to a degree.
