Goddy-
Ah! Thanks for posting the solution. Many of us don't realize that newer operating systems require files to be put in non-restricted folders.
It probably wouldn't be a bad idea to to search on the internet for the preferred locations. I would think that an Access database file should be the user's AppData folder, but don't hold me to that.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, Goddy Erile <goderil0@...> wrote:
>
> Thank you for your responses. While running the Package Solution Wizard for Access 2007, I selected"C:\Program Files" as the default installation folder. In Windows Vista, Program Files directory is read-only (as indicated in the wizard). This attribute made the database read-only. I have chosen another location and the program is running as expected. Many thanks for your time.
>
> Goddy Erile
>
>
>
> ________________________________
> From: John Viescas <JohnV@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Monday, April 16, 2012 5:59 PM
> Subject: RE: [MS_AccessPros] Re: Runtime MsAccess Error
>
>
> Â
> Is the database installed in a "trusted" location for 2007? Does the user have
> full authority to the folder? If the answer to either of these is no, then
> that's your problem. You should be able to make changes to the Connect property
> of existing tables in code.
>
> John Viescas, author
>
> Microsoft Office Access 2010 Inside Out
>
> Microsoft Office Access 2007 Inside Out
>
> Building Microsoft Access Applications
>
> Microsoft Office Access 2003 Inside Out
>
> SQL Queries for Mere Mortals
>
> <http://www.viescas.com/> http://www.viescas.com/
>
> (Paris, France)
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Monday, April 16, 2012 4:56 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Runtime MsAccess Error"
>
> Firstly, the Runtime does not support design changes to anything. That's just
> the nature of the beast.
>
> The message says you can make data changes (i.e. add records, delete, update) so
> the application should be operational.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "goderil0" <goderil0@>
> wrote:
> >
> > Hello All,
> >
> > I installed a program developed and packaged in Access 2007. The program has a
> procedure to relink tables to a backend database on first run.
> >
> > When I ran the program on the client's system running Windows 7, I saw the
> following message on the Ribbon:
> >
> > "This database has been opened read-only. You can only change data in linked
> tables. To make design changes, save a copy of the database."
> >
> > It was designed to run using Access Runtime files but has failed to run due to
> the massage indicated above.
> >
> > Can anyone help me with this?
> >
> > Thanks.
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar