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@msn.com>
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]
Senin, 16 April 2012
Re: [MS_AccessPros] Re: Runtime MsAccess Error
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar