You are not logged in.

#1 2013-07-11 15:41:13

mixtr
Member
From: Ottawa
Registered: 2007-02-27
Posts: 47

postgresql and ms access query variables

I made a small Access database at work. It got bigger and I'm currently moving it to postgresql and I'm keeping Access as a frontend.
One useful feature of Access is that I can open a report which calls a query with a variable, Access prompts me for a value and execute the query to build the report.

The only way, that I could find, to reproduce a similar effect is to put the query inside a procedure and call the procedure with a parameter. It works fine within postgres and pgadmin but I cannot make it work from Access.

Does anyone have any experience with this sort of thing?

Thanks


-- mixtr

Offline

Board footer

Powered by FluxBB