R
Rob Oldfield
Hi all,
I have a very strange situation with Access 2000 mdbs. It doesn't really
fit precisely into any of the Access newsgroups so I hope you'll forgive me
for using this one.
The problem....
A domain where _all_ Access mdb data is going horribly wrong.
Within this (Win2k) domain there are a number of databases: some of them
were set up by me and are standard multiuser front-end per user/back-end
type things; some have been set up by users of the domain which again are
multiuser but with everyone running off shortcuts pointing directly to the
mdb containing both front-end elements and data; some mdbs which are single
user. These all live on a couple of file servers - one Win2k and one
Win2003,
About a week ago, the users of one of the main fe/be mdbs reported that
things were going very slowly. I connected up and it was indeed going
horribly slowly. Went back in after all the users had gone home and it went
in at normal speed. These reports gradually spread to other mdbs. I also
had reports of users getting the error "Too many active users" going into
databases - even those where they were the only user.
I've even seen the "Too many active users" error for myself: in an effort to
figure out what was going on I connected up via a Terminal Server connection
to this domain and downloaded the JetUtils.exe from
http://makeashorterlink.com/?B2EB24976 - expand that and it contains a
couple of mdbs. I tried to open one of those and got the error for myself.
Nothing that I've seen before seems to make sense of this. I'd put it down
to dodgy network connections, but I'm not hearing of any other problems
opening any other types of file - and they do have some very chunky
spreadsheets in use.
Anyone else seen anything like this? Any ideas?
(...and to anyone who remembers me posting here regularly.... hope that
you're well and that your mdbs don't require any decompile switches....)
I have a very strange situation with Access 2000 mdbs. It doesn't really
fit precisely into any of the Access newsgroups so I hope you'll forgive me
for using this one.
The problem....
A domain where _all_ Access mdb data is going horribly wrong.
Within this (Win2k) domain there are a number of databases: some of them
were set up by me and are standard multiuser front-end per user/back-end
type things; some have been set up by users of the domain which again are
multiuser but with everyone running off shortcuts pointing directly to the
mdb containing both front-end elements and data; some mdbs which are single
user. These all live on a couple of file servers - one Win2k and one
Win2003,
About a week ago, the users of one of the main fe/be mdbs reported that
things were going very slowly. I connected up and it was indeed going
horribly slowly. Went back in after all the users had gone home and it went
in at normal speed. These reports gradually spread to other mdbs. I also
had reports of users getting the error "Too many active users" going into
databases - even those where they were the only user.
I've even seen the "Too many active users" error for myself: in an effort to
figure out what was going on I connected up via a Terminal Server connection
to this domain and downloaded the JetUtils.exe from
http://makeashorterlink.com/?B2EB24976 - expand that and it contains a
couple of mdbs. I tried to open one of those and got the error for myself.
Nothing that I've seen before seems to make sense of this. I'd put it down
to dodgy network connections, but I'm not hearing of any other problems
opening any other types of file - and they do have some very chunky
spreadsheets in use.
Anyone else seen anything like this? Any ideas?
(...and to anyone who remembers me posting here regularly.... hope that
you're well and that your mdbs don't require any decompile switches....)