Concurrent users unable to open a shared Microsoft Access MDB database

Unanswered Question
Apr 6th, 2010

I have a share on a Cisco NSS2000, the NSS is in Workgroup mode (Firmware 1.13).
Every user have read/write rights on this share.
When I try to open an access MDB database from this share it happens that only a single user at time can open the database.
The second user that try to open the database get a "Cannot lock file" error message.
So, when a user has the Access DB opened, no-one other can open (or connect to) the same DB.
It's impossible to open the DB using the access IDE ("Cannot lock file" error message).
It's impossible to make multiple connection to the DB using OleDB ("Cannot lock file" error message).
I've tried give full access to the mdb file.
I've tried give full access to the mdb folder.
I've even tried to give full access to the temporary LDB file.
I always get the same error message.

Is there a workaround?

Thanks, Max

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
catung Wed, 04/07/2010 - 06:23

Max,

Please update your firmware to the latest posted version, 1.16.

Thanks

-carl

--

Carl Tung

SBTG - PE, Storage

From: IsiSviluppo

Reply-To: "[email protected]"

Date: Wed, 07 Apr 2010 00:07:20 -0600

To: Carl Tung

Subject: New message: "Concurrent users

unable to open a shared Microsoft Access MDB database"

catung,

A new message was posted in the thread "Concurrent users unable to open a

shared Microsoft Access MDB database":

https://www.myciscocommunity.com/message/42739#42739

Author : IsiSviluppo

Profile : https://www.myciscocommunity.com/people/IsiSviluppo

Message:

IsiSviluppo Wed, 04/07/2010 - 23:08

Will I loose my data due to the firmware update?

Thanks, Max

catung wrote:

Max,

Please update your firmware to the latest posted version, 1.16.

Thanks

-carl

--

Carl Tung

SBTG - PE, Storage


catung Wed, 04/07/2010 - 23:22

Max,

No, you shouldn't. However, if the NAS is your primary data store, it's

always a good practice to back up data and configuration regularly, and

especially just before a firmware upgrade to guarantee business continuity.

This is the same advice I get regarding any server product, and even my PC

and Mac regarding an upgrade.

-carl

From: IsiSviluppo

Reply-To: "[email protected]"

Date: Thu, 08 Apr 2010 00:09:09 -0600

To: Carl Tung

Subject: New message: "Re: Concurrent users

unable to open a shared Microsoft Access MDB database"

catung,

A new message was posted in the thread "Concurrent users unable to open a

shared Microsoft Access MDB database":

https://www.myciscocommunity.com/message/42925#42925

Author : IsiSviluppo

Profile : https://www.myciscocommunity.com/people/IsiSviluppo

Message:

IsiSviluppo Thu, 04/22/2010 - 23:45

I've finally been able to update the firmware to the latest 1.16.

Now everything works fine, problem solved! :)

Thanks,

Max

catung wrote:

Max,

Please update your firmware to the latest posted version, 1.16.

Thanks

-carl

--

Carl Tung

SBTG - PE, Storage

From: IsiSviluppo <[email protected]>

Reply-To: "[email protected]"

<[email protected]>

Date: Wed, 07 Apr 2010 00:07:20 -0600

To: Carl Tung <[email protected]>

Subject: Small Business Network Storage New message: "Concurrent users

unable to open a shared Microsoft Access MDB database" YbIMb-16E-b7l

catung,

A new message was posted in the thread "Concurrent users unable to open a

shared Microsoft Access MDB database":

https://www.myciscocommunity.com/message/42739#42739

Author  : IsiSviluppo

Profile : https://www.myciscocommunity.com/people/IsiSviluppo

Message:

Actions

This Discussion

Related Content