Multiple User Access to DB Not Working?

  • Thread starter Thread starter Aaron Slater, Navy Region Northwest
  • Start date Start date
A

Aaron Slater, Navy Region Northwest

Greetings;

I work for a reasonably large government agency that floats about the water
in big grey boats. We just upgraded our computers to Windows XP and now are
having problems with our databases.

Currently, in this office, I am the creator of a document tracking database
created in Access 2003. It is hosted on a shared network located off-site.
Previously, under the reign of Windows 2000, The personnel within the office
were all able to access the database simultaneously without complications.

Now after the WinXP switchover, When one person has the database open,
nobody else can open it. They will double-click on the icon, and nothing
happens. Access will not attempt to load, and no error messages or dialogs of
any kind show up.

The one exception is myself. I can open the database at will regardless of
who is in it, but again, nobody else can open it at that time.

The steps I have taken are thus:

Under the file properties Security Tab, all users have full control of the
file.

In the DB, I have gone to Tools>Options>Advanced and under "Default Open
Mode" "Shared" is selected. This is the only advice out IT people could give.

Any help will be appreciated. Thanks!
 
"Aaron Slater, Navy Region Northwest"
Greetings;

I work for a reasonably large government agency that floats about the
water
in big grey boats. We just upgraded our computers to Windows XP and now
are
having problems with our databases.

Currently, in this office, I am the creator of a document tracking
database
created in Access 2003. It is hosted on a shared network located off-site.
Previously, under the reign of Windows 2000, The personnel within the
office
were all able to access the database simultaneously without complications.

Now after the WinXP switchover, When one person has the database open,
nobody else can open it. They will double-click on the icon, and nothing
happens. Access will not attempt to load, and no error messages or dialogs
of
any kind show up.

The one exception is myself. I can open the database at will regardless of
who is in it, but again, nobody else can open it at that time.

The steps I have taken are thus:

Under the file properties Security Tab, all users have full control of the
file.

In the DB, I have gone to Tools>Options>Advanced and under "Default Open
Mode" "Shared" is selected. This is the only advice out IT people could
give.

Any help will be appreciated. Thanks!
Click to expand...

The first thing I'd advise is splitting the db:

http://www.granite.ab.ca/access/splitapp/index.htm

Give each user their own copy of the FE.

There are also "features" you should turn off, such as Name AutoCorrect:

http://allenbrowne.com/bug-03.html

Keith.
www.keithwilby.com
 
Splitting the database isn't a viable option in our environment, and the name
auto-correct doesn't help. Are there any other suggestions I could try? Why
would this have worked before in Windows 2000, but not now in Windows XP?
 
"Aaron Slater, Navy Region Northwest"
Splitting the database isn't a viable option in our environment,
Click to expand...

Sorry, but I can't think of a single instance where splitting would not be
an option in a network environment. If delivering the FE to your users is a
problem then you could have the application shortcut run a batch file to
copy the FE to the user's profile and then launch it. It's a tried and
tested approach that works flawlessly for me.
and the name
auto-correct doesn't help.
Click to expand...

Did you turn it off? Did you address the other "features" of A2003?
Are there any other suggestions I could try?
Click to expand...

Not that I can think of.
Why
would this have worked before in Windows 2000, but not now in Windows XP?
Click to expand...

The OS isn't the issue. Having multiple users access the same file over a
network just isn't the way to do it.
 
Aaron Slater, Navy Region Northwest
Splitting the database isn't a viable option in our environment,
Click to expand...

Why not? This is strongly, strongly urged by everyone within the
Access community. And we can find the odd reference somewhere within
the Microsoft website.

I'd change employers. Oh right, you're in the Navy.

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/
 
Tony Toews said:
Why not? This is strongly, strongly urged by everyone within the
Access community. And we can find the odd reference somewhere within
the Microsoft website.
Click to expand...

Or did we already have this discussion a few weeks ago? I can't
recall.

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/
 
Back
Top