Working with an existing MS Access database

[tonthon]

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've seen there was an sqlalchemy-access dialect, but I don't know if
it's usable)

Thanks in advance for your feedbacks

Cheers

Gaston

[wilk]

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

[Christian Ledermann]

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)

--
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 pylons-discus...@googlegroups.com.
To post to this group, send email to pylons-...@googlegroups.com.
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]

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, christian...@gmail.com (Christian
Ledermann) pronounced:

------------------------
Steve Piercy, Soquel, CA