Share a database

[vaa571]

Hi there,
I created a database and i would like to share it with multiple users. This
database will be savade in a public drive in our network and obvious all
intendent users have access installed into their machines. Two groups wil be
using this database simultaneously, production (creating new records) and
final QC inspecting (retriving records already saved in the that table). What
will be the best way to share the database and get instant update as the user
enter new records? Do i need to create a Replica and then share it? Or keep
only one database and then allow multiple user to access it? Thanks you for
any help.

 

[Tony Toews [MVP]]

I created a database and i would like to share it with multiple users. This
database will be savade in a public drive in our network and obvious all
intendent users have access installed into their machines. Two groups wil be
using this database simultaneously, production (creating new records) and
final QC inspecting (retriving records already saved in the that table). What
will be the best way to share the database and get instant update as the user
enter new records? Do i need to create a Replica and then share it? Or keep
only one database and then allow multiple user to access it? Thanks you for
any help.

No, don't replicate if you're all on the same LAN.

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[vaa571]

Thanks Tony, i will try that later...
I mistakenly created a replica of the DATABASE, is there a way of changing
that? By clicking on the table & queries properties i was able to remove the
"replica" however i cannot do that with reports and forms, any hints on that?

Thanks Again for your help.

 

[Tony Toews [MVP]]

Thanks Tony, i will try that later...
I mistakenly created a replica of the DATABASE, is there a way of changing
that? By clicking on the table & queries properties i was able to remove the
"replica" however i cannot do that with reports and forms, any hints on that?

I think I got around that by importing the forms and reports into a
new MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

I mistakenly created a replica of the DATABASE, is there a way of
changing
that? By clicking on the table & queries properties i was able to
remove the "replica" however i cannot do that with reports and
forms, any hints on that?

See question 10 in my Jet Replication FAQ:

http://dfenton.com/DFA/Replication/index.php?title=FAQ