Major Upgrade Advice and Best Practice Sought

[BobbyDazzler]

Currently running an Access97 app split fe/be on one pc running
Windows XP. Upgrading to Access 2003 and adding a new pc running
Windows Vista via a router (wired). Obviously both pc's will have
their own FE. Not overly concerned about Access upgrade but have
limited experience in networked apps so have a few questions.

1. Do we need 2 copies of Access 2003 (or 2 registration keys)?

2. Which PC should act as the server?

3. Where should I put the backend and how do i link to it from the
other PC?

Thanks

[Tom van Stiphout]

On Tue, 14 Oct 2008 14:40:03 -0700 (PDT), BobbyDazzler
<da**************@inbox.comwrote:

1: Yes. Or at least the runtime. It was not free for A2003, unlike
A2007.

2: It matters little. I would use the fastest one.

3: On a shared location. The second one links to
\\YourServerComputer\YourShareName

-Tom.
Microsoft Access MVP

>Currently running an Access97 app split fe/be on one pc running
Windows XP. Upgrading to Access 2003 and adding a new pc running
Windows Vista via a router (wired). Obviously both pc's will have
their own FE. Not overly concerned about Access upgrade but have
limited experience in networked apps so have a few questions.

1. Do we need 2 copies of Access 2003 (or 2 registration keys)?

2. Which PC should act as the server?

3. Where should I put the backend and how do i link to it from the
other PC?

Thanks

[Rick Brandt]

Tom van Stiphout wrote:

On Tue, 14 Oct 2008 14:40:03 -0700 (PDT), BobbyDazzler
<da**************@inbox.comwrote:

1: Yes. Or at least the runtime. It was not free for A2003, unlike
A2007.

2: It matters little. I would use the fastest one.

Aren't there issues with sharing an MDB on a Vista PC with other non-Vista
PCs? I had read stories of corruption problems, but maybe a patch has been
issued?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Tom van Stiphout]

On Wed, 15 Oct 2008 06:34:13 -0500, "Rick Brandt"
<ri*********@hotmail.comwrote:

I had not read that. Surely Vista can share a file, which is all that
would be expected of it.

-Tom.
Microsoft Access MVP

>Tom van Stiphout wrote:

>On Tue, 14 Oct 2008 14:40:03 -0700 (PDT), BobbyDazzler
<da**************@inbox.comwrote:

1: Yes. Or at least the runtime. It was not free for A2003, unlike
A2007.

2: It matters little. I would use the fastest one.

Aren't there issues with sharing an MDB on a Vista PC with other non-Vista
PCs? I had read stories of corruption problems, but maybe a patch has been
issued?

[Rick Brandt]

Tom van Stiphout wrote:

On Wed, 15 Oct 2008 06:34:13 -0500, "Rick Brandt"
<ri*********@hotmail.comwrote:

I had not read that. Surely Vista can share a file, which is all that
would be expected of it.

I guess I was remembering this...

http://support.microsoft.com/?kbid=935370
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Wayne]

On Oct 16, 3:57*am, "Rick Brandt" <[e-mail]:

I guess I was remembering this...

http://support.microsoft.com/?kbid=935370

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt * at * Hunter * dot * com

Is this supposed to be the fix?: http://support.microsoft.com/kb/935366/

[Rick Brandt]

Wayne wrote:

On Oct 16, 3:57 am, "Rick Brandt" <[e-mail]:

>I guess I was remembering this...

http://support.microsoft.com/?kbid=935370

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Is this supposed to be the fix?:
http://support.microsoft.com/kb/935366/

That preceded by Vista Service Pack 1.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[BobbyDazzler]

On 15 Oct, 02:57, Tom van Stiphout <[e-mail]:

On Tue, 14 Oct 2008 14:40:03 -0700 (PDT), BobbyDazzler

<[e-mail]:

1: Yes. Or at least the runtime. It was not free for A2003, unlike
A2007.

2: It matters little. I would use the fastest one.

3: On a shared location. The second one links to
\\YourServerComputer\YourShareName

-Tom.
Microsoft Access MVP

Currently running an Access97 app split fe/be on one pc running
Windows XP. *Upgrading to Access 2003 and adding a new pc running
Windows Vista via a router (wired). *Obviously both pc's will have
their own FE. *Not overly concerned about Access upgrade but have
limited experience in networked apps so have a few questions.

1. *Do we need 2 copies of Access 2003 (or 2 registration keys)?

2. *Which PC should act as the server?

3. *Where should I put the backend and how do i link to it from the
other PC?

Thanks

Thanks Tom. Seeing as my boss is a skinflint, would it be possible to
use 97 on one machine and 2003 on the other with a 97 backend?

[SmartbizAustralia]

We still have a clients running access 97 backends with Access 2002
front ends .. so possibly this would work.

FYI - You are probably better installing the Access 2007 run-time
(which is free) and using that on the pc with Access 97.....instead.

Then you can take advantage of lots of new features in Access 2003
etc.

Regards,
Tom Bizannes
Microsoft Office and Database Development
Sydney, Australia

[Tony Toews [MVP]]

BobbyDazzler <da**************@inbox.comwrote:

>Thanks Tom. Seeing as my boss is a skinflint, would it be possible to
use 97 on one machine and 2003 on the other with a 97 backend?

Yes. I had a client running a mixture of 10 A97 users and 15 A2000 users against an
A97 backend with 160 tables and 300 Mb in size. No difference between A2000 and
A2003 in this respect as they would use Jet 4.0 to hit the BE.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/