Welcome to SPN

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

Sign Up Now!

Maps with Access

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

Tags:
  1. This Guy

    This Guy
    Expand Collapse
    Guest

    What program can I use to draw my own territories over counties on a map and
    link those drawn territories to my access database? I have tried MapPoint,
    but as far as I can tell, you cannot link to a drawn territory, only
    predifined ones by Zip, or county, etc. (By the way, Microsoft, if you're
    listening, we need to be able to do this.) I want to have a map of counties,
    then draw my own territories over the counties and assign each a number. I
    will link that number to one in my database and when I run the cursor over
    that territory, or click on it, I get the data on that territory.

    Any help is much appreciated. Thanks.
     
  2. Loading...


  3. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

    Mappoint has an Olap Connector to do exactly what you want to do.

    MDB is for babies; use a real database and maybe you'll get
    functionality from the 90s and this millenium.

    MDB is for drunken idiots and anyone that uses it today should be fired
    on the spot.


    it's just not reliable enogh.
    it doesn't scale.

    not well enough for a single record and a single user.



    This Guy wrote:
    > What program can I use to draw my own territories over counties on a map and
    > link those drawn territories to my access database? I have tried MapPoint,
    > but as far as I can tell, you cannot link to a drawn territory, only
    > predifined ones by Zip, or county, etc. (By the way, Microsoft, if you're
    > listening, we need to be able to do this.) I want to have a map of counties,
    > then draw my own territories over the counties and assign each a number. I
    > will link that number to one in my database and when I run the cursor over
    > that territory, or click on it, I get the data on that territory.
    >
    > Any help is much appreciated. Thanks.
     
  4. This Guy

    This Guy
    Expand Collapse
    Guest

    Where can get this Olap Connector? I can't find it on Microsoft.com. And I
    agree with you for the most part about MDB, but it works for simple
    applications, especially for users who are not very computer savvy.

    Thanks.

    "aaron.kempf@gmail.com" wrote:

    >
    > Mappoint has an Olap Connector to do exactly what you want to do.
    >
    > MDB is for babies; use a real database and maybe you'll get
    > functionality from the 90s and this millenium.
    >
    > MDB is for drunken idiots and anyone that uses it today should be fired
    > on the spot.
    >
    >
    > it's just not reliable enogh.
    > it doesn't scale.
    >
    > not well enough for a single record and a single user.
    >
    >
    >
    > This Guy wrote:
    > > What program can I use to draw my own territories over counties on a map and
    > > link those drawn territories to my access database? I have tried MapPoint,
    > > but as far as I can tell, you cannot link to a drawn territory, only
    > > predifined ones by Zip, or county, etc. (By the way, Microsoft, if you're
    > > listening, we need to be able to do this.) I want to have a map of counties,
    > > then draw my own territories over the counties and assign each a number. I
    > > will link that number to one in my database and when I run the cursor over
    > > that territory, or click on it, I get the data on that territory.
    > >
    > > Any help is much appreciated. Thanks.

    >
    >
     
  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    This Guy <ThisGuy@discussions.microsoft.com> wrote:

    >Where can get this Olap Connector? I can't find it on Microsoft.com. And I
    >agree with you for the most part about MDB, but it works for simple
    >applications, especially for users who are not very computer savvy.


    Aaron has his opinions which he stridently posts.

    I guess we won't tell my client who has 25 users in the Access
    database all day long that Access doesn't work. 160 tables, 450
    forms and 350 reports. Nope, it doesn't work for them at all.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  6. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

    no tony; it doesn't work well enough.

    how long does it take your customer to open the db from start to
    finish?

    does it run 'across a network'

    ive heard a billion people say that running access across a network
    slows things down considerably.

    when performance is the only thing i give a shit about; i'd rather eat
    shit than play with an obsolete database that doesn't work optimally in
    network situations




    Tony Toews wrote:
    > This Guy <ThisGuy@discussions.microsoft.com> wrote:
    >
    > >Where can get this Olap Connector? I can't find it on Microsoft.com. And I
    > >agree with you for the most part about MDB, but it works for simple
    > >applications, especially for users who are not very computer savvy.

    >
    > Aaron has his opinions which he stridently posts.
    >
    > I guess we won't tell my client who has 25 users in the Access
    > database all day long that Access doesn't work. 160 tables, 450
    > forms and 350 reports. Nope, it doesn't work for them at all.
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
     
  7. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

    the good news is that you can use this connector with CUB files--
    offline cubes.

    http://www.microsoft.com/downloads/...81-1D5F-4BBD-9E39-825A74FB1788&displaylang=en


    about offline cubes
    http://office.microsoft.com/en-au/assistance/HP052479081033.aspx

    i can't find my info on these right now; i fell in love with them years
    and years ago.. but online cubes--with sql server anlaysis services is
    a billion times better so that's what i do for a living

    we've got a couple hundred olap databases; each one having a couple 3-4
    cubes
    it's fun stuff i love it; it's all lightning fast off large amounts of
    data also

    -aaron


    This Guy wrote:
    > Where can get this Olap Connector? I can't find it on Microsoft.com. And I
    > agree with you for the most part about MDB, but it works for simple
    > applications, especially for users who are not very computer savvy.
    >
    > Thanks.
    >
    > "aaron.kempf@gmail.com" wrote:
    >
    > >
    > > Mappoint has an Olap Connector to do exactly what you want to do.
    > >
    > > MDB is for babies; use a real database and maybe you'll get
    > > functionality from the 90s and this millenium.
    > >
    > > MDB is for drunken idiots and anyone that uses it today should be fired
    > > on the spot.
    > >
    > >
    > > it's just not reliable enogh.
    > > it doesn't scale.
    > >
    > > not well enough for a single record and a single user.
    > >
    > >
    > >
    > > This Guy wrote:
    > > > What program can I use to draw my own territories over counties on a map and
    > > > link those drawn territories to my access database? I have tried MapPoint,
    > > > but as far as I can tell, you cannot link to a drawn territory, only
    > > > predifined ones by Zip, or county, etc. (By the way, Microsoft, if you're
    > > > listening, we need to be able to do this.) I want to have a map of counties,
    > > > then draw my own territories over the counties and assign each a number. I
    > > > will link that number to one in my database and when I run the cursor over
    > > > that territory, or click on it, I get the data on that territory.
    > > >
    > > > Any help is much appreciated. Thanks.

    > >
    > >
     

Share This Page