Re: Updating an old application

Hi Norman,

Thanks for the response. So, I could, for example, convert the database
from Access to SQLServer, and then recode the system using one of the .Net
languages. Is it possible, do you think, to convert AccessVBA into VB.Net
through some sort of migration that might convert some, but probably not all,
of the code?

I'll also have to learn more about deploying SQLServer in these
environments. Is SQLServer supported on the MacOS?

Thanks again for your thoughts.

Ron

"Norman Yuan" wrote:

The choice is obvious:

Access only runs on Windows desktop, it does not run on Mac (unless you use
Wndows emulator), nor be used via the Internet. If you re-write it as .NET
desktop, it is still Window only. No other OS runs .NET on user end.

If you want to make it a web app, so that users with Win/Mac can access it
vis web browser, then you need to throw away whatever the current Access app
has and re-write the whole thing, be it .NET web app or Java or some other
technologies.


"RonG" <RonG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EA3E0B68-B92C-475F-8947-73A17DC70F80@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Moving full-text index to a different system - problems
    ... What I did was to restore the database into a database which had the db_id I ... > The Content Index for project <SQLServer SQL0001100005> cannot be loaded. ... > The previous crawl was reset, ...
    (microsoft.public.sqlserver.fulltext)
  • Moving full-text index to a different system - problems
    ... different database server wuthout losing their data or full-text index. ... The Search service has loaded project. ... The Content Index for project <SQLServer SQL0001100005> cannot be loaded. ... The previous crawl was reset, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Access Autonumber problem
    ... Between now and Nov. 6th 2006 you can sign up for a substantial discount. ... primary application that the database uses. ... fairly large customer base. ... In SQLServer the ID ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Importing .dat file
    ... You've obviously never written software for a bunch of clients ... It is not the primary responsibility of my users to do SQLServer. ... would stop using Excel for everything and start using a database; ... mean SQL Server Developers' edition costs $49; ...
    (microsoft.public.dotnet.languages.vb)
  • Re: sqlserver backup & recovery procedures
    ... have rights to the new database. ... >> filename (backup done). ... >> i copied this file to another system running sqlserver ... >> no service packs had been installed for sqlserver 2000. ...
    (microsoft.public.sqlserver.security)
Loading