I have my app completed, it's in the format DB, I have full menus disabled and unchecked show navigation. When I open the FE from my home computer and connect to the BE on my server at work everything works as it should. When I get to work and open the FE on workstation and try to connect to the same BE I get "The expression ON Click you entered as the event property setting produced the following error: Return without GoSub". IT is an exact copy of the FE on my home computer. What the heck is the problem?!! The on click is setting the var db to current .DB I can't figure it out.
Help! with application won't run
- Thread starter slharman1
- Start date
Looking further, I am getting "your network access was interrupted, re-open the database and try again"
One thing I forgot to mention is that I am sharing the back end with two different applications, the job tracking app and the plant management app. I am not sure if that is okay or not.
One thing I forgot to mention is that I am sharing the back end with two different applications, the job tracking app and the plant management app. I am not sure if that is okay or not.
Last edited:
Both english access 2016
What gets me is my intensive app works in both places but not the smaller one, they do share a BE though.
mike60smart
Registered User.
- Local time
- Today, 23:54
- Joined
- Aug 6, 2017
- Messages
- 2,184
On your Work PC create a Blank New Database.
Then do an Import from the FE database.
Relink to the BE and you should be OK
Then do an Import from the FE database.
Relink to the BE and you should be OK
- Local time
- Today, 23:54
- Joined
- Feb 19, 2013
- Messages
- 17,565
to answer the question, it is not a problem for two different 'app FE's' to use the same backend. From the back end's perspective, it is no different from two different users accessing the backend whilst using the same app (local copy of the FE on each users computer of course)
Worked like a charm Thanks!
MajP
You've got your good things, and you've got mine.
- Local time
- Today, 18:54
- Joined
- May 21, 2018
- Messages
- 9,631
May find this useful.
Setting Database default paths
It really wasn't a big deal. I don't expect to be "spoon fed" with this stuff. Sometimes you just have to get in there and sort it! It was the modules that got me. I didn't realise until I got into the code that they were required. Not to worry though. It's a good piece of code.
www.access-programmers.co.uk
mike60smart
Registered User.
- Local time
- Today, 23:54
- Joined
- Aug 6, 2017
- Messages
- 2,184
Glad to help
- Local time
- Today, 18:54
- Joined
- Feb 19, 2002
- Messages
- 47,594
If relinking worked, then the problem is most likely that you are using mapped drives and the two computers are not using identical mapping to the server. The best solution for environments where this is common is that rather than using a mapped drive, use the actuall UNC name of the server. That will ensure that the FE works from all computers on the network.
So how do I put that into the linked table manager, I don't see where I can put the UNC into the linked table manager.
mike60smart
Registered User.
- Local time
- Today, 23:54
- Joined
- Aug 6, 2017
- Messages
- 2,184
No you would put it in the shortcut on the Users desktop that Opens the FE
The front end is on the user's desktop, they just click it and it should open the front end located on the physical drive and connect to the BE on the server.
- Local time
- Today, 18:54
- Joined
- Feb 19, 2002
- Messages
- 47,594
In the relink dialog, instead of choosing a drive, type in the full path to the server starting with the two slashes.
Ahh..yes I didn't think about putting it in that.
Thank you
- Local time
- Today, 18:54
- Joined
- Feb 19, 2002
- Messages
- 47,594
You're welcome.
Now, when you redistribute the FE, the links will work on all computers.
Now, when you redistribute the FE, the links will work on all computers.
Yes, Thanks Again Pat!
- Local time
- Today, 23:54
- Joined
- Sep 12, 2006
- Messages
- 16,051
Just a further thought. You ought to have code in your front end that maintains a persistent connection to the back end. This will speed up performance for multiple concurrent users, and may help protect against network dropouts.
Gasman
Enthusiastic Amateur
- Local time
- Today, 23:54
- Joined
- Sep 21, 2011
- Messages
- 17,081
Could you please explain how to do that Mike?
