Sharing a database

[suemack]

I want different users to be able to open my database at the same time. My database is on our network server. I thought that by splitting the db into a front end with forms and queries and a back end with tables would do the trick but it doesn't. I set my advanced properites under the tools menu to Default open mode to Shared and I also set the default record locking to No Locks. But everytime someone has the front end of the db open and another user tries to access it they get the error message : could not access; file in use. Is there any way I can allow more than one person to open the same file without using an SQL server or having to create several copies of the same front end?
Note, I read some other postings but none seem to address this exact problem.

 

[neileg]

I'll let the clever people follow up on this, but if all you need is a simple shareing, you don't need to split. As long as all your users can see the database directory and have read/write permissions under your network o/s then the database can be opened and used by more than one user.

 

[suemack]

That's what I have been told but it like I said, everytime a 2nd user tries to access the file, they get an error saying the file is already in use.. All users involved have full rights (including read/write) on the network OS. We are on a Novell network.

 

[neileg]

Look in Microsoft support Q202171

Users need create rights as well as read write.

 

[Autoeng]

Are you working on the db stored on you PC and then loading to the server location? Are you sure that after changind Default Open Mode to Shared that you copied the db back to the server?

 

[suemack]

I figured it out!!

FYI- thanks for the replies..

I found that the under the Netware properties there is an attributes section with the option to make the file Sharable. Once I clicked that my users were able to access the file at the same time!