Just some food for thought...

We have run into similar situations when running both multiuser R:Base and Access applications. In fact, our old Tech Support system (which was written in VB/Access - don't ask!) used to crash several times per day, requiring a reboot and a compact/repair of the database. This generally occurred when there were more than 3 concurrent users.

We switched our server over to Mandrake Linux 9.2 running Samba and Webmin. Since the VB client runs directly on the workstation (via shortcut to the exe on the file server), and the Access database was simply stored on the file server (accessed via UNC paths using ADO), it did not matter what OS was serving the files (so long as a Windows path was made available). Since setting up this configuration, the database has not crashed (Microsoft would be suprised!) or experienced any speed issues (nor has the server been rebooted) in over 9 months!

Soon, we will be serving up all of our R:Base apps the same way.

For those who are a little adventurous, this may be a good way to get around the Windows File Sharing Problem...

Note that Windows Longhorn is supposed to fix this problem, but since it is such a drastic departure from the existing Windows versions it may be several years before this product is stable enough to use in a mission-critical environment!


Greg Miller
Data Center Manager/Network Administrator
Event Imaging Solutions, Inc. - A Kodak Company




Joel Solomon wrote:
Thanks, I'll give it a try

----- Original Message ----- From: "James Bentley" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Friday, July 01, 2005 1:40 PM
Subject: [RBG7-L] - Re: Windows 2000 Server



Besides the *.Rb? files you may also need to exclude
*.$$$ files which are created by Rbase in response to
certain commands, and in v7.x form and report actions
where you have embeded the eep in the form or report

Jim Bentley
American Celiac Society


--- Emmitt Dove <[EMAIL PROTECTED]> wrote:


I specifically asked that our virus scanning
products leave our *.rb* files alone. Why bother scanning the database on each
access?


(I know of at least two well know order

entry/accounting packages that
publish
statements that anti-virus software must have their

file types excluded or
severe
degradation will be seen)



Thompson Technology Consultants
276 Chippewa
LaPorte, IN 46350
219-324-2605 (Phone & Fax)
219-363-7441 (Cell)
http://ttc.inc.home.comcast.net



-----Original Message-----
From:   Lawrence Lustig

[SMTP:[EMAIL PROTECTED]

Sent:   Thursday, June 30, 2005 3:23 PM
To:     RBG7-L Mailing List
Subject:        [RBG7-L] - Re: Windows 2000 Server


Seems to happen on both 2000 and 2003.  We have

tried both, currently on

2003 with XP clients and there is a clear

difference with 1 client and

more than one.

You should expect speed to about double when you go

from one to two users.  I

think the other issue is a much larger increase --

about 10 or 20 times.  Is

that what you're seeing?  If so, I have to amend my

statement about never

having heard of it happening outside of 2K server.
--
Larry

Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT  06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]




Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com



Reply via email to