Database for church records

[TS]

I hope someone here can help me.

We are currently looking at redeveloping the membership database for out
church. It is mainly usd to hold details of our members, produce reports
etc.

I am investigating both mysql and MS Access. Ultimately I would like the
front end to be browser based, both for querying and entering data.

Are there basic membership databases that can be downloaded from the web
from which to base this project?

Which platform (Access/Myqsl) would be the better bet and why?

Thanks in advance

[John]

Re: Database for church records


Hi,

Try doing a search on http://sourceforge.net/ for "church". There are
quite a number of projects you might find interesting.

For membership management and a lot more using PHP and MySql, check this
one out:

http://www.infocentral.org/

Regards,
John


TS wrote:[color=blue]
> I hope someone here can help me.
>
> We are currently looking at redeveloping the membership database for out
> church. It is mainly usd to hold details of our members, produce reports
> etc.
>
> I am investigating both mysql and MS Access. Ultimately I would like the
> front end to be browser based, both for querying and entering data.
>
> Are there basic membership databases that can be downloaded from the web
> from which to base this project?
>
> Which platform (Access/Myqsl) would be the better bet and why?
>
> Thanks in advance
>
>[/color]

[John]

Re: Database for church records


Hi,

Try doing a search on http://sourceforge.net/ for "church". There are
quite a number of projects you might find interesting.

For membership management and a lot more using PHP and MySql, check this
one out:

http://www.infocentral.org/

Regards,
John


TS wrote:[color=blue]
> I hope someone here can help me.
>
> We are currently looking at redeveloping the membership database for out
> church. It is mainly usd to hold details of our members, produce reports
> etc.
>
> I am investigating both mysql and MS Access. Ultimately I would like the
> front end to be browser based, both for querying and entering data.
>
> Are there basic membership databases that can be downloaded from the web
> from which to base this project?
>
> Which platform (Access/Myqsl) would be the better bet and why?
>
> Thanks in advance
>
>[/color]

[Irvin Amoraal]

Re: Database for church records

TS,
In my humble opinion, either db would be satisfactory. I use both from time
to time. If you are creating a desktop application, which I suspect, then
I'd lean towards Access. the database can be split into a front end back
end, allowing multiple users to view the same backend data.

Irvin Amoraal <><
_______________

"TS" <tspill@talk21. com> wrote in message
news:3fd0a55d$0 $2666$65c69314@ mercury.nildram .net...[color=blue]
>
> I hope someone here can help me.
>
> We are currently looking at redeveloping the membership database for out
> church. It is mainly usd to hold details of our members, produce reports
> etc.
>
> I am investigating both mysql and MS Access. Ultimately I would like the
> front end to be browser based, both for querying and entering data.
>
> Are there basic membership databases that can be downloaded from the web
> from which to base this project?
>
> Which platform (Access/Myqsl) would be the better bet and why?
>
> Thanks in advance
>
>[/color]

[Irvin Amoraal]

Re: Database for church records

TS,
In my humble opinion, either db would be satisfactory. I use both from time
to time. If you are creating a desktop application, which I suspect, then
I'd lean towards Access. the database can be split into a front end back
end, allowing multiple users to view the same backend data.

Irvin Amoraal <><
_______________

"TS" <tspill@talk21. com> wrote in message
news:3fd0a55d$0 $2666$65c69314@ mercury.nildram .net...[color=blue]
>
> I hope someone here can help me.
>
> We are currently looking at redeveloping the membership database for out
> church. It is mainly usd to hold details of our members, produce reports
> etc.
>
> I am investigating both mysql and MS Access. Ultimately I would like the
> front end to be browser based, both for querying and entering data.
>
> Are there basic membership databases that can be downloaded from the web
> from which to base this project?
>
> Which platform (Access/Myqsl) would be the better bet and why?
>
> Thanks in advance
>
>[/color]

[Irvin Amoraal]

Re: Database for church records

I guess I didn't read ALL of your question. You state that you want this to
be browser based. With that being the case, what kind of server will you be
using, NT or Linux? Will you be using ASP, PHP?
Irvin Amoraal. <><
_______________ _


"TS" <tspill@talk21. com> wrote in message
news:3fd0a55d$0 $2666$65c69314@ mercury.nildram .net...[color=blue]
>
> I hope someone here can help me.
>
> We are currently looking at redeveloping the membership database for out
> church. It is mainly usd to hold details of our members, produce reports
> etc.
>
> I am investigating both mysql and MS Access. Ultimately I would like the
> front end to be browser based, both for querying and entering data.
>
> Are there basic membership databases that can be downloaded from the web
> from which to base this project?
>
> Which platform (Access/Myqsl) would be the better bet and why?
>
> Thanks in advance
>
>[/color]

[Irvin Amoraal]

Re: Database for church records

I guess I didn't read ALL of your question. You state that you want this to
be browser based. With that being the case, what kind of server will you be
using, NT or Linux? Will you be using ASP, PHP?
Irvin Amoraal. <><
_______________ _


"TS" <tspill@talk21. com> wrote in message
news:3fd0a55d$0 $2666$65c69314@ mercury.nildram .net...[color=blue]
>
> I hope someone here can help me.
>
> We are currently looking at redeveloping the membership database for out
> church. It is mainly usd to hold details of our members, produce reports
> etc.
>
> I am investigating both mysql and MS Access. Ultimately I would like the
> front end to be browser based, both for querying and entering data.
>
> Are there basic membership databases that can be downloaded from the web
> from which to base this project?
>
> Which platform (Access/Myqsl) would be the better bet and why?
>
> Thanks in advance
>
>[/color]

[TS]

Re: Database for church records

I will be using Windows XP and PHP


"Irvin Amoraal" <irvin@rcabletv .on.com> wrote in message
news:vt50c650mi one3@corp.super news.com...[color=blue]
> I guess I didn't read ALL of your question. You state that you want this[/color]
to[color=blue]
> be browser based. With that being the case, what kind of server will you[/color]
be[color=blue]
> using, NT or Linux? Will you be using ASP, PHP?
> Irvin Amoraal. <><
> _______________ _
>[/color]

[TS]

Re: Database for church records

I will be using Windows XP and PHP


"Irvin Amoraal" <irvin@rcabletv .on.com> wrote in message
news:vt50c650mi one3@corp.super news.com...[color=blue]
> I guess I didn't read ALL of your question. You state that you want this[/color]
to[color=blue]
> be browser based. With that being the case, what kind of server will you[/color]
be[color=blue]
> using, NT or Linux? Will you be using ASP, PHP?
> Irvin Amoraal. <><
> _______________ _
>[/color]

[Irvin Amoraal]

Re: Database for church records

PHP and mySQL would probably be the way to go. There is a lot of support at
php.net. Check out their on-line documentation at
http://ca.php.net/manual/en/index.php. Here's a list of the mySQL functions
built into PHP http://ca.php.net/manual/en/ref.msql.php. If you're really
hot on MS Access, check out thier odbc functions at http://ca3.php.net/odbc.

If you find and download the mySQL odbc driver, you can set up an odbc
connection to the mySQL db, then use MS Access to create the queries for
your PHP code. Be warned though, there are some things that MS Access can do
in queries that mySQL can't, but overall, mySQL is very robust.

Enjoy!

Irvin Amoraal. <><
_______________ ____

"TS" <tspill@talk21. com> wrote in message
news:3fd35662$0 $14206$65c69314 @mercury.nildra m.net...[color=blue]
> I will be using Windows XP and PHP
>
>
> "Irvin Amoraal" <irvin@rcabletv .on.com> wrote in message
> news:vt50c650mi one3@corp.super news.com...[color=green]
> > I guess I didn't read ALL of your question. You state that you want this[/color]
> to[color=green]
> > be browser based. With that being the case, what kind of server will you[/color]
> be[color=green]
> > using, NT or Linux? Will you be using ASP, PHP?
> > Irvin Amoraal. <><
> > _______________ _
> >[/color]
>
>[/color]

[Irvin Amoraal]

Re: Database for church records

PHP and mySQL would probably be the way to go. There is a lot of support at
php.net. Check out their on-line documentation at
http://ca.php.net/manual/en/index.php. Here's a list of the mySQL functions
built into PHP http://ca.php.net/manual/en/ref.msql.php. If you're really
hot on MS Access, check out thier odbc functions at http://ca3.php.net/odbc.

If you find and download the mySQL odbc driver, you can set up an odbc
connection to the mySQL db, then use MS Access to create the queries for
your PHP code. Be warned though, there are some things that MS Access can do
in queries that mySQL can't, but overall, mySQL is very robust.

Enjoy!

Irvin Amoraal. <><
_______________ ____

"TS" <tspill@talk21. com> wrote in message
news:3fd35662$0 $14206$65c69314 @mercury.nildra m.net...[color=blue]
> I will be using Windows XP and PHP
>
>
> "Irvin Amoraal" <irvin@rcabletv .on.com> wrote in message
> news:vt50c650mi one3@corp.super news.com...[color=green]
> > I guess I didn't read ALL of your question. You state that you want this[/color]
> to[color=green]
> > be browser based. With that being the case, what kind of server will you[/color]
> be[color=green]
> > using, NT or Linux? Will you be using ASP, PHP?
> > Irvin Amoraal. <><
> > _______________ _
> >[/color]
>
>[/color]