Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 39
  1. #16
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Quote Originally Posted by RuralGuy View Post
    I'm sorry, I didn't mean to butt in, just wanted to throw out some ideas.
    You're not butting in, ask away. More folks analyze might find a solution for Gina.

  2. #17
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    ???
    Yes it runs fine on my PC (no server involved, but split db).
    So your set up is different than the others who have a BE on the server?
    Gina, we only know what you tell us and the clearer the better.

  3. #18
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Quote Originally Posted by RuralGuy View Post
    I'm sorry, I didn't mean to butt in, just wanted to throw out some ideas.
    LOL! Isn't that what these forums are for? I will check on the wireless question and report back. Thanks!!

  4. #19
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    I'm their support person, I log in remotely (Team Viewer). I am not in their office. From the beginning of my relationship with this company their system has been buggy after upgrading to Access 2013. WEIRD bugs. I've posted many here.

    Thanks!

  5. #20
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Quote Originally Posted by ItsMe View Post
    Are you considering a persistent connection to the BE for multiuser situations?
    I'm sorry, I don't understand "a persistent connection". Also in answer to your previous question, they all have a .laccdb file on their computers when they are in the db.

  6. #21
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by Gina Maylone View Post
    I'm sorry, I don't understand "a persistent connection".
    http://www.granite.ab.ca/access/perf...ldblocking.htm

    Quote Originally Posted by Gina Maylone View Post
    Also in answer to your previous question, they all have a .laccdb file on their computers when they are in the db.
    That's as expected. If the program terminates abnormally the lock file may not be deleted and can cause problems. You can just delete in manually.

  7. #22
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Are they running the program as an older version of Access but in 2013 software? Or is the db 2013 as well? I was going to suggest maybe creating a new Db and importing all over. Sometimes databases especially older ones that may have been worked on over the years gets issues that are hard to trace. The other suggestion would be to break the process apart in the program, test each step to try to pinpoint where the issue is. Make sure the queries and processes are written efficently, keys in tables, etc. Does the issue only happen when multiple people are in the program?

  8. #23
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Quote Originally Posted by RuralGuy View Post
    http://www.granite.ab.ca/access/perf...ldblocking.htm


    That's as expected. If the program terminates abnormally the lock file may not be deleted and can cause problems. You can just delete in manually.
    Yep, I've had to do that for them before.

  9. #24
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Thank you all so much for your suggestions. Regarding persistent locking, the database has a bound form that remains open always the "Main Process Entry", they use tabs to go to other sections, but that main form remains open. So I guess they each have a persistent connection. This is a good thing right?

  10. #25
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    I have done that (created a totally new database and imported the objects). I have a question though - the program depends heavily on macros - anyone have an opinion on this? I find them hard to follow and difficult to trace problems. I would much rather use VBA, IMHO.

  11. #26
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by Gina Maylone View Post
    Thank you all so much for your suggestions. Regarding persistent locking, the database has a bound form that remains open always the "Main Process Entry", they use tabs to go to other sections, but that main form remains open. So I guess they each have a persistent connection. This is a good thing right?
    That should do it!

  12. #27
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    You can go to design of form, in Database tools section at top, click on Convert Macros to VB.

  13. #28
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Quote Originally Posted by Gina Maylone View Post
    LOL! Isn't that what these forums are for? I will check on the wireless question and report back. Thanks!!
    All are hard wired to the server. However it is not technically a "server" it is a mass storage device. Does this matter?

  14. #29
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  15. #30
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by Gina Maylone View Post
    All are hard wired to the server. However it is not technically a "server" it is a mass storage device. Does this matter?
    Access is actually a P2P system and does not use a "server" as such.

Page 2 of 3 FirstFirst 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 09-14-2015, 06:05 PM
  2. Replies: 2
    Last Post: 01-29-2015, 03:07 PM
  3. Running queries, VIA VB, but not running in Order
    By mike02 in forum Programming
    Replies: 6
    Last Post: 06-01-2013, 07:07 AM
  4. Replies: 4
    Last Post: 06-13-2011, 12:14 PM
  5. Functions
    By jamin14 in forum Programming
    Replies: 1
    Last Post: 03-25-2010, 08:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums