Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Dumb question from dumb person: HELP PLEASE!!

Discussion in 'Information Technology' started by SirFranky, Jul 28, 2006.

  1. SirFranky

    SirFranky
    Expand Collapse
    Guest

    This is going to sound so stupid. Please be gentle...

    I have an .mdb datasource running my website. I want to be able to connect
    to it from my computer in such a way that i can directly edit the tables,
    add new tables, delete stuff, make minor alterations.

    I know this must be a very easy thing to do but I just can't figure it out
    despite exhaustive efforts. I find myself writing queries in coldfusion for
    the most ridiculous tasks.

    I humbly beg for your expertise.
     
  2. Loading...

    Similar Threads Forum Date
    Islam Dumbest Reasons for Converting to Islam Interfaith Dialogues Apr 21, 2011
    Sikh News Obama: "Punjab" Memo Was A "Dumb Mistake" (CBS News) Breaking News Jun 19, 2007
    General How dumb can you get....batch ke kurio! Hard Talk Mar 10, 2007
    Question About GGS Questions and Answers Aug 28, 2016
    Marriage And Discrimination Related Questions Blogs Mar 21, 2016

  3. dlw

    dlw
    Expand Collapse
    Guest

    Use Microsoft Access to open and edit the .mdb file.

    "SirFranky" wrote:

    > This is going to sound so stupid. Please be gentle...
    >
    > I have an .mdb datasource running my website. I want to be able to connect
    > to it from my computer in such a way that i can directly edit the tables,
    > add new tables, delete stuff, make minor alterations.
    >
    > I know this must be a very easy thing to do but I just can't figure it out
    > despite exhaustive efforts. I find myself writing queries in coldfusion for
    > the most ridiculous tasks.
    >
    > I humbly beg for your expertise.
    >
    >
    >
     
  4. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "SirFranky" <someone@microsaft.com> wrote in message
    news:bwo8g.9$CQ6.8@fe11.lga
    > This is going to sound so stupid. Please be gentle...
    >
    > I have an .mdb datasource running my website. I want to be able to
    > connect to it from my computer in such a way that i can directly edit
    > the tables, add new tables, delete stuff, make minor alterations.
    >
    > I know this must be a very easy thing to do but I just can't figure
    > it out despite exhaustive efforts. I find myself writing queries in
    > coldfusion for the most ridiculous tasks.
    >
    > I humbly beg for your expertise.


    Unless your website is hosted locally -- that is, unless that .mdb file
    is on your local network (not a WAN, not accessed over the internet) --
    you're not going to be able to work with it using the version of Access
    on your computer. Access doesn't work at all well on a WAN.

    I can think of three possible solutions:

    1. Stop the website (or render the database read-only), FTP the database
    down to your local PC, make your changes, then FTP the modified database
    back up to the site and start the website back up again. Obviously,
    this solution doesn't work for websites that have to be up and fully
    functional 24/7, unless those websites are using the database only in a
    read-only mode.

    2. If the web server permits it, set up Terminal Services -- or
    pcAnywhere, or some other remote desktop application -- on the server,
    along with a server installation of Access, so that you can connect to
    the server as a remote terminal and run Access *on the server* from your
    PC. Then you can work with the database using Access, without ever
    bringing the database back down to your PC.

    3. Write a whole set of web pages to provide the kind of maintenance
    functions you require, accessing them via the web site itself.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  5. SirFranky

    SirFranky
    Expand Collapse
    Guest

    "dlw" <dlw@discussions.microsoft.com> wrote in message
    news:63C02D4E-3062-4E1B-B0CF-AD6846A5BA87@microsoft.com...
    > Use Microsoft Access to open and edit the .mdb file.

    whoops should have mentioned it is stored remotely
     
  6. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    > I have an .mdb datasource running my website. I want to be able to connect
    > to it from my computer in such a way that i can directly edit the tables,
    > add new tables, delete stuff, make minor alterations.


    Note the above...you have a mdb datasouce....

    That means you do not nee dot have ms-access installed, nor have installed
    ms-access on that machine.

    So, the first question one has to beg, is this your machine, and does it
    have ms-access installed?

    Remember, every copy of windows ships with the JET data engine, and that
    means you can read data from a mdb file on any machine, and NOT have to
    install ms-access. You can even writ a windows script to read data from a
    mdb file. And, as you pointed out, your coldfusion web site can also use the
    mdb file. But, up to this point WE ARE NOT TALKING ABOUT ms-access at all.
    It has NOT YET come into the picture.

    So, having a mdb data source, and talking about ms-access are TWO COMPLETE
    different things. In fact, since ms-access can be used with sql server, then
    you might not have any data in a mdb file when you use ms-access. ms-access
    is a developers tool..

    ms-access is a developers tool like c++, or vb. You write code and build
    forms,a and connect to a database of your choice.

    So, without question, you can install ms-access on that target machine.
    However, ob obviously to install ms-access it will have to be YOUR machine.

    Since most web providers give you a choice of some type of sql server system
    for next to nothing in cost...why not dump using mdb files...since you are
    not using ms-access now anyway. With a server based sql engine, you can
    remote connect using the client tools provided by the sql server vendor...

    ms-access and a mdb file is a file share system, and unless you have remote
    desktop, or a have a vpn setup, you can't use ms-access as the front end on
    your computer, and grab data from a mdb file on another computer over the
    internet (you *can* use ms-access to connect to a server based system such
    as sql server *over* the internet however). You can read about how this can
    be done here:

    http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html


    So, your question is not dumb, but is a rather COMPLEX and is a question
    that involves MANY internet a and server based technologies to accomplish
    your goal. In fact, a answer to your question will requite more IT knowledge
    and training to accomplish then likely any other question in this newsgroup
    today.

    So, your question is not dumb, and in fact solution will requite a
    considerable amount of information technology skills on your part to
    solve....

    If the machine that the web server is running on is yours, then installing
    ms-access, and using remote desktop would like be the best solution.
    (windows 2000 server and later allows up to two free remote desktop users).
    If the web server machine is not yours, and you can't install software as
    you please on the machine, then you are limited to what solutions your web
    provider company offers. As mentioned, in that case, since you are not
    really using, nor have ms-access installed on the web server, then likely
    you best just use a true server based dataengine/datasouce..as in those
    cases you *can* connect over the internet (most, but not all web providers
    allow some type of ssl connecting to the web server for management - so,
    what type of access you are allowed to the database server will vary from
    provider to provider).

    So, solutions to your problem will depend also much on who runs your web
    server, and what kinds of tools and network access you are allowed to that
    box....




    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     

Share This Page