PC Review


Reply
Thread Tools Rate Thread

Access 2007 Read Only Issue

 
 
Marsh
Guest
Posts: n/a
 
      6th Feb 2010
One of the groups in my company has an MDB file that they are running in
Access 2007. Somehow it has not been converted. It will be converted once I
can isolate the following problem;
When I open the file on my computer, it opens with no problem,
When one of the user group opens it, it opens read only.
Question - Is there a setting that could be selected on all of there
computers that is not selected on mine that would cause this.
If not, what should I look for to correct this.
As soon as this is resolved, I will convert and split this db file into a
Front and Back End convifiguation.
Many Thanks
Marsh
 
Reply With Quote
 
 
 
 
Ed Robichaud
Guest
Posts: n/a
 
      6th Feb 2010
2 possibilities:

-Many CD burning programs make the files on disc read-only (if that's how
you're distributing the MDB). You can right-click on the file name (in
explorer), select properties, and uncheck the read-only box.

-Most version of Access (after the security updates) now treat any
non-native MDB as suspicious. You can right-click on the file name, select
properties, and "unblock" the file.

With 2007, you'll also need to add the resident folder of the MDB to your
"trusted sites" list.


"Marsh" <(E-Mail Removed)> wrote in message
news:765B4004-9B5F-4E92-AAE7-(E-Mail Removed)...
> One of the groups in my company has an MDB file that they are running in
> Access 2007. Somehow it has not been converted. It will be converted
> once I
> can isolate the following problem;
> When I open the file on my computer, it opens with no problem,
> When one of the user group opens it, it opens read only.
> Question - Is there a setting that could be selected on all of there
> computers that is not selected on mine that would cause this.
> If not, what should I look for to correct this.
> As soon as this is resolved, I will convert and split this db file into a
> Front and Back End convifiguation.
> Many Thanks
> Marsh



 
Reply With Quote
 
Marsh
Guest
Posts: n/a
 
      7th Feb 2010
Thank you, will try these suggestions

"Linq Adams via AccessMonster.com" wrote:

> Also, in addition to Ed's suggestions, where is this database residing? Do
> each of the users have a copy of the db on their hard drive? Or is there one
> file on a shared drive? If so, do the other users have Write privileges to
> the folder where it resides?
>
> --
> There's ALWAYS more than one way to skin a cat!
>
> Answers/posts based on Access 2000/2003
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...arted/201002/1
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Read-ony issue read-only file status issue in excel Microsoft Excel Misc 0 17th May 2010 04:50 PM
Why Access 2007 donot have the "Data Access Page" Function ? How I can do with 2007 for this issue ? Martin Microsoft Access 4 3rd May 2010 08:46 PM
Ms Access 2007 and Ms Sharepoint 2007 (Issue with Attachments) scott Microsoft Access VBA Modules 2 8th Apr 2010 09:23 PM
very basic MS access 2007 (button click no read issue) loc_p Microsoft Access VBA Modules 1 16th Dec 2009 05:42 PM
MS Access 2003 / 2007 Runtime - is read only or read/write possibl =?Utf-8?B?S0U=?= Microsoft Access 3 20th Mar 2007 06:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:55 PM.