Problems with Access and Vista

[sweeneysmsm]

See http://support.microsoft.com/kb/935370/en-us

Does the above mean that if I run an Access Database on a laptop running
Vista that I will encounter this hang or crash problem OR

Does it mean that if the database is on a server and I am using a Vista
machine (desktop or laptop) to access it that I will have a problem.

I am asking this because the article refers to 2 different versions of
Server Message Block and that made me think that the problem could be related
to their being a server involved.

I can’t believe that there was all of this testing for Vista and Office 2007
and such a problem was not detected???

Thanks.

Mary

 

[Douglas J. Steele]

The KB article in question states:

"This problem may occur if the following conditions are true: . The database
that you are using is a shared database that resides on a Windows
Vista-based computer.
. Two or more Windows Vista-based computers are trying to use the
database at the same time."


You shouldn't run into that problem if the database is on a server, since
there isn't a Server version of Vista.

 

[Tony Toews [MVP]]

You shouldn't run into that problem if the database is on a server, since
there isn't a Server version of Vista.

Well there is. Windows Server Longhorn. But that's in beta and thus
shouldn't be a problem for production purposes.

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

 

[sweeneysmsm]

Thank you, Doug, for your reply.

In fact, I don't want to have the db on a server. I need it on a Vista
laptop with just me using it. Will I run into trouble doing that? Does the
SMB still get involved?

Mary

 

[Allen Browne]

Mary, the way I read this article is that you hit the problem if:

a) You share the database on a Vista machine (or a Longhorn Server beta
machine), and

b) You open it with 2 or more Vista machines at once.

So if you have a Vista desktop machine with the database open, and you open
it on your Vista laptop as well, you destroy the database.

 

[David W. Fenton]

Well there is. Windows Server Longhorn. But that's in beta and
thus shouldn't be a problem for production purposes.

More correctly, it's not the server version that matters, but the
version of SMB. I recall a post recently that talked about forcing
Vista into using the old SMB, but can't locate anything about it in
a Google search. I must have seen it in another forum.

 

[David W. Fenton]

Mary, the way I read this article is that you hit the problem if:

a) You share the database on a Vista machine (or a Longhorn Server
beta machine), and

b) You open it with 2 or more Vista machines at once.

So if you have a Vista desktop machine with the database open, and
you open it on your Vista laptop as well, you destroy the
database.

The issue is if you use SMB 2. That requires:

1. a workstation running a version of Windows with SMB 2 (i.e.,
Vista)

2. a server running a version of Windows with SMB 2 (Longhorn is the
only server version, but if you're on a peer-to-peer network, this
could also be another Vista box).

Does anyone remember a post in one of the Access newsgroups about
forcing Vista to use "classic" SMB instead of SMB 2? I have a vague
memory about it but can't find anything.

 

[Tony Toews [MVP]]

The issue is if you use SMB 2. That requires:

1. a workstation running a version of Windows with SMB 2 (i.e.,
Vista)

2. a server running a version of Windows with SMB 2 (Longhorn is the
only server version, but if you're on a peer-to-peer network, this
could also be another Vista box).

Or

3. two workstations running Vista with SMB 2.0 enabled sharing Access MDBs/ACCDBs.

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

 

[David W. Fenton]

Or

3. two workstations running Vista with SMB 2.0 enabled sharing
Access MDBs/ACCDBs.

That's covered by my two numbered items -- PC 1 (workstation) by #1,
PC 2 (workstation/server) by #2. And, of course, for some apps PC 1
could be #2 and PC 2 #1. The point is that both the workstation and
the server have to be running SMB2. The server can be either Vista
or Longhorn.

 

[Tony Toews [MVP]]

That's covered by my two numbered items -- PC 1 (workstation) by #1,
PC 2 (workstation/server) by #2. And, of course, for some apps PC 1
could be #2 and PC 2 #1. The point is that both the workstation and
the server have to be running SMB2. The server can be either Vista
or Longhorn.

Ah, ok. You're explanation indicates that #1 and #2 are connected together. I read
that as being two different scenarios. I think.

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

 

[David W. Fenton]

Ah, ok. You're explanation indicates that #1 and #2 are
connected together. I read that as being two different scenarios.
I think.

Yes, it requires both, as both the workstation and the server need
to be running SMB 2, which requires Vista + Longhorn or Vista +
Vista.