Solved

Could not save: currently locked by user admin . . .

Posted on 2010-08-18
13
1,138 Views
Last Modified: 2013-11-27
We have been struggling with a problem for several months involving our Access Control Card software (Number Five Software, Card five Professional v8.7).

The software uses any standard web camera to capture the image of an associate and print/save. The software uses a Microsoft Access2003 SP3 database.

When I take a photo:
1.      I get an error message.
2.      The card will print after the error message is displayed twice.
3.      The photo is NOT saved to the MS Access db.

The error message:
Cardfive Vision 8.7 Professional
N5 Database Kernal
Database Error - SAL Statement execution
error SQL State = HY000 SQL Driver
Code=-1105  [Microsoft][ODBC Microsoft Access
Driver] Could not save: currently locked by user
'admin' on machine 'VSAT4W61JH1'.
(Dbconn.cpp:2773)[Microsoft] ODBC Microsoft

                                [Help]  [Close]

We have done the following:
1.      Worked with the software vendor for several months – no solution.
2.      Eliminated the original Logitech software,
3.      Used a generic driver,
4.      Replaced the Logitech camera with a Microsoft camera.

But, we still get the same error.

What am I missing? What can I try?

NFiveError.bmp
0
Comment
Question by:Tom Winslow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 3
  • 2
13 Comments
 
LVL 5

Expert Comment

by:INHOUSERES
ID: 33465490
what machine is "VSAT4W61JH1"?
0
 

Author Comment

by:Tom Winslow
ID: 33465503
That is my company supplied DELL laptop. The software and drivers are also on the DELL Laptop.
0
 
LVL 5

Expert Comment

by:INHOUSERES
ID: 33465520
so this computer is the compuer that's getting the error.
In otherwords, it's locked itself out of the database?
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 57
ID: 33465523
<<1.      Worked with the software vendor for several months – no solution.>>
  The problem is, it's a bug in their code of some type or someone else is really in the file and preventing you from doing something.  But really that comes down to a matter of design of the app.
JimD.
0
 
LVL 5

Expert Comment

by:INHOUSERES
ID: 33465571
Not necessarily, because the code is simply trying to run a query.
It could be that the database is having issues processing the requests, not the app that's requests them.

Tom, Has this occured after an update by the original company?
If so, then it is their fault and you should be asking for their help (or asking for your money back!)

Is the software open source? Can you see the VBA? I highly doubt you can, but if you can, show us the code.
0
 

Author Comment

by:Tom Winslow
ID: 33465676
Tom, Has this occured after an update by the original company?

<<<  Yes, The problem came abut once w did a major update, on a new laptop, with a new card printer. Too many variables changed at one time.  >>>

If so, then it is their fault and you should be asking for their help (or asking for your money back!)

Is the software open source? Can you see the VBA? I highly doubt you can, but if you can, show us the code.

<<<  No, the software is not open source.  >>>

tw

0
 
LVL 5

Expert Comment

by:INHOUSERES
ID: 33465739
Tom, it may be long winded, but if a lot of variables have changed you might have to go back and step through them with tests to see what is causing the problem.

This isn't just for our benefit, because even the company that supply this to you can't really do anything until you can get this piece of information.

My initial thought is that it's the laptop which is the problem.
There has to be a setting or a user restriction on the SQL software which is causing the error.

HOWEVER... a microsoft update screwed my system the other day with DAO recordsets.
I doubt it'll help but it can't do any harm at all:

Click Start > Run
Type CMD then press enter.
Copy this:
Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"
in command prompt, right click and click paste then press enter.

As I said, it can't hurt.
0
 
LVL 57
ID: 33465827
<<1.      Worked with the software vendor for several months – no solution.>>
I really am curious; what was their take on the situation?  
Really it sounds like an app design problem.  
JimD.
0
 
LVL 5

Expert Comment

by:INHOUSERES
ID: 33465862
Just read this on thier site, I assume you've seen it?

Concerning the ODBC error that sometimes occur, please update your MDAC to the version 2.8 available in http://msdn.microsoft.com/data/.
If the error still occurs please contact the NFive Tech Support with more information about it. Also make sure that the database is not being accessed by more than one process at the same time for writing purposes. If the process is running in a slow machine, the windows locking methods may fail and the N5 Database Interface may issue the SQL Statment Execution Error message. This exception has been noticed under rare circumstances when using more than one Auto Print session involving the same database resources.

See this link and tut on how to find your current version:
http://support.microsoft.com/kb/301202

I doubt this would be an issue if it's a new laptop.
0
 
LVL 5

Expert Comment

by:INHOUSERES
ID: 33465904
I've just noticed the error message is incomplete.
Not sure how you could provide the rest of it, but if you can, it may help.
0
 
LVL 5

Accepted Solution

by:
INHOUSERES earned 500 total points
ID: 33980964
Final word...
Go back to how it was and slowly change things one by one.
One of the variables you changed isn't working.
0
 

Author Closing Comment

by:Tom Winslow
ID: 33982106
The software vendor has provided an update. I am hoping that this will resolve all of the issues.
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question