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

Sabtu, 15 Oktober 2011

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

What's the difference in behaviour when a "silent" save is done on a split database versus an unsplit one?
Giorgio

--- 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
>