Read Only Attach Table in Access2?

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 :)
tasman082997Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

birchallrCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tasman082997Author Commented:
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
birchallrCommented:
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

tasman082997Author Commented:
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
birchallrCommented:
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
tasman082997Author Commented:
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
birchallrCommented:
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
tasman082997Author Commented:
Thanks a lot, Richard!!


0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.