A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2007 Read Only Issue



 
 
Thread Tools Display Modes
  #1  
Old February 6th, 2010, 06:06 PM posted to microsoft.public.access.gettingstarted
Marsh
external usenet poster
 
Posts: 108
Default Access 2007 Read Only Issue

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
  #2  
Old February 6th, 2010, 10:30 PM posted to microsoft.public.access.gettingstarted
Ed Robichaud
external usenet poster
 
Posts: 90
Default Access 2007 Read Only Issue

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" wrote in message
...
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



  #3  
Old February 6th, 2010, 10:54 PM posted to microsoft.public.access.gettingstarted
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default Access 2007 Read Only Issue

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

  #4  
Old February 7th, 2010, 09:16 PM posted to microsoft.public.access.gettingstarted
Marsh
external usenet poster
 
Posts: 108
Default Access 2007 Read Only Issue

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

.

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.