Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Shared Access 97 DB 2

Status
Not open for further replies.

mrkshpntf

MIS
Apr 19, 2007
92
US

I have a shared Access 97 database. It is supposed to be used by 6 users.

I can open the database and update it at my computer. But, when I try to open it from any of the user computers, I get the message that it will open only as Read-only.

Is there a way to share this DB completely among the 6 users?

Please Help.

Thanks,
mrkshpntf

 
Check your "Default Open" Mode on your client MDB/MDEs. Make sure you do NOT have it set to "Exclusive" mode.

Gary
gwinn7
 
Have you split it into front- and back-ends?
 
Or, did you use the intrinsic Access Security Features?

Gary
gwinn7
 
Have you thought about switching database platforms?

<joke, but only part kidding>

If so, switch to PostgreSQL!

Gary
gwinn7

 
gwinn7
That would still require a front-end, would it not? So why not stick with an Access back-end?
 



gwinn7,

Thanks for your response.

The setting on "Default Open" mode is shared but it still says that it will open the DB is read-only mode
 


Remou,

I am using Access 97. My version doesn't have database splitter function installed.

Thanks,
mrkshpntf.
 
Yes, you would need Access or another front-end client app, but you could still utilize the powerful features of a free RDBMS (i.e. stronger subselect support, table rules, triggers, server-side functions, customizability, extensibility, etc).

I am sure the Access 97 app he has is quite adequate. I was simply putting a light-hearted plug for Postgres.

Gary
gwinn7
 
I am surprised, a splitter should be available Tools->Add-ins->Database Splitter, according to what I have read. You will need to split the database into tables (BE) and code (FE) the FE copy needs to have the BE tables linked in and it should be distributed to each user.
 
mrk,

Check the permissions on the folder you are sharing out to your users. Are you sharing the MDB on a Linux, or Windows System?

Gary
 
You don't need to split a database for multi-user support. The problem is likely related to something else.

Gary
 


Remou,

Yes I found the splitter and used it. Splitting the DB created two files, one with original name of the DB and the other with a '_be' added to the original name.

The DB is stored in a common folder. Do I need to place a local copy of the front-end on each users computer?


Gary,

I haven't secured the DB. It is used for very routine, non-critical work. I am sharing it on Windows XP platform.
No permissions have been set.

The users can open all forms to view but cannot enter anything. One of the forms has been designed for adding data to the underlying table but it appears completely blank (all the text fields and buttons do not appear).


Thanks,
mrkshpntf.
 
Splitting a database for multi-user access is a good thing, but it is missing the point on your original issue.

Multi-user concurrency can be used whether everyone has a short-cut to the MDB, directly double-clicking the shared MDB, or everyone clicking their own MDB/MDE (FE) linked copy to your shared MDB. Technically, it should all work.

Just because you haven't set any permissions on the share, doesn't mean they are automatically set properly. I would carefully check those share permissions. If you are running XP on NTFS, you should check your file permissions on that MDB as well. Though your share permissions may be set for read/write, your NTFS permissions may need adjusting.

Gary
gwinn7

 
Obviously all 6 users open the DB with access 97, doesn't it ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 

Gary & Remou,

I had placed the DB in a folder where the users had read-only permissions.

I moved the DB to a common folder where all users have read write permissions. They all can use the DB now.

Thanks for your suggestions and help.

mrkshpntf.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top