Solved

Read Only Attach Table in Access2?

Posted on 1997-10-22
8
315 Views
Last Modified: 2008-03-10
Is it possible to make the attach table in Access2 for read-only?  I don't and won't use MDA to set the access constrain.
Many Thanks!!

Tasman :)
0
Comment
Question by:tasman082997
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 1

Accepted Solution

by:
birchallr earned 50 total points
ID: 1957724
Hello,

It is possible to attach to a table in a separate read-only file.  For example, you can attach to tables in a file on a CD-ROM or on a network share where you have read-only access.

However, if it is on a network share where you have read-only access, there can be no other user, with full read/write access, also using that file.  If that is the case then you, the read-only user, are locked out.

The solution is to have a separate copy of the data.MDB file that is for use only by read-only users.  You can have this backed up from the primary data.MDB file once a day or something like that.

Regards,

Richard

0
 

Author Comment

by:tasman082997
ID: 1957725
The data in the attached tables are dynamic, and critical.  They are shared (read/referenced/attached) by more than 15 Access2 databases in my office.  I don't want these databases(users) have a chance  to lock and modified any of the records.  Therefore, I just can't make a copy of the shared database once a day.
0
 
LVL 1

Expert Comment

by:birchallr
ID: 1957726
So I understand you to mean that you have both users with read/write access and users with read-only access, and that it is important that both sets of users have up-to-the-minute data (i.e. the read-only users cannot tolerate one day out of date)?  Is this correct.

If this is the case, you will have to use MS Access internal security, rather than relying on network permissions.

No one will be locked out, if everybody has read/write access to the network share.  Is this on a Windows NT server?

Regards,

Richard

0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

Author Comment

by:tasman082997
ID: 1957727
All the databases are on novell netware.  And I won't and can't create a centralize MDA file for all the users/databases  (I memtioned this restrain at the very first beginning).
0
 
LVL 1

Expert Comment

by:birchallr
ID: 1957728
Hello,

There is some info at:
http://premium.microsoft.com/support/access/content/secfaq.asp

Make sure that the .LDB files are also sharable and that all users have write access to them.

Here is some text that might help,
= = = = = = = = = = = = = start text = = = = = = = = = = = = =
   Normally, the .LDB file must be in a directory where the user has
   read-write privileges. However, it is possible to open a database
   in a directory or device where a user has read-only privileges.
   To do this, select both the Read Only and the Exclusive check boxes
   in the Open Database dialog box. The Open Database dialog box can
   be found by selecting Open Database from the File menu. The
   combination of read-only and exclusive means that users will not be
   updating any database information, so record-locking isn't
   required. Because record-locking isn't required, Microsoft Access
   does not attempt to open or create an .LDB file.
= = = = = = = = = = = = = = end text = = = = = = = = = = = = =

Regards,

Richard

0
 

Author Comment

by:tasman082997
ID: 1957729
I can't set the whole database to be read-only.  I just want the attach tables to be read only (without using DMA file).  thanks!

0
 
LVL 1

Expert Comment

by:birchallr
ID: 1957730
Hello,

I assume you have already split the database.  There is a good explanation of this in the Access manual and online help, as well as a "wizard".

The user has full access to the front-end database file (containing queries, reports, forms, but not data tables), on their hard drive (or personal network area).

The back-end database file (only containing the data tables) would be in a read-only area.

The front-end database file attaches to tables in the back-end file.


Regards,

Richard

0
 

Author Comment

by:tasman082997
ID: 1957731
Thanks a lot, Richard!!


0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question