Sharing not working

[TVining]

I have several databases that need to be available for multiple users.

I know that we aren't supposed to permit several users into the main database, and I normally build frontends, but I have a DBA and NETADMIN standing in the way.

However, when one person is in the databases, it locks them up completely, and clicking the icon only yields an hourglass, no errors and no database. After 10 seconds, the hourglass clears.

Since Access CAN allow multiple users, why WONT it? something I need to change?

Thanks,
Tony

[Stewart Ross]

Hi. Difficult to give a definitive answer without knowing all the circumstances. What is for sure is that all users must have read-write-create rights to the directory in which your Access database resides. Without these rights Access cannot create its .LDB lock file. No .LDB file = no multi-user capability.

You can easily check in the directory concerned - when a user starts Access you should see a corresponding .LDB file appear in the same directory, which will be deleted automatically when all users have closed the DB. If you don't see it when at least one user has the DB open then there is clearly some kind of access rights problem.

-Stewart

[missinglinq]

I know that we aren't supposed to permit several users into the main database, and I normally build frontends, but I have a DBA and NETADMIN standing in the way.

So exactly how are you doing it now? One un-split file, on a server, that everyone is trying to access? Or something else?

What are your Default Record Locking settings when you go to

Tools - Options - Advanced?


As Stewart said, we need more information in order to help you.

Welcome to Bytes!

Linq ;0)>

[TVining]

With these particular databases:
Both are on a shared server.

One of them is read-write-mod enabled for all. I will check the DBA's default open and make sure it is shared mode.

The other is read-only for most folks. We can't have anyone changing data in it, and using DB logins is not a good option for it. (We honestly DO have enough passwords)

Tony