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

Exactly.

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

John -
That's what I thought. But somehow I didn't get that from you saying about
everyone using the same copy. Now I see you were talking about th esame copy of
Access, right?

Bill

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>

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

Yahoo! Groups Links