Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Sharing a database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lorcan Dene - 23 Jan 2008 00:09 GMT
I've searched this forum, but cant find an answer, so im hoping someone can
help.

I work in a small office, we have 3 computers and an additonal server all
networked together (with cables). We have recently come across some software
to make our job easier, its in the form of an Access database. This piece of
software is designed to be opened and edited on multiple computers at the
same time, yet i cant get it to function as such.

It appears that all 3 computers can access the same database (i.e. modify
the same data), but not at the same time (like it was designed to). I'm
actually getting the error message " the database is already open as
adminstrator by [user] on [computer]"

The design of the database is password protected, so i cant change any
settings. I 've seen the database run on multiple computers in other offices,
but no one can expalin to me how.

Im hoping someone, can shed some light on this annoying problem.

Thanks in advance.

p.s. running xp and access 2003, if that helps.
Larry Daugherty - 23 Jan 2008 08:32 GMT
For best results, the application should be split into a BackEnd (just
the tables) and a FrontEnd (everything but the tables).  The BackEnd
should be placed in a shared folder on the Server and a copy of the
FrontEnd should be placed on each user's desktop.

You might contact one of the other offices where you've seen the
application run and ask how they have it deployed.

HTH
Signature

-Larry-
--

> I've searched this forum, but cant find an answer, so im hoping someone can
> help.
[quoted text clipped - 19 lines]
>
> p.s. running xp and access 2003, if that helps.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.