Thanks for all the responses. I knew I shouldn't have even mentioned the
Access DB, as it has caused confusion. Here's how the Access DB would work:
The .mdb file would reside on the server. The database would be run on the
users' desktop machine (Windows). It's no different than having an .html or
.doc file on the server and using the local web browser or word processor to
open it.
When I mentioned migrating to SQL, I didn't mean so much as an upgrade, more
that when they outgrow their home-made Access system, they would implement a
more enhanced system which uses SQL on the backend. So basically, forget
about the Access part....we'll just call it a file server.
I have used RH and Mandrake, but none of the others. RH9 looked very
similar to Windows XP and I think it's that kind of comfort that the client
wants to help them become aquainted with a new system.
----- Original Message -----
From: "Smitty" <a.smitty@verizon.net>
To: <flalug@nks.net>
Sent: Thursday, March 18, 2004 10:18 AM
Subject: [newletters] Re: [flalug] OS recommendation
> On Wednesday 17 March 2004 22:05, Steve Steiner wrote:
> > I have a client that wants a file server to hold files, of course, but
also
> > an access database (migrating eventually to SQL).
> O.K. so they need to run ms access, which is a proprietary db programming
tool
> for ms operating systems. I am not clear on what you mean by migrating
> eventually to SQL. Access uses a ms version of sql.
> > Only the .mdb will be
> > resident on the server, mind you, so don't freak out about it being
Access.
> >
> > Anyway, they are pretty non-technical, so they will need something that
> > will just work once it's been configured and up and running. Also, it
will
> > need to be easy to learn basic stuff (like add/remove users, modify
share
> > priveleges, etc.)
> There is dbRadar and CodeBase which have similar function on unix-type
systems
> and dbs to what access does on ms. If all you need is an admin tool after
> you have migrated from access, you could use Rekall with mysql,
postgresql,
> xbase and db2.
> >
> > I was thinking RH9. Any other suggestions?
> RH9 is a flavor of linux. If you need to run ms apps on top of linux,
your
> best bet would be Xandros Business Desktop.
> Smitty
>
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 20:17:34 EDT