Prev: Format Date
Next: Datasheet Form
From: Marsh on 6 Feb 2010 13:06
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
From: Ed Robichaud on 6 Feb 2010 17:30
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" <Marsh(a)discussions.microsoft.com> wrote in message
news:765B4004-9B5F-4E92-AAE7-D596F2843790(a)microsoft.com...
> 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


From: Linq Adams via AccessMonster.com on 6 Feb 2010 17:54
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/Forums.aspx/access-gettingstarted/201002/1

From: Marsh on 7 Feb 2010 16:16
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/Forums.aspx/access-gettingstarted/201002/1
>
> .
>
 | 
Pages: 1
Prev: Format Date
Next: Datasheet Form