Re: Does my client need SBS ?

It would be easier to use Access to make a front-end for a SQL
database. The users can roll their own, without adding another level
of programming/admin/costs.

Our users write custom queries and reports that draw from a live
production SQL database. Most users use a read-only SQL account so as
not to damage the data. I also use Crystal Reports for generating some
reports.

Also, you could keep the database in Access, with multiple users, and
pass on the SQL server.

In either case, using a database or simple Excel spread*** is far
better than a Word file.

Regards,
Alan Leghart

SuperGumby [SBS MVP] wrote:
SQL Server is quite probably overkill for a mailing list database, the free
MSDE could quite probably be used to good effect. Also, someone will have to
write some form of 'front end' to the database.

The front end could be web based (using either SQL or MSDE) and such a
system would be quite easy to write and maintain, for someone familiar with
such (ie. not me).

More commonly my clients would maintain such a list in Excel, Word itself,
or Outlook. I can imagine they would continue to use their word doc, stored
on the server.

"Colin" <colin@xxxxxxxx> wrote in message
news:6BZNg.53266$a9.36237@xxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Guys,

I am trying to convince one of my clients that they need SBS 2003. They
currently have a peer to peer network, a mixture of XP Home and Pro PC's,
2 different workgroups, no backups, a mixture of different anti virus apps
on the workstations, users chatting away on Messenger, etc...a real mess.
I showed them the SBS PowerPoint presentation from the MS SBS site and
they seem impressed but I need to put together a document detailing what
improvements will be 'visible' to them. I've pointed out the obvious
(centralized file sharing, regular backups, shared fax, remote working,
file/folder security etc) but the 1 main thing they are questioning me
about is the SQL Server part of SBS Premium. They want to know if they can
all access a mailing list database (which is currently simply a Word
document that they then mail merge) and all have the ability to ammend it.
SQL is something I've never touched so here I am again asking for your
advice. Can this be done natively with SBS/SQL or do I need a third paryty
app? You might have guessed that price is a concern here but if I get a
green light on this from you guys on this simple (?) matter, I can
convince them to part with their cash. Many thanks for any help you can
give me on this.

Regards Colin.


.

Loading