I currently have a database that is being used by a handful of users. The
database Back End is located on the Network while the front end is on the
users' individual computers. The problem is that a couple of the users are
connected to the Network through a VPN, which results in the database running
very slowly. Is there anyway to put a copy of the front end and back end on
the user's computer and then when they click a button or automatically at a
certain time of day the Back end on their computer will sync with the back
end on the network by adding any new files the other back end has to each
one? I don't know if this is possible or how complicated it would be, but we
need to speed up the process somehow.

Thanks,
--
Thorson

I haven't heard of either of those, I am new to this. I will look into both
those options. If you also know of any good sites about replication that
would be great. Thank you so much!
--
Thorson


"Dale_Fye via AccessMonster.com" wrote:

> Have you looked into replication?
>
> Another method would be to use Terminal Server to put a front end accessable
> to your VPN users on one of the servers. Check out this thread (
> http://www.accessmonster.com/Uwe/For...al-with-access
> ) and the hyperlink Albert has on his response
>
> HTH
> Dale
>
> Thorson wrote:
> >I currently have a database that is being used by a handful of users. The
> >database Back End is located on the Network while the front end is on the
> >users' individual computers. The problem is that a couple of the users are
> >connected to the Network through a VPN, which results in the database running
> >very slowly. Is there anyway to put a copy of the front end and back end on
> >the user's computer and then when they click a button or automatically at a
> >certain time of day the Back end on their computer will sync with the back
> >end on the network by adding any new files the other back end has to each
> >one? I don't know if this is possible or how complicated it would be, but we
> >need to speed up the process somehow.
> >
> >Thanks,
>
> --
> HTH
>
> Dale Fye
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200907/1
>
>

After reading the link you put in we are already set up on a Terminal Server,
the problem is that one user's connection to the nextwork/server is really
slow (due to internet speeds etc.) and there is no way for him to get a
faster connection. Also the database is already split.
--
Thorson


"Dale_Fye via AccessMonster.com" wrote:

> Have you looked into replication?
>
> Another method would be to use Terminal Server to put a front end accessable
> to your VPN users on one of the servers. Check out this thread (
> http://www.accessmonster.com/Uwe/For...al-with-access
> ) and the hyperlink Albert has on his response
>
> HTH
> Dale
>
> Thorson wrote:
> >I currently have a database that is being used by a handful of users. The
> >database Back End is located on the Network while the front end is on the
> >users' individual computers. The problem is that a couple of the users are
> >connected to the Network through a VPN, which results in the database running
> >very slowly. Is there anyway to put a copy of the front end and back end on
> >the user's computer and then when they click a button or automatically at a
> >certain time of day the Back end on their computer will sync with the back
> >end on the network by adding any new files the other back end has to each
> >one? I don't know if this is possible or how complicated it would be, but we
> >need to speed up the process somehow.
> >
> >Thanks,
>
> --
> HTH
>
> Dale Fye
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200907/1
>
>

Replication is a rather advanced subject, AFIAK. Search some boards for an
MVP named David Fenton... this subject seems to be his specialty and I've
read enough posts from him to believe that he may know more about replication
than anyone else. His website links to a Jet Replication Wiki with all sorts
of information regarding the subject. In any case, using replication
properly seems to be a very intricate task.

http://www.dfenton.com/DFA/Replicati...itle=Main_Page


--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"Thorson" wrote:

> After reading the link you put in we are already set up on a Terminal Server,
> the problem is that one user's connection to the nextwork/server is really
> slow (due to internet speeds etc.) and there is no way for him to get a
> faster connection. Also the database is already split.
> --
> Thorson
>
>
> "Dale_Fye via AccessMonster.com" wrote:
>
> > Have you looked into replication?
> >
> > Another method would be to use Terminal Server to put a front end accessable
> > to your VPN users on one of the servers. Check out this thread (
> > http://www.accessmonster.com/Uwe/For...al-with-access
> > ) and the hyperlink Albert has on his response
> >
> > HTH
> > Dale
> >
> > Thorson wrote:
> > >I currently have a database that is being used by a handful of users. The
> > >database Back End is located on the Network while the front end is on the
> > >users' individual computers. The problem is that a couple of the users are
> > >connected to the Network through a VPN, which results in the database running
> > >very slowly. Is there anyway to put a copy of the front end and back end on
> > >the user's computer and then when they click a button or automatically at a
> > >certain time of day the Back end on their computer will sync with the back
> > >end on the network by adding any new files the other back end has to each
> > >one? I don't know if this is possible or how complicated it would be, but we
> > >need to speed up the process somehow.
> > >
> > >Thanks,
> >
> > --
> > HTH
> >
> > Dale Fye
> >
> > Message posted via AccessMonster.com
> > http://www.accessmonster.com/Uwe/For...dules/200907/1
> >
> >

Thorson <(E-Mail Removed)> wrote:

>After reading the link you put in we are already set up on a Terminal Server,
>the problem is that one user's connection to the nextwork/server is really
>slow (due to internet speeds etc.) and there is no way for him to get a
>faster connection.

I've used Terminal Server via 28.8 dialup at motels and such. While
it was sluggish it did work. And TS is optimized for slow speeds.
Hmm, maybe there are some TS client settings that are set for high
speed access rather than slow speed access. Check the Experiences
tab on the RDP software settings and ensure they've got the
appropriate speed checked off.

Where is his copy of the front end located? On his local PC or via
the network somewhere?

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

I recently switched to ACCESS 2007 earlier this year. I was talking with a
co-worker about the possibility of Jet Replication and he suggested instead
to go internet based. I know in ACCESS 2003 the Administrator/designer could
create DAP, which from my understanding are web-based. I have never worked
with DAP, I only had a brief training on them. Is this web-based or a
similar thing available in ACCESS 2007? How well does it work?

Thanks
--
Thorson


"Dale_Fye via AccessMonster.com" wrote:

> Have you looked into replication?
>
> Another method would be to use Terminal Server to put a front end accessable
> to your VPN users on one of the servers. Check out this thread (
> http://www.accessmonster.com/Uwe/For...al-with-access
> ) and the hyperlink Albert has on his response
>
> HTH
> Dale
>
> Thorson wrote:
> >I currently have a database that is being used by a handful of users. The
> >database Back End is located on the Network while the front end is on the
> >users' individual computers. The problem is that a couple of the users are
> >connected to the Network through a VPN, which results in the database running
> >very slowly. Is there anyway to put a copy of the front end and back end on
> >the user's computer and then when they click a button or automatically at a
> >certain time of day the Back end on their computer will sync with the back
> >end on the network by adding any new files the other back end has to each
> >one? I don't know if this is possible or how complicated it would be, but we
> >need to speed up the process somehow.
> >
> >Thanks,
>
> --
> HTH
>
> Dale Fye
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200907/1
>
>

Thorson <(E-Mail Removed)> wrote:

>I recently switched to ACCESS 2007 earlier this year. I was talking with a
>co-worker about the possibility of Jet Replication and he suggested instead
>to go internet based. I know in ACCESS 2003 the Administrator/designer could
>create DAP, which from my understanding are web-based. I have never worked
>with DAP, I only had a brief training on them. Is this web-based or a
>similar thing available in ACCESS 2007? How well does it work?

DAPs have long been deprecated. I'd suggest looking for alternatives.

Now can you get your coworker to be a bit more specific about getting
Internet based? There are all kinds of methods out there but very
few involve using Access and will take lots of time and money.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

My coworker suggested DAP to possibly speed up record entry into the
database, however my coworker knows even less about ACCESS than I do, and as
we now know DAP is no longer available in Access 2007l.

We don't want to spend a lot of time or money. I think Replication is
probably the best solution for us. I am researching and reading up on
replication, but as someone said it appears to be a complicated process. We
may decide to hire someone to help us out or design that part.

--
Thorson


"Tony Toews [MVP]" wrote:

> Thorson <(E-Mail Removed)> wrote:
>
> >I recently switched to ACCESS 2007 earlier this year. I was talking with a
> >co-worker about the possibility of Jet Replication and he suggested instead
> >to go internet based. I know in ACCESS 2003 the Administrator/designer could
> >create DAP, which from my understanding are web-based. I have never worked
> >with DAP, I only had a brief training on them. Is this web-based or a
> >similar thing available in ACCESS 2007? How well does it work?
>
> DAPs have long been deprecated. I'd suggest looking for alternatives.
>
> Now can you get your coworker to be a bit more specific about getting
> Internet based? There are all kinds of methods out there but very
> few involve using Access and will take lots of time and money.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> Granite Fleet Manager http://www.granitefleet.com/
>

<shudder>
I am in the unfortunate position of supporting a bunch (about a dozen)
of Access97 databases created by the infamous "Bad Contractor".

She built all of her applications as unsplit and just put shortcuts on
all the user's workstation desktops. Over time I've been able to
split the ones with the heaviest user load into FE/BE.

I have a couple of ... "problem children" who never respond when I
announce a new version of the front end, so I can put it on their
computers, and insist on using the front end located on the network.
Because of the environment around here, I am unable to change this.
So, predictably (almost like clockwork), I have to repair corrupted
Access applications. In fact, I had to do it just yesterday. One of
the users *willfully* (though maybe not maliciously) bypassed my
hand-rolled security. Heh ... then proceeded to delete my security
measures and fuxored the application.

I love Access. It's my "go-to" tool for much of what I do but, if
it's not set up properly (check this out:
http://www.mvps.org/access/tencommandments.htm)
you WILL regret it.

My tuppence 'orth,
RD



On Wed, 29 Jul 2009 18:56:30 GMT, "JimBurke via AccessMonster.com"
<u49905@uwe> wrote:

>Why is this a bad idea? Just curious. Guess I'm showing my ignorance of how
>Access works - sorry for the bad advice! It seems that any app running on a
>server can potentially have many users.
>
>Dale_Fye wrote:
>>Bad idea Jim.
>>
>>It is NEVER a good idea to have multiple users using the same front end! Now,
>>if you mean give each user a copy of the front end on the server, and use
>>Terminal Server, then I'm in agreement.
>>
>>Dale
>>
>>>Is there a reason why each user needs a separate copy of the front end? It
>>>sounds like they're all using the same back end. If your back end is already
>>[quoted text clipped - 14 lines]
>>>>
>>>>Thanks,
>>

"Dale_Fye via AccessMonster.com" <u43991@uwe> wrote:

>Another option might be to use SharePoint lists, if you have access to MOSS
>2007.

Now there's an idea if your data isn't overly complex and doesn't
require relational integrity.

I think Albert Kallal has stated that you can use Microsoft Office
Live sharepoint site for free. But I sure could be mistaken.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/