Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Read Only Attach Table in Access2?

Posted on 1997-10-22
8
Medium Priority
?
332 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 200 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

824 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