× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Evan,

If your talking about linked tables with access I guess you have DB2
connect.

Access with a linked table would be the easiest thing to code. However,
your going to need to store the name and password for the ODBC link. For
security I would write a small web app in PHP, served over SSL.

Justin

On Thu, May 28, 2015 at 8:24 PM, Evan Harris <auctionitis@xxxxxxxxx> wrote:

Hi Jon

the thing that made me think of this just happened to be a validation list
- but that is handy to know.

I think I would like to have some general kind of Grid style interface
where I could just connect to a table for ad-hoc maintenance.

If I was gong to go green screen I would probably just settle for DFU as I
don't believe what I want to achieve needs to be much smarter than that -
just a general approach interface into a table.

On Fri, May 29, 2015 at 11:35 AM, Jon Paris <jon.paris@xxxxxxxxxxxxxx>
wrote:

Giovanni has utilities which include Validation List maintenance. Comes
with full source code so you could use it as a foundation if you needed
more that the standard offering.

http://www.easy400.net/webact/start

I think you have to be a registered user to get to that section of the
site.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 28, 2015, at 7:26 PM, Evan Harris <auctionitis@xxxxxxxxx> wrote:

Hi all

OK, "Best" is probably subjective, but a scenario that came up for me
this
morning had me wondering what the possible approaches to solve an
administration challenge were.

Situation: I have inherited an application that uses authorisation
lists
to
determine whether users are permitted to access certain menu items. I
would
like to make this as "Self service" a function as possible.

My thinking was that rather than give people command line access on a
green
screen I could create a table and based on adds and deletes to that
table
use a trigger to either add or remove users to the required
authorisation
list.

That set me to thinking: what would be the best way to allow people to
administer a table on the i.

I could for instance link a spreadsheet, or an access database or a SQL
Server database and use their in-built GUI tools.

Some of the tooling in Ops Nav would work but then that opens up a
whole
other can of things to lock down.

Using something like Squirrel to access the table is not out of the
question, but I have not thought through how I would limit the access.
Maybe I could create a library and let people administer various table
sin
there.

What other ways could I do this, especially if access via a web browser
was
the preferred approach.

I don't want to build a CGI program for every use-case, I would much
prefer
to have a general approach where I could have something like a grid
presented to people to do simple admin on a table.

I am curious what options others have come up with and used.


--

Regards
Evan Harris
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




--

Regards
Evan Harris
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.