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]

Re: Converting Access Desktop Application to Client Server

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" <u0107@usa.ne t> wrote in message
news:8a9f572f.0 309200837.60d19 8f5@posting.goo gle.com...[color=blue]
> 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[/color]

[Tony Toews]

Re: Converting Access Desktop Application to Client Server

u0107@usa.net (Uttam) wrote:
[color=blue]
>1) Are there any tools for such conversions?[/color]

There is one such tool from ssw.com.aw however it's only for SQL Server.
[color=blue]
>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?[/color]

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.microso ft.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]

Re: Converting Access Desktop Application to Client Server

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" <larry.linson@n tpcug.org> wrote in message news:<CB1bb.723 0$zA2.5290@nwrd dc02.gnilink.ne t>...[color=blue]
> 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" <u0107@usa.ne t> wrote in message
> news:8a9f572f.0 309200837.60d19 8f5@posting.goo gle.com...[color=green]
> > 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[/color][/color]

[Larry Linson]

Re: Converting Access Desktop Application to Client Server

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

"Uttam" <u0107@usa.ne t> wrote in message
news:8a9f572f.0 309201833.31e06 3be@posting.goo gle.com...[color=blue]
> 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" <larry.linson@n tpcug.org> wrote in message[/color]
news:<CB1bb.723 0$zA2.5290@nwrd dc02.gnilink.ne t>...[color=blue][color=green]
> > You can get some of my views on the topic of Access as an ODBC Client[/color][/color]
from[color=blue][color=green]
> > 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[/color][/color]
linked[color=blue][color=green]
> > 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[/color][/color]
them[color=blue][color=green]
> > using Get External Data on the file menu, and use Append Queries to add[/color][/color]
the[color=blue][color=green]
> > records from your local tables to the server tables. Then, you can[/color][/color]
delete[color=blue][color=green]
> > 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[/color][/color]
differences[color=blue][color=green]
> > that you need to take into account, so you can expect some rewriting of[/color][/color]
your[color=blue][color=green]
> > application will be needed.
> >
> > In my experience, the Access-Jet-ODBC-server has been simple to[/color][/color]
implement[color=blue][color=green]
> > 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,[/color][/color]
you'll[color=blue][color=green]
> > need advice from someone here who's actually used it. Perhaps they will[/color][/color]
step[color=blue][color=green]
> > in and offer suggestions.
> >
> > Followups and clarifications should be posted here to the newsgrup,[/color][/color]
please,[color=blue][color=green]
> > not by e-mail. Thanks.
> >
> > Larry Linson
> > Microsoft Access MVP
> >
> >
> >
> >
> >
> > "Uttam" <u0107@usa.ne t> wrote in message
> > news:8a9f572f.0 309200837.60d19 8f5@posting.goo gle.com...[color=darkred]
> > > 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[/color][/color][/color]

[Cali Rollweister]

Re: Converting Access Desktop Application to Client Server

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 <zF9bb.4626$iJ. 3420@nwrddc01.g nilink.net>, larry.linson@nt pcug.org
says...[color=blue]
>
>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" <u0107@usa.ne t> wrote in message
>news:8a9f572f. 0309201835.3414 9869@posting.go ogle.com...[color=green]
>> "David Glass" <DGlass109@hotm ail.com> wrote in message[/color]
>news:<2548047a cf6990f847ee71d 45105b825@news. teranews.com>.. .[color=green][color=darkred]
>> > "Uttam" <u0107@usa.ne t> wrote in message
>> > news:8a9f572f.0 309200837.60d19 8f5@posting.goo gle.com...
>> > > 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[/color]
>>
>> Hello David,
>>
>> http://www.mvp.com is a sports store - sure this is the correct URL?
>>
>> Cheers!
>>
>> Uttam[/color]
>
>[/color]

[David W. Fenton]

Re: Converting Access Desktop Application to Client Server

c.grimsby@world net.att.net.inv alid (Chuck Grimsby) wrote in
<nf5rmv8h6041ae 37ehido91e99atd nf662@4ax.com>:
[color=blue]
>On 20 Sep 2003 19:35:05 -0700, u0107@usa.net (Uttam) wrote:
>[color=green]
>>http://www.mvp.com is a sports store - sure this is the correct
>>URL?[/color]
>
>http://www.mvp.org/access/[/color]

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]

Re: Converting Access Desktop Application to Client Server

https://www.mvps.org/access

"Chuck Grimsby" <c.grimsby@worl dnet.att.net.in valid> wrote in message
news:nf5rmv8h60 41ae37ehido91e9 9atdnf662@4ax.c om...[color=blue]
> On 20 Sep 2003 19:35:05 -0700, u0107@usa.net (Uttam) wrote:
>[color=green]
> >http://www.mvp.com is a sports store - sure this is the correct URL?[/color]
>
> http://www.mvp.org/access/
>
>
>
> --
> Don't Look Back, They Might Be Gaining On You.
>[/color]

[Tony Toews]

Re: Converting Access Desktop Application to Client Server

"Larry Linson" <larry.linson@n tpcug.org> wrote:
[color=blue]
>Sorry, fingers working faster than brain: http://appdevissues.tripod.com is
>the URL.[/color]

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