Main Page | Report Page

 

  Computers Forum Index » Computer - Databases - MS Access » multiple users' simultaneous access to a MS Access...

Author Message
James A. Fortune...
Posted: Mon Oct 04, 2010 5:18 pm
 
On Oct 4, 7:51 am, "Bob Barrows" <reb01... at (no spam) NOSPAMyahoo.com> wrote:
Quote:
James A. Fortune wrote:
On Sep 30, 10:53 am, The Frog <mr.frog.to.... at (no spam) googlemail.com> wrote:
This might seem like a silly question, and maybe I just missed the
wording somewhere, but I thought it prudent to ask:
Is the database application split into Front End / Back End or is it
just a 'stand-alone' file (.mdb)?

What part of "back end databases" or "front end databases linked to
those tables" was unclear Smile?

Only the part about who said those words ... care to point out that post to
us?

I posted those words. The portions in double quotes were direct
quotations. Didn't my post of Sep 29 -- the one The Frog replied to
-- show up? I still see it with Google Groups.

James A. Fortune
CDMAPoster at (no spam) FortuneJames.com
 
Bob Barrows...
Posted: Mon Oct 04, 2010 9:33 pm
 
James A. Fortune wrote:
Quote:
On Oct 4, 7:51 am, "Bob Barrows" <reb01... at (no spam) NOSPAMyahoo.com> wrote:
James A. Fortune wrote:
On Sep 30, 10:53 am, The Frog <mr.frog.to.... at (no spam) googlemail.com> wrote:
This might seem like a silly question, and maybe I just missed the
wording somewhere, but I thought it prudent to ask:
Is the database application split into Front End / Back End or is
it just a 'stand-alone' file (.mdb)?

What part of "back end databases" or "front end databases linked to
those tables" was unclear Smile?

Only the part about who said those words ... care to point out that
post to us?

I posted those words. The portions in double quotes were direct
quotations. Didn't my post of Sep 29 -- the one The Frog replied to
-- show up? I still see it with Google Groups.

Are you the OP (original poster)? If not, then you really can't speak
for the OP can you? We're still trying to make suggestions to solve
zufie's issue.

--
HTH,
Bob Barrows
 
Christian Alain Ouellet...
Posted: Tue Oct 05, 2010 4:40 pm
 
Hi there

I think your best chance is to create a request broker. You create a
program that does the accesses to your Access db and makes a queue of
requests. You can prioritize say selects first than updates, delete and
finally insert. In effect you could create a database server. Of course,
you will need to create a way of connecting the client software to that
broker. Best solution would be a winsock and create a protocol to encode
requests and also one to send results.



*** Sent via Developersdex http://www.developersdex.com ***
 
James A. Fortune...
Posted: Tue Oct 05, 2010 7:41 pm
 
On Oct 4, 1:33 pm, "Bob Barrows" <reb01... at (no spam) NOyahoo.SPAMcom> wrote:
Quote:
James A. Fortune wrote:
On Oct 4, 7:51 am, "Bob Barrows" <reb01... at (no spam) NOSPAMyahoo.com> wrote:
James A. Fortune wrote:
On Sep 30, 10:53 am, The Frog <mr.frog.to.... at (no spam) googlemail.com> wrote:
This might seem like a silly question, and maybe I just missed the
wording somewhere, but I thought it prudent to ask:
Is the database application split into Front End / Back End or is
it just a 'stand-alone' file (.mdb)?

What part of "back end databases" or "front end databases linked to
those tables" was unclear Smile?

Only the part about who said those words ... care to point out that
post to us?

I posted those words.  The portions in double quotes were direct
quotations.  Didn't my post of Sep 29 -- the one The Frog replied to
-- show up?  I still see it with Google Groups.

Are you the OP (original poster)? If not, then you really can't speak
for the OP can you? We're still trying to make suggestions to solve
zufie's issue.

--
HTH,
Bob Barrows

I was replying to a comment by David Fenton. I didn't realize that
The Frog was asking the OP a question because that post was a reply to
my post. I have to confess that I haven't tried very hard to solve
zufie's issue, nor have I even read the thread carefully enough to
know what the issue is in detail, much less solve it.

James A. Fortune
CDMAPoster at (no spam) FortuneJames.com
 
Bob Barrows...
Posted: Tue Oct 05, 2010 11:53 pm
 
James A. Fortune wrote:
Quote:
On Oct 4, 1:33 pm, "Bob Barrows" <reb01... at (no spam) NOyahoo.SPAMcom> wrote:
James A. Fortune wrote:
On Oct 4, 7:51 am, "Bob Barrows" <reb01... at (no spam) NOSPAMyahoo.com> wrote:
James A. Fortune wrote:
On Sep 30, 10:53 am, The Frog <mr.frog.to.... at (no spam) googlemail.com
wrote:
This might seem like a silly question, and maybe I just missed
the wording somewhere, but I thought it prudent to ask:
Is the database application split into Front End / Back End or is
it just a 'stand-alone' file (.mdb)?

What part of "back end databases" or "front end databases linked
to those tables" was unclear Smile?

Only the part about who said those words ... care to point out that
post to us?

I posted those words. The portions in double quotes were direct
quotations. Didn't my post of Sep 29 -- the one The Frog replied to
-- show up? I still see it with Google Groups.

Are you the OP (original poster)? If not, then you really can't speak
for the OP can you? We're still trying to make suggestions to solve
zufie's issue.


I was replying to a comment by David Fenton. I didn't realize that
The Frog was asking the OP a question because that post was a reply to
my post. I have to confess that I haven't tried very hard to solve
zufie's issue, nor have I even read the thread carefully enough to
know what the issue is in detail, much less solve it.

Ah, I thought Frog's question was obviously directed to the OP despite

it being a reply to your post, and you thought it was directed to you
despite it being a non sequitur from your post. Smile All is clear now.
Thx, and apologies.

--
HTH,
Bob Barrows
 
Tony Toews...
Posted: Wed Oct 06, 2010 5:15 am
 
On 05 Oct 2010 12:40:02 GMT, Christian Alain Ouellet
<caouellet at (no spam) msn.com> wrote:

Quote:
I think your best chance is to create a request broker. You create a
program that does the accesses to your Access db and makes a queue of
requests. You can prioritize say selects first than updates, delete and
finally insert. In effect you could create a database server. Of course,
you will need to create a way of connecting the client software to that
broker. Best solution would be a winsock and create a protocol to encode
requests and also one to send results.

I'd suggest switching to SQL Server then.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
 
a b...
Posted: Wed Oct 06, 2010 3:23 pm
 
If it's on a Netware server then the users need Read & Write to the
backend DB. The LDB should be set with file permissions Shareable,
Rename Inhibit, Delete Inhibit (start the application, set the Netware
properties, apply them) which means they don't need Create. This works
on the apps I support. There's also a Novell TID (advisory) on setting
Cacheing off, which (if on) can foul things up.
 
David-W-Fenton...
Posted: Thu Oct 07, 2010 12:11 am
 
a b <erratticus at (no spam) gmail.com> wrote in
news:1c17b88d-4316-48d2-85f1-b939b42a3a29 at (no spam) f6g2000yqa.googlegroups.com
:

Quote:
If it's on a Netware server then the users need Read & Write to
the backend DB. The LDB should be set with file permissions
Shareable, Rename Inhibit, Delete Inhibit (start the application,
set the Netware properties, apply them) which means they don't
need Create. This works on the apps I support. There's also a
Novell TID (advisory) on setting Cacheing off, which (if on) can
foul things up.


On Novell, can you set permissions by file type? If not, then I
don't understand what you mean about setting LDB permissions. Also,
I don't know why you'd set "Delete Inhibit" on the LDB. I don't know
what that means, but it seems to imply that it prevents the deletion
of the LDB, which is not necessarily a preferred environment to run
in. Certainly if as with NTFS you can set permissions only on
existing files and folders, removing DELETE permission can be a
safety measure (preventing a user from "accidentally" deleting your
back end), but you were speaking of the LDB, so I'm confused.

(personally, I'd never let clients store production Jet/ACE files on
anything but a native Windows file system)

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
 
Tony Toews...
Posted: Thu Oct 07, 2010 5:15 am
 
On 6 Oct 2010 20:11:05 GMT, "David-W-Fenton"
<NoEmail at (no spam) SeeSignature.invalid> wrote:

Quote:
Certainly if as with NTFS you can set permissions only on
existing files and folders,

Actually you can set permissions on folders and possibly files that
don't exist using ACL and Active Directory and such. I forget the
details as it's been quite a while now but I wrote a program for a
construction company to set permissions on job subfolders, such as
Drawings, Invoicing, TimeSheets to be by Active Directory group.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
 
David-W-Fenton...
Posted: Fri Oct 08, 2010 5:15 am
 
Tony Toews <ttoews at (no spam) telusplanet.net> wrote in
news:mthqa6tps3lvg1jvr8g5cnpvj2tr1i43fv at (no spam) 4ax.com:

Quote:
On 6 Oct 2010 20:11:05 GMT, "David-W-Fenton"
NoEmail at (no spam) SeeSignature.invalid> wrote:

Certainly if as with NTFS you can set permissions only on
existing files and folders,

Actually you can set permissions on folders and possibly files
that don't exist using ACL and Active Directory and such. I
forget the details as it's been quite a while now but I wrote a
program for a construction company to set permissions on job
subfolders, such as Drawings, Invoicing, TimeSheets to be by
Active Directory group.

I'm interested in the idea of setting permissions on files that
don't yet exist, as distinct from the usual thing I've done of
removing DELETE permissons on the folder (that propagates to the
files created inside it, of course).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
 
James A. Fortune...
Posted: Fri Oct 08, 2010 3:36 pm
 
On Oct 5, 3:53 pm, "Bob Barrows" <reb01... at (no spam) NOyahoo.SPAMcom> wrote:
Quote:
James A. Fortune wrote:
On Oct 4, 1:33 pm, "Bob Barrows" <reb01... at (no spam) NOyahoo.SPAMcom> wrote:
James A. Fortune wrote:
On Oct 4, 7:51 am, "Bob Barrows" <reb01... at (no spam) NOSPAMyahoo.com> wrote:
James A. Fortune wrote:
On Sep 30, 10:53 am, The Frog <mr.frog.to.... at (no spam) googlemail.com
wrote:
This might seem like a silly question, and maybe I just missed
the wording somewhere, but I thought it prudent to ask:
Is the database application split into Front End / Back End or is
it just a 'stand-alone' file (.mdb)?

What part of "back end databases" or "front end databases linked
to those tables" was unclear Smile?

Only the part about who said those words ... care to point out that
post to us?

I posted those words. The portions in double quotes were direct
quotations. Didn't my post of Sep 29 -- the one The Frog replied to
-- show up? I still see it with Google Groups.

Are you the OP (original poster)? If not, then you really can't speak
for the OP can you? We're still trying to make suggestions to solve
zufie's issue.

I was replying to a comment by David Fenton.  I didn't realize that
The Frog was asking the OP a question because that post was a reply to
my post.  I have to confess that I haven't tried very hard to solve
zufie's issue, nor have I even read the thread carefully enough to
know what the issue is in detail, much less solve it.

Ah,  I thought Frog's question was obviously directed to the OP despite
it being a reply to your post, and you thought it was directed to you
despite it being a non sequitur from your post. Smile All is clear now.
Thx, and apologies.

--
HTH,
Bob Barrows

Yes. It's all about me Smile. Sometimes it's hard to tell the
erroneous non sequiturs from the intentional ones Smile.

James A. Fortune
CDMAPoster at (no spam) FortuneJames.com
 
David-W-Fenton...
Posted: Mon Oct 11, 2010 9:43 pm
 
a b <erratticus at (no spam) gmail.com> wrote in
news:525eb847-5d0c-425e-adea-d999a942ab52 at (no spam) l35g2000vbr.googlegroups.co
m:

Quote:
Not sure what you mean by not deleting the LDB being not a
preferred environment? It works for the applications I support
with 100's of users,
with no more than the usual Access bugs occurrring!

Well, because an LDB file can become corrupted in regular use, it's
good to have it deleted and recreated from scratch. The scenario you
describe is like Access 2 and before, where the LDB file was not
deleted when the last user exited, and Microsoft changed that in Jet
3.x, so that the LDB file is deleted when the last user exits.

All that said, it's not a huge problem, just not the default
operating environment.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
 
 
Page 2 of 2    Goto page Previous  1, 2
All times are GMT
The time now is Thu Apr 24, 2014 3:19 am