Re: MULTIPLE ACCESS DATABASE BACK-ENDS ON THE SERVER - VIRTUAL MULTIUSER

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It think the system will work well. He can run procedures to place the data
from the different databases into common tables and running reports or form
views from them.



"ljubo l via AccessMonster.com" <u4833@uwe> wrote in message
news:58d84497d0830@xxxxxx
> I need an opinion about the following situation:
>
> - There is a compay which has very good administered LAN (20 nodes)
with
> a very strong server.
> There is a need within a company that 10 to 12 persons can
> simultaniously access the server and run the
> separate ACCESS acountiong software.When I say separate it means
that
> there wlill be up to 20 separate
> ACCESS database data back-ends on the server.That means there are
no
> multi user problems because each
> user work with a separate database.In fact, each of these
databases
> on the server represent one retail shop belonging to
> the company. A chief accounting officer of the company can
perform
> an action "FORM The Company database"
> which means that all the financial data from the separate
databases
> are collected and imported into the
> central "Company" database .That will be done in the way that all
the
> crucial tables from the separate databases will
> be linked to the central database.
> Having in mind as follows:
> - Each retail shop can be handled separatly
> - None of the sepaate database will exced 500 MB and
the
> "Company database" will not exced 2 MB
> - For the chief accountiong officer it is quite good to
see
> the "Company as the whole" once a day
> (By actually forming the database by collecting the
data
> from the separate databases)
> - No time to migrate to the SQL server
>
> I think it is good solution BUT
>
> I NEED THE OTHER PEOPLES OPINION about this solution!!
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200512/1


.

Relevant Pages

  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)
  • 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... the server. ... MSDE either from the Setup or from the SQL2KDeskSP3 execute. ... it does look like some of the sample databases have been ... >> and they directed me to install MSDE and they attached a ConfigSamples ...
    (microsoft.public.sqlserver.msde)
  • RE: Server Explorer & Databases
    ... As for the visual studio's database server explorer, ... oracle, visual studio generally use the OLD DB provider which is for Oracle ... and support of most general funcctionalitis in latest version of Oracle. ... #Server Explorer for Oracle Databases ...
    (microsoft.public.vsnet.ide)
  • Re: 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... The fact that the other databases exists phyiscally doesn´t mean that they ... can try to connect to SQL Server using OSL or a GUI. ... The Command OSQL ist for the commandline under DOS. ... > this MSDE either from the Setup or from the SQL2KDeskSP3 execute. ...
    (microsoft.public.sqlserver.msde)
  • Re: Seperate Databases and Business Logic.. SQL vs. .NET code?? Design Ideas/Differences
    ... Say a particular shop has a few critical SQL Databases that are not ... it's been stated that we will not server link. ... and reporting and online can accept day- ...
    (microsoft.public.dotnet.framework.aspnet)