Re: Updating an old application
- From: RonG <RonG@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 18 Sep 2008 07:23:02 -0700
Hi Anthony,
Thanks a lot for your thoughts. I agree completely with your comment about
using the right tools. Seeing as I'm posting this in a Microsoft Developers
forum :-), I'm trying to aim this at MS tools that might do the trick for me.
I'm beginning to think, tho, that implementing my goals using MS-centric
tools might be a bit like sticking a round peg into a square hole.
When I originally started thinking about this, my immediate thought was that
I'd need to move to something like Java/PHP/MySQL to get where I wanted to
be. But, I thought, the system is already built in the land of Windows, it's
at least worth the time to see if there's a usable solution staying in that
development environment. At first, I thought that there might be some way to
port the system into the .Net environment, but that seems to have been
wishful thinking. So far, the closest I've been able to come is something
like C#/SQLServer/mono, building both a desktop and Web application in VS,
and then porting the desktop solution to mono get get support for MacOS and
Linux. I'm kind of thinking of that solution as "build it for Windows and
then do "something" to get it to work everywhere else". The other
alternative is to use a set of tools outside of the Microsoft realm, as
you've suggested, and as I've guessed might be something like Java/PHP/MySQL.
I'm not familiar with Tcl/Tk other than to recognize the name, and I'll
check into that as well. Thanks again for your thoughts.
Ron
"Anthony.Youngman@xxxxxxxxxxxxxxxxxxxxx" wrote:
On Sep 17, 3:28 pm, RonG <R...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:.
Hi,
I'm in the process of inheriting an application written to use Access97 and
the Access97 runtime. It's a mature application with a ton of functionality,
but it does need to be brought forward. My goal is to re-architect the
system so that it can run on PCs, Macs, or the Web. I *think* I should be
moving the system into the .Net environment, but I'm unclear as to what
options I really have, short of a full re-write, which I'm not opposed to
doing. I understand that the Mac will not be supported by .Net (as far as I
know) but could be by using something like the mono project. I'm also not
opposed to completely changing platforms, ie, Java/MySQL/PHP, but this is,
after all, the Microsoft Developer's forum :-)
I think what I'm shooting for is a common database layout with common logic
components, but with independent front ends depending on the platform.
Anyway, any thoughts you might have on this would be greatly appreciated.
Also, if this question is more appropriate to another group, some direction
would be appreciated on that as well.
Thanks and have a good day.
Ron
Think of things a bit differently (I've read some of the other
responses :-)
Firstly, separate the front and back ends. Port the database to SQL-
Server and replace all the access tables by links to SQL-Server. At
the same time, duplicate that in something like MySQL. Your back end
is now platform-agnostic, but everybody still has to use Access as
their front end.
Now rewrite the front end in something like mono or Tcl/Tk. Your front-
end is now platform-agnostic ...
And off you go :-) Use the right tool for the job, and don't be fooled
by Access, which is actually a collection of tools for data storage,
entry, manipulation and reporting.
Cheers,
Wol
- References:
- Updating an old application
- From: RonG
- Re: Updating an old application
- From: Anthony . Youngman
- Updating an old application
- Prev by Date: Re: Updating an old application
- Next by Date: Does VS create manifest file or cl.exe
- Previous by thread: Re: Updating an old application
- Next by thread: Refactoring and performance
- Index(es):
Relevant Pages
|
