Solved

Read Only Attach Table in Access2?

Posted on 1997-10-22
8
304 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
  • 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

828 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