ACCESS FEED: RE: [MS_AccessPros] Re: Any recommendations on sharing a dbase?

Bill-

See my later reply. When using Citrix, it's probably better to split the
database and provide each user with their own copy of the front end in different
folders. When the user logs in, they open "their" copy.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Saturday, October 15, 2011 7:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Any recommendations on sharing a dbase?

John

That doesn't make sense to my poor little brain. Sure you can open multiple
instances of a database on one machine just like you can have multiple users
share a front end on a server. Each one has has his own instance, but you're all
working with the same objects. Corruption is a fact of life in sharing that way.

How is Citrix different here?

Bill

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Bill-
>
> But it's not absolutely necessary to split because all copies of the
application
> are runnng on the same machine. It's like opening mutliple Access sessions
one
> one machine. It probably is a good idea anyway to split because of all the
> "silent" saves Access does to open forms that the user filters.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Saturday, October 15, 2011 3:56 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Re: Any recommendations on sharing a dbase?
>
> Giorgio
>
>
>
> The same thing happens when the DB is split. There is still only one locking
> file. First one to save wins. The next one to save gets a choice to keep or
> discard the changes.
>
>
>
> Splitting is done not to isolate data changes but to prevent corruption of the
> forms, reports and system tables.
>
>
>
> Regards,
>
> Bill
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of giorgio_rovelli
> Sent: Friday, October 14, 2011 3:47 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Any recommendations on sharing a dbase?
>
>
>
>
>
> So in this case if you don't split the db, what happens when two people try to
> edit the same record?
> Giorgio
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "John Viescas" <john@>
> wrote:
> >
> > No.
> >
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
> giorgio_rovelli
> > Sent: Friday, October 14, 2011 8:51 PM
> > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: [MS_AccessPros] Re: Any recommendations on sharing a dbase?
> >
> > Thanks John, is there still the requirement to split the database?
> > Giorgio
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "John Viescas" <john@>
> wrote:
> > >
> > > Giorgio-
> > >
> > > The entire app runs on the server. The Texas and Colorado folks sign in to
> > the
> > > server to start a virtual session and run the app. All that gets
transmitted
> > is
> > > the screen refreshes, and the app is OK if the connection breaks.
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out
> > > Microsoft Office Access 2007 Inside Out
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
> giorgio_rovelli
> > > Sent: Thursday, October 13, 2011 7:34 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > Subject: [MS_AccessPros] Re: Any recommendations on sharing a dbase?
> > >
> > > Hi John, what would the layout be in this case if Citrix is used? Frontend
> on
> > > the Texas pc harddisk and backend on the Citrix server, both backend and
> > > frontend on the Citrix server?
> > > Giorgio
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "John Viescas" <john@>
> wrote:
> > > >
> > > > Tiffany-
> > > >
> > > > If there is a way to connect via a company WLan or VPN connection, one
of
> > the
> > > > best options other than a web database is to set up a Citrix server in
> Utah
> > to
> > > > allow users to log in and run your database on the server.
> > > >
> > > > John Viescas, author
> > > > Microsoft Office Access 2010 Inside Out
> > > > Microsoft Office Access 2007 Inside Out
> > > > Building Microsoft Access Applications
> > > > Microsoft Office Access 2003 Inside Out
> > > > SQL Queries for Mere Mortals
> > > > http://www.viescas.com/
> > > > (Paris, France)
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> > > > Sent: Wednesday, October 12, 2011 11:22 PM
> > > > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > Subject: [MS_AccessPros] Re: Any recommendations on sharing a dbase?
> > > >
> > > > Tiffany
> > > >
> > > > Do you have a company-wide network, or are all the offices unconnected?
> > > > Somewhere along the way you'll have to have a way to connect. Either
that
> or
> > > > (ugh!) send excel sheets back and forth.
> > > >
> > > > Regards,
> > > > Bill Mosca, Founder - MS_Access_Professionals
> > > > http://www.thatlldoit.com
> > > > Microsoft Office Access MVP
> > > > https://mvp.support.microsoft.com/profile/Bill.Mosca
> > > >
> > > >
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "cc0623" <cc0623@> wrote:
> > > > >
> > > > > Our houston & Denver offices need to be able to add data to my Dbase
in
> > > Utah.
> > > > Other than a web dbase is there any other options?
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Tiffany
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

------------------------------------

Yahoo! Groups Links