Sharing a database

O

Owltrax

Hi,

I need help! I am a novice at this. I have a database that is on a shared
drive. The database has been split, however, I think I may have done it
incorrectly because I put both the FE & BE in the same folder on the shared
drive. The database does not have security assigned as security to me is very
complicated.

My question is - when two people try to get into the database at the same
time, they get an error message saying that the database is "read-only". Only
one person at a time can input. I want to be able to have two people input at
that same time. Is this possible? I checked the database open default mode
and it is set to "shared". Is it because the FE & BE are in the same folder
on the same drive? And if so, HOW do I fix that? Do I just need to copy the
FE and put it on their hard drive? Or, do I have to set up some kinda of
security?

Any help would be greatly appreciated!
Kat
 
M

Matt

Check on the options settings in the database. There is one for shared or
exclusive when it is opened.
 
M

Matt

Check the security permissions of the shared drive. Does only 1 specific
user receive there error? For instance – if the 2 user are Mary & Tom, based
on the scenarios below – which applies to you?

1) Tom opens db first – Mary receives error, Mary opens db first – Tom
receives error.
2) Tom opens db first – Mary receives error, Mary opens db first – Tom DOES
NOT receives error.
3) Tom opens db first – Mary receives error, Mary opens db first – Mary
receives error.

How are you opening the db? Via a shortcut? Any special code that runs
when the db is open?
 
O

Owltrax

Scenario # 1 is what is happening.

Because the drive we are using is shared by the whole company, any folders
that are put there are secured by our IT department and I have to tell them
that it's okay for a user to get into the folder that the database is in and
then they make it so the user can get into the folder.

How we open the db - the users click on the regular icon (no shortcut) and
the input form they need comes up. They can only see that form. They do not
have access to be able to "create" forms, queries, or reports, however there
is a switchboard that they can bring up that will allow them to "use" the
queries and reports I've created.
I get into the db by clicking on the regular icon (no shortcut), but hold
the shift key down so that I can get to all the objects.

I have written some code in the db, but no special code when the db is open.

I really appreciate your help!
Kat
 
M

Matt

The Default open mode resides on the Application level and not the database
level. Which means you need to set the option for “shared†at each PC using
the database.

If that is not the issue then try copying the FE to a folder locally on each
PC. This would mean each user has their own FE.
 
O

Owltrax

Thanks Matt! I REALLY appreciate your help!
Kat

Matt said:
The Default open mode resides on the Application level and not the database
level. Which means you need to set the option for “shared†at each PC using
the database.

If that is not the issue then try copying the FE to a folder locally on each
PC. This would mean each user has their own FE.
Click to expand...
 
Top