Share AccessXp report

[Giorgio Sardo]

Is it possible to open a database with Access XP and modify some report
whitout having the exclusive use? I mean..sharing the database with other
users, can I modify a report inside it?

(It seems that Access97 allowed to open a db from a host while in another pc
an host was changing the properties of a report; this operation seems to be
not possible with AccessXP)

Any ideas?


Thanks

Giorgio Sardo

 

[Nick Coe \(UK\)]

From Access 2000 onwards it is not possible to share objects
in design mode. As soon as any object is opened in design
view the database is exclusively locked.
The closest you can get to design sharing is to use Visual
Source Safe or to have seperate copies of the database.

Also be aware that if you open vba code whilst an
application is running the chances of corrupting it increase
dramatically.

See Allen Browne's article on preventing corruption:

http://members.iinet.net.au/~allenbrowne/ser-25.html