Shared access to database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Jeff Boyce said:
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").
Click to expand...

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

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

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]
 
Back
Top