Splitted Database

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

Guest

Hi Anyone!

I have a database (Access). It's located on the network. Both Back end &
Front end are located on the same location. And I also have a copy of the
database on my desktop. My question is: if I am going to modify the front end
on my local database (on the desktop) then copy the Front end to replace the
Front end on the server ? is it going work? Please advise. Thanks

Ngan
 
the only thing on your desktop is a link to your db which
is stored on your local drive.
what are you modifying. if it is just a form or report,you
can just put the form or report to the server front end.
you can push the entire db but this would cause disruption
with the table links to the back end and all would have to
be relinked.
 
It depends on how your front end is linked to the back-end. If it's linked
using a UNC (\\server\share\folder\file.mdb) rather than a mapped drive
(G:\folder\file.mdb), or if you can be sure that everyone's PC will be
mapped the same way, then yes, it should work without any issue. (of course,
no one can have the existing network front end database open when you try to
replace it)

However, be advised that your users really shouldn't be sharing the same
front end off the network: it's a leading cause of database corruption.
Instead, each user should have his/her own copy of the front end on their
workstation. If you're concerned about ensuring that each user has the most
up-to-date version of the front end, check what Tony Toews has (for free) at
http://www.granite.ab.ca/access/autofe.htm
 
Thanks

[email protected] said:
the only thing on your desktop is a link to your db which
is stored on your local drive.
what are you modifying. if it is just a form or report,you
can just put the form or report to the server front end.
you can push the entire db but this would cause disruption
with the table links to the back end and all would have to
be relinked.
Click to expand...
 
Thanks

Douglas J. Steele said:
It depends on how your front end is linked to the back-end. If it's linked
using a UNC (\\server\share\folder\file.mdb) rather than a mapped drive
(G:\folder\file.mdb), or if you can be sure that everyone's PC will be
mapped the same way, then yes, it should work without any issue. (of course,
no one can have the existing network front end database open when you try to
replace it)

However, be advised that your users really shouldn't be sharing the same
front end off the network: it's a leading cause of database corruption.
Instead, each user should have his/her own copy of the front end on their
workstation. If you're concerned about ensuring that each user has the most
up-to-date version of the front end, check what Tony Toews has (for free) at
http://www.granite.ab.ca/access/autofe.htm
Click to expand...
 
Back
Top