Re: Network access
- From: David H <DavidH@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 5 Dec 2008 18:30:01 -0800
It is very well known fact that the same Access .mdb file can be opened
multiple times by the same user or by multiple users. I'm merely stating life
as it is.
"NTC" wrote:
that is snide and poor logic overall.....
think about it - 2 people in the same database user space simultaneously;
it should not be possible - - that it is possible with XP and prior versions
is the flaw....and has always lead to unpredictable behavior....
"David H" wrote:
" I can run one instance over the
network, but not two at once, unless the second instance is from the
folder in which the app resides. "
1) What do you mean by that? Regardless of were the front end is located, if
you open it and it starts and then you open THE SAME FILE you should get two
instances. Period, that's just life.
"All computers on the network are Vista Home Premium"
2) No comment.
"I am told this works as desired on another, all-XP, network. "
3) Yes it most likely CORRECTLY runs on WindowsXP.
If you deploy the Front Ends out as Tom mentioned not only will you be
consistent with an Access best-practice, but you'll be able to get over this
hurdle.
In short, the problem is most likely VISTA.
Now do those ProjectMohave commercials make sense. The vast majority of
corporate America has refused to implement Vista for a wide variety of issues
summed up in one word - VISTA, which in some languages (or so I'm told)
roughly translates to "I suck."
http://weblog.infoworld.com/save-xp/
"Tom van Stiphout" wrote:
On Tue, 02 Dec 2008 14:14:52 -0800, Geoff Turnbull
<codistic@xxxxxxxxx> wrote:
You are violating an important deployment rule.
Access apps should be split in front-end (everything but tables, and
attached tables) and back-end (tables). The BE should be on a server,
the FE on every workstation. Violate this rule and tar & feathers lie
in your immediate future :-)
-Tom.
Microsoft Access MVP
I have an Access VBA app on a network folder that I'd like to run
simultaneously by multiple users. I can run one instance over the
network, but not two at once, unless the second instance is from the
folder in which the app resides. The second instance doesn't even get
to the security warning. I can run one instance from any computer on
the network--so it seems not to be a matter of permissions, and can run
multiple instances of a C++ app (which opens the Access .mdb file that
hosts the VBA app).
All computers on the network are Vista Home Premium. I am told this
works as desired on another, all-XP, network.
I'd appreciate any ideas on this problem. If there's a better forum,
please advise.
Thanks, Geoff.
- Follow-Ups:
- Re: Network access
- From: NTC
- Re: Network access
- References:
- Network access
- From: Geoff Turnbull
- Re: Network access
- From: Tom van Stiphout
- Re: Network access
- From: David H
- Re: Network access
- From: NTC
- Network access
- Prev by Date: Re: subtotal group records in Access 2007
- Next by Date: Re: to specify a read-only Recordset in Access 2003 Visual Basic
- Previous by thread: Re: Network access
- Next by thread: Re: Network access
- Index(es):
Relevant Pages
|
