Shared access to database

[JaB]

HI

I have created a database to record responses to a survey.

This database will occasionally need to be accessed and potentially updated
via a form simultaneoulsy by more than one person.

Could anyone please advise how I can give multiple write access and if there
are any potential problems regarding simultaneous enteries via the forms.

Thanks

 

[Jeff Boyce]

The standard recommendation in this newsgroup (tablesdbdesign) is to "split"
your data (tables) from your application (forms, queries, reports, macros,
code). To do this, make two copies of the combined version, then take all
the tables out of one, and everything else out of the other. Finally, open
the (non-tables) application copy and use File | Get External Data | Link...
to connect the "front-end" to the data ("back-end").

Once you have the front-end linked to the data, you would provide a copy of
that front-end file to each/every user on his/her PC.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Barry Gilbert]

The standard recommendation in this newsgroup (tablesdbdesign) is to "split"
your data (tables) from your application (forms, queries, reports, macros,
code). To do this, make two copies of the combined version, then take all
the tables out of one, and everything else out of the other. Finally, open
the (non-tables) application copy and use File | Get External Data | Link...
to connect the "front-end" to the data ("back-end").

Alternately, you can use the Database Splitter wizard (under Tools, Database
Utilities). This automates the process that Jeff recommended.

Barry

 

[John Vinson]

Could anyone please advise how I can give multiple write access and if there
are any potential problems regarding simultaneous enteries via the forms.

Access is multiuser, out of the box. You have to go to a bit of effort
to restrict it to a single user!

Do heed the suggestions about splitting the database, though.

John W. Vinson[MVP]

 

[Jeff Boyce]

Barry

Call me a dinosaur. Back in "the day", we had to split our own, none of
these new-fangled tools...<g>

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/