getting multiple users accessing same data without closing access

[Guest]

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

 

[Guest]

You need to split the database:

Tools > Database Utilities > Database Splitter

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*[email protected]
Manchester, UK
(I have no access to other sites apart from microsoft.com so posting
external links is no use to me)

 

[Guest]

Thanx Adam helped greatly

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*[email protected]
Manchester, UK
(I have no access to other sites apart from microsoft.com so posting
external links is no use to me)