Re: FN-FORUM: Access V Excel

date posted 28th June 2007 12:55

I don't see why Access needs to be installed on the server to give
multi-access use. Access 97 and Access 2000 didn't. I assume that Access
2003 and the latest one are at least as good in this respect.

I can't recommend using Excel. Go for Access of better still one of:
MSSQL Express, DB2 Express, Oracle Express, Postgres, Firebird, mySQL (my
order of preference).

Surely your provider should be giving you at least one of the above?


----- Original Message -----
From: "PuntersPower" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, June 28, 2007 10:52 AM
Subject: FN-FORUM: Access V Excel

> Does any have a preference for Access over Excel and main reasons why?

Access is a database system with some rudimentary SQL. Excel is a
spreadsheet. Use a database for storing data, it's bound to be better that
this kind of thing. That's what it was designed for. I sometimes use Excel
when I'm entering data because I like the way you can immediately see
everything and sort it but I would import it into a DBMS before trying to
use it on a website.

> I've recently built a supplier DB in Access using Access Project Backend
> MSSQL for sharing reasons, the only problem is only one person at a time
> can access Access for writing data, which is the main reason I didn't want
> to use Excel.

I don't understand that. It's not my experience.

> To have multi user write priv on Access would it have to be installed on
> the server?

No.

> Andrew
>
> PS. Anyone know of a really good advanced Access training course in the
> Midlands?

No. But I like that O'Reilly book by Steve Roman: Access Database Design and
Programming.
>
> PSS. Does anyone know how to retrieve deleted emails from outlook?