Re: Pricing

Great, yep I understand the FE/BE thing, that is clear to me.

I guess my last question to you or any one would be:

If a client was to purchase a Ms Access Database FE (User Face, Forms,
Reports, etc) and a BE on (let's say) SQL Server, how would that developer
get that whole application to the client?
ANSWER:

Example: Would that BE/SQL be on there SQL Server (they consistanly maintain -
via extra money contract) or would that BE/SQL reside on the client?
ANSWER:

If it was to reside on the client side, who would maintain the BE/SQL? Who
would update the front end (ms access) on each desktop.
ANSWER:

Would it be possible to deploy a MS ACCESS FE/BE - SQL Server via zip email?
Silly question, but I am trying to understand how this scenerio above would
work?

I realize the USA must be different, but there has to be common denominators
to this process (MS Access FE & SQL BE).........


Terry Kreft wrote:
Let's get what appears to be a misunderstnding out the way. When people
talk about a FE/BE setup in here they are normally talking about a FE
consisting of the forms, reports, queries in an Access database and a BE
which consists of the tables also in an Access database. The BE is then
frequently linked to the FE.

The main advantage of this system is that in a properly analysed well
designed db application the database schema should be pretty static. The
forms, reports and queries are much more likely to change than the database
schema but because a FE/BE setup is used it is easy to replace the FE witout
affecting te BE.

The BE can of course be any data source.

Most of your questions are how long is piece of string questions, the answer
to most of them is it depends.

The price I quoted was or a split database as described above, but that was
an absolute minimum. I wouldn't be surprised to see it two or three times
that amount.

You've got to remember that I'm working in the UK where Acces is not as
popular a development tool as it is in the US. I normally come across
Access apps that someone has started but been unable to finish. I then end
up redeveloping the system. Most of the work I o nowadays is VB/SQL.

Using Access as the front end to SQL server is a very good choice.

Terry,

[quoted text clipped - 69 lines]
Nothing fancy, I realize the prices can be scattered, but generally a GOOD
FAITH ESTIMATE what seems to be the normal price for a developer to charge?

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: SqlDataAdapter and existing DataSet
    ... private static string GetColumnNames{ ... > The method will go through every table in the dataset, and having> designed it in a way so the corresponding table on the SQL Server> roughly has the same schema as the one found in the Access database. ... The client makes> sure the correct records are sent, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ASP SITE with SQL Server--best way to backup?
    ... Your hands may or may not be tied by the hosting provider. ... Having it in an MS Access database is one great way to provide ... access to the data to a non technical client - at least it's better than ... alternative SQL Server in order to see the data). ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASP SITE with SQL Server--best way to backup?
    ... Your hands may or may not be tied by the hosting provider. ... Having it in an MS Access database is one great way to provide ... access to the data to a non technical client - at least it's better than ... alternative SQL Server in order to see the data). ...
    (microsoft.public.dotnet.framework.aspnet)
  • SqlDataAdapter and existing DataSet
    ... a client computer (Microsoft Access database) and a central server ... designed it in a way so the corresponding table on the SQL Server ... roughly has the same schema as the one found in the Access database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: designing for several many-many relationships
    ... is a small Access database ... I'm designing a db to store client personal and business information, ... A client consists of a set of parents and children. ...
    (microsoft.public.access.tablesdbdesign)