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 / Multiuser / Networking / July 2006

Tip: Looking for answers? Try searching our database.

Newbie: 2 MDB multiuser application

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
General Fear - 15 Jul 2006 22:53 GMT
I need to create a multi user application. I want to split the MDB into
two. At the user's C Drive will be the front end. On the server will be
the back end database.

I want to do this application in ADO.

Is there a web page or book that shows how to do this?
Larry Linson - 16 Jul 2006 23:03 GMT
> I need to create a multi user application.
> I want to split the MDB into two. At the
> user's C Drive will be the front end. On
> the server will be the back end database.

This is the recommended approach, linking the tables in the back end
(tables, relationships, and data) from the front end (queries, forms,
reports, macros, and modules)

> I want to do this application in ADO.

This request really doesn't make sense... you don't "do Access applications
in ADO." ADO (ActiveX Data Objects) and DAO (Data Access Objects) are two
methods for doing I/O from Visual Basic for Applications (VBA) code to the
Tables in the database. But, very often, little or no access from VBA code
is needed, because you "bind" Forms and Reports to the database by
specifying a RecordSource. And, in any case, DAO is the "native language" of
the default Jet database engine, and is most probably a better choice for
any VBA access to the data that is required.

> Is there a web page or book that shows how to do this?

There's good information in various pages of http://www.mvps.org/access,
and at MVP Tony Toew's website http://www.granite.ab.ca/accsmstr.htm, and at
MVP Jeff Conrad's website
http://home.bendbroadband.com/conradsystems/accessjunkie.html. None of these
are "tutorials."

The "enterprise edition" of _Microsoft Access <version> Developer's
Handbook_, by Litwin, Getz, et al, published by Sybex, has good information
on multiuser Access applications as well as Access client-server. It is
intended for Intermediate to Advanced developers. An introductory PowerPoint
presentation that I did, some time ago, for my user group is posted at
http://appdevissues.tripod.com (if the site is still active).

 Larry Linson
 Microsoft Access MVP
 
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



©2008 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.