Skip to main content
B
brendeneng
New Participant
February 24, 2012
Question

Can two datasources point to the same database?

  • February 24, 2012
  • 2 replies
  • 1587 views

Can two unique datasource names point to the same MS Access Database?

    This topic has been closed for replies.

    2 replies

    D
    Dave Watts
    Inspiring
    February 26, 2012

    Can two unique datasource names point to the same MS Access Database?

    Yes. You can create as many datasource names for any individual database supported by CF. And there are some valid reasons for doing this. For example, you might want to have one datasource with permission to change data, and the other without.

    Like everyone else here, I'd recommend that you migrate from Access to ... anything else.

    Dave Watts, CTO, Fig Leaf Software

    Dave Watts, Eidolon LLC
    A
    Anonymous
    February 29, 2012

    You know it is bad when even Microsoft advises against using Access in such a scenario:

    http://support.microsoft.com/kb/299974

    Owainnorth
    Owainnorth
    Inspiring
    February 24, 2012

    What happened when you tried?

    B
    brendenengAuthor
    New Participant
    February 24, 2012

    I didn't try yet because I wanted to double check to see if it was even possible.

    Owainnorth
    Owainnorth
    Inspiring
    February 24, 2012

    The idea of two Access databases makes me feel quite ill.

    I don't see why it wouldn't work, but seeing the number of issues people have with Access these days I'd say there's no way of knowing other than trying it.

    Out of interest, why?

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices