Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-13-2018, 11:15 AM   #1
logbran
Newly Registered User
 
Join Date: Aug 2018
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
logbran is on a distinguished road
Form not loading for all users - Access 2016

I built a simple ticket support app in Access 2016. The database is split with the back end on a network drive accessible by all users and the .accde front end saved directly to all users' desktops. For about half of my users, only the header of the form partially loads like in the image below, regardless if they're in read-only or not. The form should have several textboxes and a button that write to a new record in the table. All of them have identical settings in the trust center.


Last edited by logbran; 08-13-2018 at 11:28 AM. Reason: Added explanation of form
logbran is offline   Reply With Quote
Old 08-13-2018, 11:21 AM   #2
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,428
Thanks: 2
Thanked 1,993 Times in 1,949 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Form not loading for all users - Access 2016

What happen if they click the button "Save as" and open that database?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 08-13-2018, 11:23 AM   #3
logbran
Newly Registered User
 
Join Date: Aug 2018
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
logbran is on a distinguished road
Re: Form not loading for all users - Access 2016

Same thing, this was just an example screenshot I grabbed from a user's Outlook. They all have it stored locally on their desktop and get the same screen.

logbran is offline   Reply With Quote
Old 08-13-2018, 11:25 AM   #4
June7
Newly Registered User
 
Join Date: Mar 2014
Posts: 805
Thanks: 0
Thanked 182 Times in 182 Posts
June7 will become famous soon enough
Re: Form not loading for all users - Access 2016

Cross-posted https://stackoverflow.com/questions/...rs-access-2016
__________________
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
June7 is offline   Reply With Quote
Old 08-13-2018, 11:29 AM   #5
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,899
Thanks: 92
Thanked 1,694 Times in 1,572 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Form not loading for all users - Access 2016

It looks like they have clicked on the app twice so have opened two copies of it.
As the first is already open, the lock file will prevent the second copy opening correctly.
Look for two icons on the taskbar or two instances of Access in Task Manager.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 08-13-2018, 11:32 AM   #6
logbran
Newly Registered User
 
Join Date: Aug 2018
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
logbran is on a distinguished road
Re: Form not loading for all users - Access 2016

Quote:
Originally Posted by ridders View Post
It looks like they have clicked on the app twice so have opened two copies of it.
As the first is already open, the lock file will prevent the second copy opening correctly.
Look for two icons on the taskbar or two instances of Access in Task Manager.
Same screen comes up off of a clean restart. The 'Save as' message is because it's opened from an outlook attachment. Screen looks the same when opened from the local desktop.
logbran is offline   Reply With Quote
Old 08-13-2018, 11:54 AM   #7
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,899
Thanks: 92
Thanked 1,694 Times in 1,572 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Form not loading for all users - Access 2016

For a start, nobody should try to run an Access database from an Outlook attachment. It won't work properly.

Secondly the desktop should only be used for shortcuts, not applications.
Save the ACCDB file to a suitable folder and make it a trusted location or trusted document.
Then it should run ok either from the folder or desktop shortcut.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 08-13-2018, 11:55 AM   #8
logbran
Newly Registered User
 
Join Date: Aug 2018
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
logbran is on a distinguished road
Re: Form not loading for all users - Access 2016

Quote:
Originally Posted by ridders View Post
For a start, nobody should try to run an Access database from an Outlook attachment. It won't work properly.

Secondly the desktop should only be used for shortcuts, not applications.
Save the ACCDB file to a suitable folder and make it a trusted location or trusted document.
Then it should run ok either from the folder or desktop shortcut.
I know it won't work from Outlook, I just used that to grab a screenshot. The accde is on the desktop with the accdb back end in a network folder.
logbran is offline   Reply With Quote
Old 08-13-2018, 11:56 AM   #9
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,899
Thanks: 92
Thanked 1,694 Times in 1,572 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Form not loading for all users - Access 2016

So move the accde file to a trusted location. Not the desktop
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 08-14-2018, 04:47 AM   #10
psyc0tic1
Access Moron
 
Join Date: Jul 2017
Posts: 353
Thanks: 168
Thanked 7 Times in 4 Posts
psyc0tic1 is on a distinguished road
Re: Form not loading for all users - Access 2016

Quote:
Originally Posted by logbran View Post
I know it won't work from Outlook, I just used that to grab a screenshot. The accde is on the desktop with the accdb back end in a network folder.
Sounds like some users do not have READ and WRITE access to the folder where the back end is stored.

__________________
Richard
Access 2013, Windows 7 64 bit
psyc0tic1 is offline   Reply With Quote
The Following User Says Thank You to psyc0tic1 For This Useful Post:
logbran (08-15-2018)
Reply

Tags
access 2016 , forms 'template'

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
View users logged into database MS Access 2016 Nivaal General 27 09-26-2018 09:49 AM
Creat Search Form By Date, Access 2016 tihmir Forms 15 05-01-2018 09:02 AM
Excel 2016- Loading Power Query into Power Pivot machumpion Excel 3 09-21-2017 01:22 PM
Controls aren't resized with form after upgrade to Access 2016 wisekat Forms 0 04-19-2017 11:46 PM
Deploying Access 2016 Front End, Access 2016 RossWaddell General 2 07-24-2016 05:43 AM




All times are GMT -8. The time now is 05:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World