Converting Access Desktop Application to Client Server

[Uttam]

Hello,

I am currently in the process of developing an application in a pure
desktop world using Access 2000.

I am intending to convert this pure desktop application into a Client
Server application with Access 2000 as the front end and the each of
the following as the backend:

1) Oracle
2) MS SQL

My queries are:

1) Are there any tools for such conversions?
2) The table design is such that all the tables are to be moved to the
backend but the forms need to be in the front end. How does one go
about effecting such a partial movement of the application to the
Backend?

Thank you in advance.

Cheers!

Uttam

[Larry Linson]

Oh, in my experience the DBAs for the server databases preferred to use Data
Modeling Software, as it created the necessary triggers and stored
procedures for relationships and referential integrity rather than them
having to write them in the SQL dialect of the server. In one case, that was
essential, as development was done with Sybase SQL Anywhere as the server
and the final test/production system used Informix, thus, the DBA could use
the same input to create the DDL for each.

Larry Linson
Microsoft Access MVP

"Uttam" <u0***@usa.net> wrote in message
news:8a**************************@posting.google.c om...

Hello,

I am currently in the process of developing an application in a pure
desktop world using Access 2000.

I am intending to convert this pure desktop application into a Client
Server application with Access 2000 as the front end and the each of
the following as the backend:

1) Oracle
2) MS SQL

My queries are:

1) Are there any tools for such conversions?
2) The table design is such that all the tables are to be moved to the
backend but the forms need to be in the front end. How does one go
about effecting such a partial movement of the application to the
Backend?

Thank you in advance.

Cheers!

Uttam

[Tony Toews]

u0***@usa.net (Uttam) wrote:

1) Are there any tools for such conversions?
There is one such tool from ssw.com.aw however it's only for SQL Server.
2) The table design is such that all the tables are to be moved to the
backend but the forms need to be in the front end. How does one go
about effecting such a partial movement of the application to the
Backend?

This could get quite tricky. You could convert all your queries to SQL Server views
and Stored Procedures, and whatever their equivalent is in Oracle I would imagine.

Then you'd link to the tables and/or views just like you would to a table in a BE
MDB. Here's my standard blurb on SQL Server Upsizing.

Do a search at the Knowledge Base at support.microsoft.com using the keywords
"upsizing" to review the various white papers on upsizing Access to SQL Server as
well as to ensure you have any updates required.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft Access Tips page at
my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Uttam]

Hello Larry,

This Link http://www.appdevissues.com did not work.

is it by any chance "http://www.appdev.com"?

Thanks once again.

Regards,

Uttam
==================
"Larry Linson" <la**********@ntpcug.org> wrote in message news:<CB*****************@nwrddc02.gnilink.net>...

You can get some of my views on the topic of Access as an ODBC Client from
the presentation on that subject that you can download from
http://www.appdevissues.com.

There is an upsizing wizard that you can download from Microsoft. If,
however, you are going to use an MDB/MDE client, with server tables linked
via ODBC, you simply make install the appropriate ODBC drivers for the
server you are going to use, create the same tables on the server, link them
using Get External Data on the file menu, and use Append Queries to add the
records from your local tables to the server tables. Then, you can delete
your local tables, and rename the links to the server table to what were
formerly the local table names.

As pointed out in that PowerPoint presentation, there are some differences
that you need to take into account, so you can expect some rewriting of your
application will be needed.

In my experience, the Access-Jet-ODBC-server has been simple to implement
and gave perfectly satisfactory performance for me (and for others) with
user audiences in the low hundreds. Further, this approach will work for
many different server databases.

If you desire to use the Access ADP to access your SQL Server data, you'll
need advice from someone here who's actually used it. Perhaps they will step
in and offer suggestions.

Followups and clarifications should be posted here to the newsgrup, please,
not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP

"Uttam" <u0***@usa.net> wrote in message
news:8a**************************@posting.google.c om...

Hello,

I am currently in the process of developing an application in a pure
desktop world using Access 2000.

I am intending to convert this pure desktop application into a Client
Server application with Access 2000 as the front end and the each of
the following as the backend:

1) Oracle
2) MS SQL

My queries are:

1) Are there any tools for such conversions?
2) The table design is such that all the tables are to be moved to the
backend but the forms need to be in the front end. How does one go
about effecting such a partial movement of the application to the
Backend?

Thank you in advance.

Cheers!

Uttam

[Larry Linson]

Sorry, fingers working faster than brain: http://appdevissues.tripod.com is
the URL.

"Uttam" <u0***@usa.net> wrote in message
news:8a**************************@posting.google.c om...

Hello Larry,

This Link http://www.appdevissues.com did not work.

is it by any chance "http://www.appdev.com"?

Thanks once again.

Regards,

Uttam
==================
"Larry Linson" <la**********@ntpcug.org> wrote in message

news:<CB*****************@nwrddc02.gnilink.net>...

You can get some of my views on the topic of Access as an ODBC Client from the presentation on that subject that you can download from
http://www.appdevissues.com.

There is an upsizing wizard that you can download from Microsoft. If,
however, you are going to use an MDB/MDE client, with server tables linked via ODBC, you simply make install the appropriate ODBC drivers for the
server you are going to use, create the same tables on the server, link them using Get External Data on the file menu, and use Append Queries to add the records from your local tables to the server tables. Then, you can delete your local tables, and rename the links to the server table to what were
formerly the local table names.

As pointed out in that PowerPoint presentation, there are some differences that you need to take into account, so you can expect some rewriting of your application will be needed.

In my experience, the Access-Jet-ODBC-server has been simple to implement and gave perfectly satisfactory performance for me (and for others) with
user audiences in the low hundreds. Further, this approach will work for
many different server databases.

If you desire to use the Access ADP to access your SQL Server data, you'll need advice from someone here who's actually used it. Perhaps they will step in and offer suggestions.

Followups and clarifications should be posted here to the newsgrup, please, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP

"Uttam" <u0***@usa.net> wrote in message
news:8a**************************@posting.google.c om...

Hello,

I am currently in the process of developing an application in a pure
desktop world using Access 2000.

I am intending to convert this pure desktop application into a Client
Server application with Access 2000 as the front end and the each of
the following as the backend:

1) Oracle
2) MS SQL

My queries are:

1) Are there any tools for such conversions?
2) The table design is such that all the tables are to be moved to the
backend but the forms need to be in the front end. How does one go
about effecting such a partial movement of the application to the
Backend?

Thank you in advance.

Cheers!

Uttam

[Cali Rollweister]

Larry,

I see no sign of this "Don Mellon" fellow you are talking about. Are you sure
you have the right person? Perhaps your boyfriend Tony can shed some light on
the matter, though I heard he got turned back at the US border recently
(something about his marriage not being recognized).

Yours,

Cali Rollweister, Microsoft Access MVP
http://www.mvp.com
In article <zF****************@nwrddc01.gnilink.net>, la**********@ntpcug.org
says...

No, he's neither sure, nor David Glass, nor a Microsoft MVP. He's Don
Mellon, who persists in trying to (and is, sadly, successful at) making a
bigger and bigger fool of himself in public in these newsgroups. Pathetic,
isn't he?

"Uttam" <u0***@usa.net> wrote in message
news:8a**************************@posting.google. com...

"David Glass" <DG*******@hotmail.com> wrote in message

news:<25******************************@news.teran ews.com>...

> "Uttam" <u0***@usa.net> wrote in message
> news:8a**************************@posting.google.c om...
> > Hello,
> >
> > I am currently in the process of developing an application in a pure
> > desktop world using Access 2000.
> >
> > I am intending to convert this pure desktop application into a Client
> > Server application with Access 2000 as the front end and the each of
> > the following as the backend:
> >
> > 1) Oracle
> > 2) MS SQL
> >
> > My queries are:
> >
> > 1) Are there any tools for such conversions?
> > 2) The table design is such that all the tables are to be moved to the
> > backend but the forms need to be in the front end. How does one go
> > about effecting such a partial movement of the application to the
> > Backend?
> >
> > Thank you in advance.
> >
> > Cheers!
> >
> > Uttam
>
> Go to: http://www.mvp.com
> Best Regards
> David Glass, MVP

Hello David,

http://www.mvp.com is a sports store - sure this is the correct URL?

Cheers!

Uttam

[David W. Fenton]

c.*******@worldnet.att.net.invalid (Chuck Grimsby) wrote in
<nf********************************@4ax.com>:

On 20 Sep 2003 19:35:05 -0700, u0***@usa.net (Uttam) wrote:

http://www.mvp.com is a sports store - sure this is the correct
URL?

http://www.mvp.org/access/

Er, uh:

http://www.mvps.org/access/

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Saintor]

www.mvps.org/access
"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:nf********************************@4ax.com...

On 20 Sep 2003 19:35:05 -0700, u0***@usa.net (Uttam) wrote:

http://www.mvp.com is a sports store - sure this is the correct URL?

http://www.mvp.org/access/

--
Don't Look Back, They Might Be Gaining On You.

[Tony Toews]

"Larry Linson" <la**********@ntpcug.org> wrote:

Sorry, fingers working faster than brain: http://appdevissues.tripod.com is
the URL.

See the Newsgroup Answers MDB at my website. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm