Results 1 to 5 of 5
  1. #1
    Tessimisst is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Oct 2016
    Posts
    2

    Access and html

    Hello everybody,

    I hope you are all well.

    I am new here and would be glad if you can help me further.
    I am Access Programmer with VBA. In addition, I have programmed a html page.
    Now I have a simple sounding desire, but can not make it.
    On my html page I would like to link a text (ID). When I click this ID,
    This data record (ID) is to be displayed in an already opened access database (Access 2000). Each record in Access has a unique ID, which is then found on the html page. Is there a way to combine Access and HTML, perhaps via Java Script?

    I hope I have explained my problem sufficiently.



    Many thanks for your help!

    Many greetings, Sebastian

  2. #2
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Anyone who has the ability to view this web page also has file permissions to the folder where the database resides? That would be impressive for sure.
    Is the db on a network or is this a SharePoint thing?
    The ability to open a database from a browser sounds like a heck of a security hole...
    Would a data access page suit your needs? (don't ask me to elaborate - I've never had to use them; you'll have to research it).

    If the database was not open, I'd say use a command line argument. If that sounds feasible, look here.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    altylets1974's Avatar
    altylets1974 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2016
    Location
    Fort Wayne, IN
    Posts
    3
    It is interesting info, I've heard first time about it.

  4. #4
    Tessimisst is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Oct 2016
    Posts
    2
    Hello everybody,

    Thanks for the answers!

    The web page resides on a local server, this can only be accessed internally.
    The same is true for the Access database.
    Anyone who can access the database can access the web page.
    A data page does not really help, even the command line.

    The database is opened and only the record should be changed.
    I do not know if it is possible to access Access with Java Script at all.

    I would still be grateful for any further advice.

    Best wishes!

  5. #5
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    An article here that you might find interesting. I seems to indicate that for security reasons, what you want is not possible (the sandbox part). On the other hand, this one might indicate that IE is a .COM member (section on security). This page might shed some light on how to instantiate an Access session should you get that far. If you Google "browser automation of ms access" you will get far more results about automating a browser from Access than you will the other way around, which is what you want.

    I don't remember much of my JavaScript, but would venture to say it's more likely you'd find a way to integrate a browser session with Access via VBscript on the web server side. That's about all I can offer since my own searching on the subject, while done out of curiosity, won't ever be used by me. I'm sure all of us in the forum would really appreciate it if you came back later and posted your findings, or even better, your solution.
    Good luck!
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. MS Access with HTML Front End
    By BusinessTX in forum Forms
    Replies: 0
    Last Post: 10-17-2016, 10:50 PM
  2. Email HTML using Access
    By Ruegen in forum Access
    Replies: 2
    Last Post: 08-24-2014, 11:52 PM
  3. How to connect MS Access with HTML page
    By selvakumar.arc in forum Access
    Replies: 1
    Last Post: 05-12-2014, 04:13 PM
  4. HTML Mail sent from access
    By mari_hitz in forum Access
    Replies: 3
    Last Post: 09-20-2012, 06:08 PM
  5. HTML body in Access 2007
    By amangupts in forum Forms
    Replies: 4
    Last Post: 12-19-2011, 05:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums