Re: Access Retirement

Access can link to SQL Server tables or views via ODBC. This approach will
require fewer changes to the existing applications than other approaches -
and you probably don't want to invest resources in making a lot of changes
to existing applications if they're going to be replaced soon anyway.

--
Brendan Reynolds

"Ram" <Ram@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1B39F65C-86D2-4A43-84F7-F0A405FD1F4F@xxxxxxxxxxxxxxxx
> Basically the migration approach is approved in 2 phases. 1st phase, just
> migrate the data which is in Access 97 and move it to SQL 2K and in the
> second phase, convert Access Forms to web based forms using C#. For phase
> 2,
> the buegets are allocated in Q1, 2006.
>
> Since i couldn't give more info in my previous mail, thought of sharing
> the
> same now with u.
>
> When i migrate the 97 database, can Access 2000 front end still work with
> Jet Engine or i'll have to rewrite the queries and push to SQL as stored
> procedures (if i plan to use ADO instead DAO)?
>
> Ram
>
> "Brendan Reynolds" wrote:
>
>> Support (other than self-help online support) for Office 95 and Office 97
>> has already ended ...
>>
>> http://support.microsoft.com/gp/lifeoffice/
>>
>> I will not attempt to guess whether you should migrate the databases to
>> SQL
>> Server or not as I don't have nearly enough information. But note that
>> you
>> do not have to choose between upgrading the applications to a later
>> version
>> of Access and migrating the databases to SQL Server - you can, if
>> appropriate, do both.
>>
>> --
>> Brendan Reynolds
>>
>> "Ram" <Ram@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:EAB49505-FCC0-4A2F-9225-C4C99E114009@xxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > I don't know this is the relevant place or not, but i need information
>> > about
>> > Access 97 support.
>> >
>> > Can anyone tell me till when Microsoft is going to support Access 95
>> > and
>> > 97?
>> > Is there any URL that i can know the timelines when and what product
>> > will
>> > be
>> > pulled out from the Product support?
>> >
>> > I need to upgrade few Access older version applications to the latest.
>> > Here
>> > i need to take a call, should i upgrade to Access 2003 or migrate the
>> > databases to SQL2K?
>> >
>> > Please someone reply to me. You can directly mail me at
>> > ramakrishna.vakacherla@xxxxxxxxxxx
>> >
>> > I need this info to convey my client before EOD today. (15th Nov, 05)
>> >
>> > Thanks in advance for your support and sorry if i wrongly posted the
>> > msg
>> > in
>> > a diff group.
>> >
>> > Ram
>>
>>
>>


.

Relevant Pages

  • Re: Quorum Disk or Majority Node?
    ... LOT of 3rd party applications where every issue is always blamed on ... See "Sizing a Majority Node Set Cluster" ... When SQL Server 2005 starts supporting database mirroring there is ... SQL Server does not NATIVELY support MNS clustering. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SSIS as part of scheduled job fails
    ... An SSIS package does not run when you call the SSIS package from a SQL ... Microsoft SQL Server Management Studio ... I ended up contacting Microsoft and opening a support case. ...
    (microsoft.public.sqlserver.dts)
  • Re: Cannot setup SQL Mail on SBS 2003
    ... Microsoft CSS Online Newsgroup Support ... Cannot setup SQL Mail on SBS 2003 ... The account you use to start the SQL Server service must be a domain ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Express Edition Network Deployment Error
    ... I have instructed my colleague to ask for a quotation of MS SQL Standard to solve our problem. ... There is a 25% Discount on SQL Server up to Sept this year. ... Because your mdf is located in a network share and our app accesses the mdf ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: SSMSE vs. SSMS
    ... Yes, from the following article in SQL Server 2005 BOL, I think that you ... SSMSE cannot manage Analysis Services, Integration Services, Notification ... SSMSE does not support scheduling administrative tasks by using SQL ...
    (microsoft.public.sqlserver.clients)