Re: Access SQL Server Express over the Internet

Helmut Woess schreef:

The server is SQL2005 and we are using certification and a special port and
name for the instance. Never had any safety-, speed- or ressource problems.

You have the security end probably covered, but I find it difficult to believe that you don't have performance problems, unless you don't query that database very often.

Obvious advantages of any xml/rpc or soap or home-brew xml solution:

- decoupling of the front end and back-end. You can change one end without having to change the other end => less deployment problems when upgrading
- you don't have to configure database connections and database middleware on the clients => less deployment problems
- you can add any logic at the back-end that you like
- you can do content-checking at the back-end to increase security
- you can aggregate several result sets into a single request if round-trip time becomes a problem

Danny
---



.

Relevant Pages

  • User Level Security with a Front-End/Back-End Solution
    ... function to refresh the links to the back-end database. ... Permissions for the linked tables in the front-end was set to read, update, ... database the name is the same but the security is in a .mdw file I don't ...
    (microsoft.public.access.devtoolkits)
  • Re: Access security best practice - Stupid question(s) #2
    ... Andy. ... I'm not sure why you chose to put a database ... password on your back-end, but there probably isn't any harm in it -- as ... I've ready through the various security FAQ and I think this ...
    (microsoft.public.access.security)
  • Re: setting a password on a button on the switchboard
    ... Could you send me the sample database for the fourth option (4. ... > Security in an Access database can probably be broken down into two big ... > points about being easier than User Level Security, ... > What type of data are you trying to protect? ...
    (microsoft.public.access.forms)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)