access, the right choice for a new project?

Hi,
I´m asking for some general advice here. I have a project which has
been developed in Delphi up to a point where my developer split up
with me. I have to decide now wether access is suitable for my needs
as I would like to rewrite this in access - visual basic.

It is basically a database frontend for real estte agents with a
ODBC-connection to my website where property for sale may be
displayed. Pictures need to be uploaded and property data like
bedrooms and square meters and so on must be input and edited.

The finished application should be secured from source code theft and
alteration - and run as a stand alone application - access may be
neccessary though.

I´d appreciate any general thoughts from you pros out there before I
do something wrong.
Thanks
Dennis

P.S. Greetings from Tenerife / Spain - probably one of the most
beautiful islands in the world.

re: access, the right choice for a new project?

I think you will find that an ODBC connection via the Internet is unsuitable
(from a performance point of view) for accessing a database, no matter what
the front-end is. And, if your backend database is a Jet database, you can't
use ODBC from an Access front-end to access it, in any case. If
application-ODBC-Internet is the arrangement you were implementing, perhaps
it is a good thing your developer left. You really need a serverside
application, probably with a browser-based user interface, though a somewhat
richer UI _can_ be done with additional effort and expense.

Some Microsoft options would be (for simple interaction) Microsoft Front
Page 2002 or 2003 with the Database Interaction Wizard, Access 2002 Data
Access Pages (DAP) if all your users are running Internet Explorer 5.5 or
later and have the Microsoft Office Web Extensions installed, WebClasses in
VB6, "classic .asp (Active Server Pages), or ASP.NET using either VB.NET or
C#.

There are other, non-Microsoft alternatives, of course.

Larry Linson
Microsoft Access MVP

P.S. Too bad I'm not a journeyman in any of these technologies -- Tenerife
seems a place where "will work for shelter and food" might be a good deal.
<GRIN>


"Dennis Freud" <dennis@pentagonmedia.com> wrote in message
news:32bf64e2.0310210725.7624289d@posting.google.c om...[color=blue]
> Hi,
> I´m asking for some general advice here. I have a project which has
> been developed in Delphi up to a point where my developer split up
> with me. I have to decide now wether access is suitable for my needs
> as I would like to rewrite this in access - visual basic.
>
> It is basically a database frontend for real estte agents with a
> ODBC-connection to my website where property for sale may be
> displayed. Pictures need to be uploaded and property data like
> bedrooms and square meters and so on must be input and edited.
>
> The finished application should be secured from source code theft and
> alteration - and run as a stand alone application - access may be
> neccessary though.
>
> I´d appreciate any general thoughts from you pros out there before I
> do something wrong.
> Thanks
> Dennis
>
> P.S. Greetings from Tenerife / Spain - probably one of the most
> beautiful islands in the world.[/color]

re: access, the right choice for a new project?

dennis@pentagonmedia.com (Dennis Freud) wrote in
news:32bf64e2.0310210725.7624289d@posting.google.c om:
[color=blue]
> Hi,
> I´m asking for some general advice here. I have a project which has
> been developed in Delphi up to a point where my developer split up
> with me. I have to decide now wether access is suitable for my needs
> as I would like to rewrite this in access - visual basic.
>
> It is basically a database frontend for real estte agents with a
> ODBC-connection to my website where property for sale may be
> displayed. Pictures need to be uploaded and property data like
> bedrooms and square meters and so on must be input and edited.
>
> The finished application should be secured from source code theft and
> alteration - and run as a stand alone application - access may be
> neccessary though.
>
> I´d appreciate any general thoughts from you pros out there before I
> do something wrong.
> Thanks
> Dennis
>
> P.S. Greetings from Tenerife / Spain - probably one of the most
> beautiful islands in the world.[/color]

Hire a pro to do the work. Then go to the beach and enjoy ....

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)