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

Jumat, 14 Oktober 2011

[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, "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@yahoogroups.com] On Behalf Of giorgio_rovelli
> Sent: Friday, October 14, 2011 8:51 PM
> To: MS_Access_Professionals@yahoogroups.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, "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@yahoogroups.com] On Behalf Of giorgio_rovelli
> > Sent: Thursday, October 13, 2011 7:34 PM
> > To: MS_Access_Professionals@yahoogroups.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, "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@yahoogroups.com] On Behalf Of Bill Mosca
> > > Sent: Wednesday, October 12, 2011 11:22 PM
> > > To: MS_Access_Professionals@yahoogroups.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, "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
>