I'm not sure whether Access provides a method to connect to
external SQL data sources. For another option, FileMaker Pro
can connect to external SQL data sources, what they call ESS.
http://www.filemaker.com/support/technologies/sql.html
FMP provides a very nice desktop UI. I have several clients who
use FMP, creating layouts, scripts, doing field validation,
running queries, generating reports, and lots more, just like
Access provides.
Then for the SQL datasource, just serve as you normally would.
Thus my clients get the best of both worlds: a familiar desktop
GUI they can control, and the world can interact with the same
data through a web interface.
--steve
On 5/23/14 at 2:08 PM, [email protected] (Christian
Ledermann) pronounced:
migrate the backend from access to say postgresql (or another db server)
connect pyramid and access to this serverdb.
his does obviously only work if he can connect to the db server from the
access application (so not from his notebook on the road)
On Fri, May 23, 2014 at 2:02 PM, wilk <[email protected]> wrote:
On 23-05-2014, tonthon wrote:
Hi,
One of our customers is using an access database with a desktop
application as an internal solution.
We'd like to provide him a web access handling the same datas, but he's
tied to his desktop app.
How would you handle this situation ?
I use pyodbc, directly without orm.
--
William
--
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/pylons-discuss.
For more options, visit https://groups.google.com/d/optout.
--
Best Regards,
Christian Ledermann
London - UK
Mobile : +44 7899488511
<*)))>{
If you save the living environment, the biodiversity that we have left,
you will also automatically save the physical environment, too. But If
you only save the physical environment, you will ultimately lose both.
1) Don’t drive species to extinction
2) Don’t destroy a habitat that species rely on.
3) Don’t change the climate in ways that will result in the above.
}<(((*>
------------------------
Steve Piercy, Soquel, CA
--
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/pylons-discuss.
For more options, visit https://groups.google.com/d/optout.
