getting multiple users accessing same data without closing access

getting multiple users accessing same data without closing access

Post by ZXhpbGVkX3 » Fri, 20 Jan 2006 18:06:02


Can anyone help i have created a database to work across a network i have the
main data stored on the server and the multiple systems connect to it to get
the data the question is is there a way to get access to update the data on
the server after ssomeone has entred it and it automatically update everyones
database?

If so please help...
 
 
 

getting multiple users accessing same data without closing access

Post by QWRhbSBUaH » Fri, 20 Jan 2006 20:36:04

You need to split the database:

This creates a frontend and a backend to your database. The frontend
contains all the forms, queries, reports, macros and modules and the backend
contains all the tables. Save the backend of the database on your server
where everyone has access and the frontends on the individual users computers.
This means all your users are using the same data so any change is visible
by all real time.
--
Adam Thwaites
Access Database Designer
adam.*spamless* XXXX@XXXXX.COM
Manchester, UK
(I have no access to other sites apart from microsoft.com so posting
external links is no use to me)