Paradox11 on MS Server 2000 w/Mac desktop

Hi Tom,

How's the Paradox church app going? Is it still up and running?

Hi Mike,

It's been 3 years since I updated you on my project here at First Prez.  Lots of changes.  My efforts are called "FirstAssist" which is a custom Paradox 11 app running on a terminal server and an SBS 2003.  Tables are on the SBS and "First Assist" runs on the the terminal server. 

The church shares the TS and the SBS 2003 with a co-located, church-owned company with about 6 users.  The church also has about 10 users, but only 4 are very active.  Church users are running RDP (latest MS version) on their Macintosh desktops to access FirstAssist.  The other company users are PC-based with mapped server drives and some applications running on the TS.

With this many users on the TS, I have seen an increasing delay/latency for church users which is very frustrating.  I have asked our consultant to upgrade the TS RAM from 2 to 4Gb to help the delay and latency problem. 

In the meantime, I have tried various BDE settings in an attempt to "fine-tune" FirstAssist.  Here's the current settings.  If you see something amiss with these settings, please let me know.  Appreciate your support and the new web site is awesome.

Net Dir  \\TerminalServer\CSNET

Version: 4.0

Type: File

LangDriver: Paradox 'intl'

Block Size: 2048

Fill Factor: 95

Level: 7

StricktIntegrity: True

System/INIT

Auto ODBC: False

Data Repository BLANK

Default Driver: Paradox

LANGDriver: Paradox 'intl'

Local Share: FALSE

Low Memory Useage Limit: 32

MaxBufSize: 12800

MaxFileHandles: 75

MEMSIZE:  32

MINBUFSIZE: 128

MTS POOLING: TRUE

SHAREDMEMLOCATION: BLANK

SHAREDMEMSIZE: BLANK

SQLQRYMODE: BLANK

SYSFLAGS:  8

VERSION: 4

Hi Mike,

Thanks for the interest.  The project continues to grow and mature as I learn more and as other office users migrate from FileMaker and Excel.  I'm currently working on various sub-group programs such as Women's Ministry, Men's Ministry, Youth, Singles, Small Groups, etc.  The pattern for each sub-group is pretty much the same, but there are a few challenges. 

We moved the church last August and installed a Windows Server 2003 and Terminal Server on a new network.  The terminal server is running the application and the Server 2003 handles the tables and queries.

 We were first inclined to change out the macs for pc's, but not now.   We're using Paradox11 Runtime on the Terminal Server and it works just fine.  Because our Paradox application runs only on the TS, we have no need to upgrade the operating system until Microsoft stops supporting it.  The mac terminals use Remote Desktop Connection to access the Terminal Server.  Works great. 

I also developed a separate Paradox application for our worship director who has to arrange the music for each Sunday service.  It's almost finished.   It uses a muti-tab form and several tables.  The master table contains all music titles with associated info and the other two tables are 1:many (dates played) and themes)

 This has been a tremendous learning experience for me, but most of all, it has turned into a true ministry. 

Again, thanks for your interest.

Aloha,

 Tom Howes

Tom: That's great. It's nice to hear a good success story. Feel free to post any questions you have.

Just curious, do you get paid for this or are you doing this as a favor to the church?

Hi Mike,

 I'm strictly a volunteer.  Retired now from Air Force and industry.  This project keeps me thinking.

 Tom

Tom,

It was so refreshing to find there are others out there that use Paradox for church record keeping.  However, it has never occurred to me to use it in the music program.  Thank you for the idea.

Ruby Yarter

Hi Ruby,

Yes, I built it about 3 years ago and it now catalogs and archives worship music since 1996.  Included are various search functions.  If you are interested, I'd be glad to share the app.  Tell me about your church and how Paradox is working for you.

Aloha,

Tom Howes

Hi Tom;

Thank you for asking about how Paradox is used in our church.  About seven years ago I developed a small database for member records.  It was then and now is very simple as we have secretarial employees that use it.  We live in an area of mostly retired persons therefore a part time secretarial position is usually not hard to fill however that generation is not always adapted to computers as they might be.

We have a need to have church membership records available for genealogy research.  So our database contains all persons who have ever been a member as well as current membership and a contact person for them which seems to be helpful for researcher.

Our membership is about 120, not large and a single computer user.

I also have also used Paradox at work for about ten years.  My firm collects and disburses Property Owners Association Assessments for over 10,000 properties in a resort community.

I am self educated in Paradox but the things I have developed and presently use really wowrk well for me and my company.  I would very much appreciate your sharing your app.  My Assistant at work is also the pianist for our church and she was very excited about your comments.

Thank you again for your interest.

Ruby Yarter

Hi Ruby,

Let me have your email and I'll be glad to share the Music app with you.  It's developed in Paradox 11.  Hope that's not a problem.  Anyway, you could always redo it for your version of Paradox.

Aloha,

Tom

Hi Tom,

 We work in version 9, hsbmfund@tstar.net

Thanks, if we have questions, could you help?

Ruby