New to Servoy: feature assistance

Classic Servoy
1

Hello folks,
In looking for a frontend for a multiuser/multiplatform environment via TCP/IP, I have some requirements and would like to know if Servoy solutions can be configured/used to do all of the following:

  1. frontend uses a local file (tab-delimited or other) or embedded database and buttons on frontend permit the synchronization of data with backend
  2. frontend a template system whereby username/password are passed to backened database for permission to access/modify tables owned by individual clients (i.e. no need to create a frontend for every client or to duplicate all the usernames and password in both the Servoy server and the backend database)
  3. frontend template can be updated or changed and pushed from server (e.g. announcements pushed from server appear in all client frontends)
  4. pass-through queries can be performed via buttons on frontend

Thanks for any support here. I am currently making use of compiled Access databases for my client’s frontend that can do all this through the embedded vbscripts, but I now need to bring Mac users into the fold. Please note that I need all of the above features for a solution to work.

Thanks,

Dave

2

Hi Dave,

I find your description of what you need a bit confusing, but that may be because I don’t know Access. Why do you need the separate front-end database? Do your users go off-line?

If you are looking for a tool which will allow you to deploy a multi-user database, cross-platform, with some different access-privileges for different user groups… then Servoy is a very good choice.

Note that you don’t need to install any software client on the users computer, Java Webstart takes care of making sure the user always have the latest version.

3

swingman:
Hi Dave,

I find your description of what you need a bit confusing, but that may be because I don’t know Access. Why do you need the separate front-end database? Do your users go off-line?
quote]

Yes, that’s exactly what I need to do. Users MUST be working off-line 90% of the time whereas the only time they should be online is to synchronize or upload new entries with their own table in the backend. There are several reasons for this, the primary being disaster recovery. I am running a nonprofit backend and haven’t got a lot of expendable income. So, part of the financial solution was to devise such a system rather than have clients work online all the time.

What I can’t also figure out is how one could develop a module or template-like frontend that dynamically connects to a backend table depending on what is entered in a Username/password form. In other words, all my clients have their own table and I want to make only one solution that will permit connection to any of these tables depending on the username/password combination. It looks to me like a solution MUST establish this connection to the backend table before anything can be done. This last requirement is absolutely essential for me; I don’t want to make a solution for every client.

Dave