Home > Archive > MS Access data conversion > June 2005 > Access Conversion back end/frond end









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Access Conversion back end/frond end
barker

2005-06-21, 1:24 pm


I need to have some users be able to update and manipulate database tables
that are still in Access '97 after they are converterd to Acccess 2003.

Is the only way they can use the Access '97 table via the Splitting of the
front end and back end. .. or can they just convert their database to 2003
and still link to acess '97 tables whereby they may still update in '97
tables ?


--
Good Lookin' Out!
Douglas J. Steele

2005-06-21, 8:25 pm

I'm not really sure I understand what subtlety you're trying to make.

How is having a 2003 database linked to the Access 97 tables any different
than splitting into a front-end/back-end?

Realistically, that's your only option: front-ends in both Access 97 and
Access 2003, linked to the back-end in Access 97.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"barker" <barker@discussions.microsoft.com> wrote in message
news:306B54F9-C80D-4362-936A- 1787C310F648@microso
ft.com...
>
> I need to have some users be able to update and manipulate database tables
> that are still in Access '97 after they are converterd to Acccess 2003.
>
> Is the only way they can use the Access '97 table via the Splitting of the
> front end and back end. .. or can they just convert their database to 2003
> and still link to acess '97 tables whereby they may still update in '97
> tables ?
>
>
> --
> Good Lookin' Out!



barker

2005-06-22, 11:24 am

That's what I thought...You are absolutely correct. I was just making sure I
was not overlooking something. I guess I was'nt sure if you REALLY need to
perform a Database Splitter command to have the same functionality.

Thanks so much!
--
Good Lookin' Out!


"Douglas J. Steele" wrote:

> I'm not really sure I understand what subtlety you're trying to make.
>
> How is having a 2003 database linked to the Access 97 tables any different
> than splitting into a front-end/back-end?
>
> Realistically, that's your only option: front-ends in both Access 97 and
> Access 2003, linked to the back-end in Access 97.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "barker" <barker@discussions.microsoft.com> wrote in message
> news:306B54F9-C80D-4362-936A- 1787C310F648@microso
ft.com...
>
>
>

Douglas J. Steele

2005-06-22, 8:25 pm

Well, it's certainly not necessary to use the built-in Database Splitter in
Access. In all the applications I've built, I've never used it once...

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"barker" <barker@discussions.microsoft.com> wrote in message
news:3C76AACC-CFA9-458F-9FDA- B6FF210F9F93@microso
ft.com...[color=darkred]
> That's what I thought...You are absolutely correct. I was just making
> sure I
> was not overlooking something. I guess I was'nt sure if you REALLY need
> to
> perform a Database Splitter command to have the same functionality.
>
> Thanks so much!
> --
> Good Lookin' Out!
>
>
> "Douglas J. Steele" wrote:
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com