Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2003
    Posts
    33

    Unanswered: Access DB on the internet? ...and "Memo" question

    Ok, two questions...

    1) Can an Access database be put up on the internet (web server) somehow so that multiple people can access it?

    2) I'm trying to create a history field (log) in my database and then append information to it but I'm getting an error.

    On my form I have a couple of text fields and my text box.

    My text fields are linked to "Text" fields in my table and my text box is linked to my "Memo" field in my table.

    How can I append my text field information to my text box?

    ...even better would be a way to append information to the *beginning* of the text box.. (eg. newest events would appear at the top of the text box, oldest events at the bottom)

  2. #2
    Join Date
    Oct 2003
    Posts
    33
    bump

  3. #3
    Join Date
    Aug 2003
    Posts
    48
    1) Access 2000 and later support "Data Access Pages", these can allow data from your databases to be accessed on the web.

    You should investigate them further, or preferably use ASP if your web server supports it.

    I'm fairly new to Access, etc - so you'll need a more advanced user to answer your other questions.

    Hope any of this is useful to you!

    Cheers,

    Luke

  4. #4
    Join Date
    Oct 2003
    Posts
    33
    Thanks for the reply...

    However, data access pages require that you create new HTML forms and such to access the database.

    I already have a bunch of Access forms that I would like to use. All I really want is store store the database table on a webserver but keep the forms setup locally.

    EDIT: Could I have Access XP use a MySQL database on the internet for table access? (but again, I would like to keep the forms stored locally)

    Any way to do that?

    Also, anybody know how to do what I mentioned above with memo fields?

  5. #5
    Join Date
    Oct 2003
    Posts
    706

    Re: Access DB on the internet?

    [i]
    1) Can an Access database be put up on the internet (web server) somehow so that multiple people can access it?
    While MS-Access can be used for this, it would not be my first choice. Web-access can yield high volumes which Access might not handle as well.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  6. #6
    Join Date
    Feb 2003
    Location
    @ home
    Posts
    163

    Re: Access DB on the internet? ...and "Memo" question

    Originally posted by sofakng
    Ok, two questions...

    1) Can an Access database be put up on the internet (web server) somehow so that multiple people can access it?

    2) I'm trying to create a history field (log) in my database and then append information to it but I'm getting an error.

    On my form I have a couple of text fields and my text box.

    My text fields are linked to "Text" fields in my table and my text box is linked to my "Memo" field in my table.

    How can I append my text field information to my text box?

    ...even better would be a way to append information to the *beginning* of the text box.. (eg. newest events would appear at the top of the text box, oldest events at the bottom)

    Q1 - Yes just use a connection string or ODBC or DSN file

    Q2 - Can you send the error message

  7. #7
    Join Date
    Oct 2003
    Posts
    33
    Ok, the error I'm getting is this:

    Run-Time Error 438
    Object doesn't support this property or method

    Here is the code for the line causing the error:

    Code:
            
    historyStr = histroyStr & Me.actionTaken5
    historyStr = histroyStr & Me.dateActionTaken5
    historyStr = historyStr & timeActionTaken5
    historyStr = historyStr & "\n"
    Me.oldhistory = Me.oldhistory & historyStr
    historyStr is a string (obviously)
    actionTaken5 is a Text field
    dateActionTaken5 is a Date/Time field
    timeActionTaken5 is a Date/Time field
    oldhistory is a Memo field

    What am I doing wrong?

  8. #8
    Join Date
    Feb 2003
    Location
    @ home
    Posts
    163
    Why you are using the Me in thes line?
    Me.oldhistory = Me.oldhistory & historyStr


    Originally posted by sofakng
    Ok, the error I'm getting is this:

    Run-Time Error 438
    Object doesn't support this property or method

    Here is the code for the line causing the error:

    Code:
            
    historyStr = histroyStr & Me.actionTaken5
    historyStr = histroyStr & Me.dateActionTaken5
    historyStr = historyStr & timeActionTaken5
    historyStr = historyStr & "\n"
    Me.oldhistory = Me.oldhistory & historyStr
    historyStr is a string (obviously)
    actionTaken5 is a Text field
    dateActionTaken5 is a Date/Time field
    timeActionTaken5 is a Date/Time field
    oldhistory is a Memo field

    What am I doing wrong?

  9. #9
    Join Date
    Oct 2003
    Posts
    33
    Me refers to the form that it's on, right?

    Like when I move the information from one textfield to another... (example: Me.txtField1 = Me.txtField2)

    ...or am I doing something completely wrong?

    I'm very new to Access (VB) programming. I am experienced with C++ and Java though.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •