Re: Access, OleDb, Insert or Update

Terry Olsen <tolsen64@xxxxxxxxxxx> wrote:

We have a few Access applications that IE put out for the different
locations to use. They have an MDB file in a shared directory somewhere
on the network. We get a lot of calls on those. "I keep trying to open
this file and it freezes up." They wouldn't give it time to open and
were ctr-alt-deleting it. I found it took anywhere from 5-10 minutes to
open.

This I was trying to avoid by writing a FE in VB and using OleDb
Transactions to update the file. But I understand now about breaking it
up into a BE and FE, using Access for both. Now to bone up on my Form &
VBA skills.

Ah, a WAN is a big problem. Especially a busy WAN. And you've encountered some of
the problems.. You've also been lucky in that the database didn't corruption. Your
best options are Terminal Server or SQL Server.

You might want to go back and try the OleDB etc solutions but I'm not very hopeful.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Re: Version Cant be loaded on terminal Server
    ... Your A2007 upgrade will work fine on Windows XP or Windows Vista. ... due to MS licensing issues you aren't allowed to install it ... on Windows 2003 Terminal Server. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: Version Cant be loaded on terminal Server
    ... Error message when you try to start a 2007 Office program within a ... Terminal Server client session: ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Terminal services-give a program admin rights
    ... I am running a Microsoft Access based accounting program in the ... Terminal Server sessions which require administrative rights. ... give Access admin rights without giving each user local admin priviledges? ...
    (microsoft.public.windows.server.security)
  • Re: MS Access MDE on a Terminal Server. Help please
    ... It is Access 2003 on both my local and Terminal server and all the latest SP ... MDE i have the following error. ... What version of Access is installed on the Terminal System? ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Access Run time 2003 and Access 2003 on Termianl Server (Windows Server 2003)
    ... This machine is an Terminal Server. ... you can install both on the same system. ... about the licensing requirements for Office 2003 on TS. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.devtoolkits)