Post reply

Forms or a solution for end user data entry?

  • October 19, 2007 at 3:18 am

    #180470

    Hey folks,

    Just wondering if anyone can suggest a solution (preferably free) for end users to enter data into SQL Server. I have some end users who need something simple, just basic forms really, maybe something web-based as it would have to be done remotely.

    To explain the scenario further, this is what we have set up: a small standalone box running Server 2005 on Windows 2000. I can only access this box via "VNC Server for Windows", and I had initally built a little Access app on the standalone box to use for data entry. However, I am loathe to start giving the VNC program out to the users, and would prefer if they could use my Access app from their own desktops and talk to the box. Been unable to make this happen thus far, keep getting the error:

    [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied

    Can anyone offer some suggestions as to how I can get them entering data? I would appreciate hearing how you guys do things.

    Thanks in advance.

  • October 20, 2007 at 6:40 pm

    #743891

    If you only want them to connect via VNC, then you're in tough shape.

    If you want to use it like a Server, then you need to setup users and have the Access app connect to the server... that mean the Access app is gonna need to be either distributed or on a common drive somewhere and every user will need a copy of Access.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply