Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-22-2019, 12:42 AM   #1
KaiProton
Newly Registered User
 
Join Date: Jan 2005
Location: Manchester UK
Posts: 35
Thanks: 1
Thanked 1 Time in 1 Post
KaiProton is an unknown quantity at this point
Post Intermittent Start up issues

Hello All,
I wrote and Access DBase to run for my company, it tracks various data, and reports as you can imagine,

the set up is, all users have a client program, Written in Access, and this is linked to the Tables held on our Network drive,
each client then only queries the records when required, and opens the datatables only briefly, this is to prevent the tables becoming locked, when the user saves the record, it then uploads it back to the network drive via update query,

The Client is held on the HOME Folder in each user, normally I would make a unique C:\ location, but we are running Citrix, and all areas other than the Home Folder seem to be deleted on exit, at least thats what happened when I tried to store it anywhere else..

so, Tables on the network, Client in the Home folder(I guess Technically Network Too) and every now and then, like this morning all users, have access to the Network folders and their own Home folder open the file to this:

Microsoft Acccess Cant find the Database file 'P:\notificationtracker\notificationtracker.mdb."
Make sure the path/filename is correct

This happens if I run the Client from the desktop short cut, or the folder itself. the best our IT could muster was, someone was in the program already locking the tables..
this is not the case due to the setup Ive used.

If I open access and try to open the file using the SHIFT key method, it tells me the program is locked by another user..

has anyone Else had a similar experience with networking files, I did a quick google, and the results said it maybe something with the linking schema, but I cannot understand why this would affect the Shift key opening method.

Kai.

KaiProton is offline   Reply With Quote
Old 02-22-2019, 01:03 AM   #2
Tieval
Still Clueless
 
Join Date: Jun 2015
Location: UK
Posts: 429
Thanks: 57
Thanked 42 Times in 42 Posts
Tieval is on a distinguished road
Re: Intermittent Start up issues

Could be completely different but I also have a similar problem.

Using Windows 10 my systems do not always connect the network drives on start-up, you can occasionally see a red x against them in File Explorer. If you click on them the system then notices that they are there (and always have been).

I find that if I open File Explorer and go to the network drive, shut down File Explorer and then launch the database I never get the problem.
Tieval is offline   Reply With Quote
The Following User Says Thank You to Tieval For This Useful Post:
KaiProton (02-22-2019)
Old 02-22-2019, 02:14 AM   #3
KaiProton
Newly Registered User
 
Join Date: Jan 2005
Location: Manchester UK
Posts: 35
Thanks: 1
Thanked 1 Time in 1 Post
KaiProton is an unknown quantity at this point
Re: Intermittent Start up issues

Thanks for the Advice Teival, I dont think it is the case, firstly because our network drives do reconnect at boot, so it not normally and issue,
and Secondly, I managed to repair it, somewhat, firstly I went back over every Previous version until I found one that would boot(I keep and Archive of every update) then I disabled different VBA routines in the start up, to see if thats an issue, for example, it logs the user name of who opened it, and also checks a Version number to auto update,
then it hit me, the latest version on the server, used as the update, I looked at that and it worked, to I opened it up, disabled the autoupdate procedure I wrote, recopied it to my archive, and emailed my userbase to run the update patch.
this then re-d.loaded the working version, and 'Robert was your mother Brother'
all working again.

I think this locked file error has come from the network admin, some of the time the profiles crash out, and maybe it left a lock file somewhere in the personal folders..

anyway, Main thing IT WORKS AGAIN!

KaiProton is offline   Reply With Quote
Old 02-22-2019, 02:55 AM   #4
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,439
Thanks: 166
Thanked 1,738 Times in 1,707 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Intermittent Start up issues

Each user even on a citrix / rdp environment should have their own front end copy of the database. Any shared front end will give you issues.

Also your back end data path would be better using a UNC path \\YourServer\YoursharePath\....

As these do not rely on a networked drive being mapped to a potentially random letter.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

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.
Minty is offline   Reply With Quote
Old 02-22-2019, 03:02 AM   #5
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,718
Thanks: 105
Thanked 1,513 Times in 1,426 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: Intermittent Start up issues

Quote:
Originally Posted by KaiProton View Post
each client then only queries the records when required, and opens the datatables only briefly, this is to prevent the tables becoming locked, when the user saves the record, it then uploads it back to the network drive via update query,
You have gone to some trouble to do what Access already does quite well with Optimistic Locking.

Does you application actually lock records that get opened by a user to prevent others loading them? Does it lock the whole table when someone loads a record?

Optimistic locking allows any user to open a record even if it is already open with another user. Before the record is saved it checks for changes made by other users while it was open and warns if there is a conflict.

I recommend you study the difference between Exclusive Locking, Pessimistic Locking and Optimistic Locking to see if you are not simply making life difficult for yourself.
Galaxiom is offline   Reply With Quote
Old 02-22-2019, 03:13 AM   #6
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,350
Thanks: 40
Thanked 3,671 Times in 3,539 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Intermittent Start up issues

Quote:
this is to prevent the tables becoming locked
Normally, tables do not get locked, only individual records - suggest you check your locking policy by going to File>Options>Client Settings>Advanced - for 2007 and later, can't remember the path for 2003. Check 'default record locking' and 'open databases by using record level locking' settings

Quote:
when the user saves the record, it then uploads it back to the network drive via update query,
the risk here is two users change the same record at the same time, the first 'save' will be discarded. Even new records will be at risk if you are using some sort of calculated value such as dmax+1

By not maintaining a permanent connection, you will be taking a performance hit.

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Intermittent Error Frothingslosh SQL Server 12 08-26-2019 04:59 AM
Got a intermittent problem, please help winterh Tables 2 02-02-2012 11:47 PM
Intermittent failure jpawson74 Macros 1 04-26-2007 12:56 PM
Intermittent Backup of DB VinceC General 2 08-05-2003 11:52 AM
Intermittent Conversion Issue Dugantrain General 0 01-24-2003 11:40 AM




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


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

Featured Forum post


Sponsored Links


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