Hi, Jetera.
Is there anyway to update the database that has been distributed as a
runtime after the runtime has been installed? For example - the client now
wants a report to be sorted differently.
This type of change cannot be made with the Runtime version of Access,
unless you've previously programmed the capability to change the SQL property
of the QueryDef object (if this is the report's record source) or the SQL
statement in the report's Recordsource property. If you haven't designed the
application with this in mind, then a retail version of Access will be needed
to modify the sort order. If the client can't find a retail version of
Access, then you'll need to make the modification and redistribute the
application to the client.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
