Run time error on multi-server setup

[Wyoming User]

I'm in a state office which has an Access database with
replicas on two servers in two different cities. The
database file is now about 20 mb. When opening the
database in my location, I receive a run time error which
states that there is not enough memory to perform the
operation (going from switchboard form to data form). I
can't open the replica here or master or replica in the
other location from here without getting the error. The
debug button just goes to the VB that sets focus on the
next form.

However, the database can successfully be opened by a
person in the other city on their server. Is this an
Access problem or a server problem? Are there any
settings which should be adjusted?

My IT guy and my Access wizard both say it's not their
problem! Would appreciate any recommendations.

 

[Eric Butts [MSFT]]

Hi,

Sounds like it maybe related to the workstation you are running from. Does
it work fine if you are at another workstation? If so, compare the
versions of the Microsoft JET Database Engine see the file "MsJET40.dll"
for details, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "Wyoming User" <[email protected]>
| Sender: "Wyoming User" <[email protected]>
| Subject: Run time error on multi-server setup
| Date: Thu, 20 May 2004 14:13:46 -0700
| Lines: 18
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQ+r1ZMqSVFIXKbTVGU5KgFUeFZxA==
| Newsgroups: microsoft.public.access.setupconfig
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.setupconfig:30144
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.setupconfig
|
| I'm in a state office which has an Access database with
| replicas on two servers in two different cities. The
| database file is now about 20 mb. When opening the
| database in my location, I receive a run time error which
| states that there is not enough memory to perform the
| operation (going from switchboard form to data form). I
| can't open the replica here or master or replica in the
| other location from here without getting the error. The
| debug button just goes to the VB that sets focus on the
| next form.
|
| However, the database can successfully be opened by a
| person in the other city on their server. Is this an
| Access problem or a server problem? Are there any
| settings which should be adjusted?
|
| My IT guy and my Access wizard both say it's not their
| problem! Would appreciate any recommendations.
|