Kicker
04-05-2019, 11:04 AM
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.
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)
For the lack of a better option I have created a dropbox account and all of the files are available to everyone.
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.
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:
adodb recordsets
dao recordsets
update queries
dlookup queries
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.
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.
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)
For the lack of a better option I have created a dropbox account and all of the files are available to everyone.
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.
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:
adodb recordsets
dao recordsets
update queries
dlookup queries
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.