Consulting

Results 1 to 4 of 4

Thread: Question for the experts

  1. #1

    Question for the experts

    I'm old and don't have much hair left but am starting to pull it out from frustration. I'll try to make this as painless as possible.

    First of all, I have been using VBA for a very long time and have found many of the users of this forum to be wonderful resources. I'll try to describe my issues as simply as possible.

    1. I have created a series of programs for multiple organizations where I have retired. One in particular, has 4 locations. In addition, 5 of the users need remote access (including myself)
    2. For the lack of a better option I have created a dropbox account and all of the files are available to everyone.
    3. One of the programs is a Point of Sale program that is used at 3 of the locations to sell hand-made items made by the club's members.
    4. All of the data tables are located in a single .adodb file and are linked to the POS.accdb. In general, this is working great.


    Remember I said this was a retirement community with a whole lot of old people. They either don't care or they believe they know more than everyone else. Some users will just leave the tables open and open multiple copies of the program. Others will do their best to "make improvements". I'm trying to lock everything down but they play around until they get into the wrong places.

    None of the clubs has any extra money for specialized programs and databases.

    I do not allow any of the code to open tables and leave them open. In all the code I use:

    1. adodb recordsets
    2. dao recordsets
    3. update queries
    4. dlookup queries
    5. delete queries


    anything that will not hold tables open.

    And yet.....I get a ton of "conflicted" files because one center will have the table open and someone else tries to save data to one of the tables.

    IS THERE ANOTHER repository I should be using. A different "something" that would help?

    Thanks in advance, I am looking forward to seeing some responses.
    ttfn

    Kicker

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Kicker I have absolutley no experience with sharing databases on line, but if you Google Access on Dropbox it is a big no-no.
    It leads to all sorts of corruption.
    I found this
    https://www.dropboxforum.com/t5/Shar.../148128#M21950

    You asked a similar question before here
    http://www.vbaexpress.com/forum/show...net-Connection
    and my response then was the same as now.
    HITech Coach who sometimes posts on here posted on this thread
    https://www.mrexcel.com/forum/micros...-can-done.html

  3. #3
    Sorry OBP
    I was kinda hoping there might be some other ideas popping up.

    Appreciate your response
    ttfn

    Kicker

  4. #4
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Maybe you could try asking on the Interent & networking forum on VBAX's old sister site.
    https://forums.techguy.org/

    You didn't look at sharing a computer described by HiTech?

Posting Permissions

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