Re: FN-FORUM: Access V Excel

date posted 28th June 2007 17:53

Andrew,

> desk top aaplication, why do you saying because we are using MSSQL why use
Access at all?

A lot of the responses here are assuming you are developing a web app.
MSSQL does not provide in itself any tools to provide an end user
front end; that is why you need Access (or VB.NET, ASP.NET, Visual
Studio etc. etc.) Using Access to develop a front end is perfect for a
LAN based app.

> Have I created a MSSQL db to use for nothing?

You may have been able to get away with a JET back end depending on
the exact spec., but MSSQL is a much better platform if you can afford
the extra development effort.

> can creating 1 Access DB on 1 pc be access by anyone else from their own
pc?

Yes, provided it is opened in shared mode, which is normally the
default if you are just using it rather than developing it. The advice
on splitting the front and back ends is generally good, but not often
necessary to make it work, depending on the software design.

> I thought only a MS Access project file can be opened using different
pc's on the same netwrok and the data is shared via the MSQSL DB

No. In fact project files ADP are in many ways inferior to the MDB
format IMHO, and much harder to develop complex apps with. But they
are useful as a front end to develop SQL objects if you do not have
one of the other development tools.

HTH

David Nye
http://www.dnye.co.uk
Business Data Application Design & Development.
Microsoft Access, SQL Server, ASP.NET & VB Programming.