Solved

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

Posted on 2010-08-18
13
1,107 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
  • 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
 
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

705 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now