[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Access Database has errors, after tryign to transfer to NAS Device

Im working on a group of 3 computers and a server that use this database.  When I transfer this access database, it works fine on two workstations, one with access 2010, the other with 2003.  But when opened on one with 2007, I get the following error:
The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time.

This error does not occur when using the database on the shared server drive.

I have checked Microsoft, and tried the fix, but cant.  The .lbd file seems to be corrupted as it reads:
¿¿¿¿N†††††††††††¿¿n†††††††††††††¿¿¿¿¿¿Q†††††††††¿¿n†††††††††††††

These computers are set as workgroup computers no longer connected to the server (router is DHCP server), just sharing the drive.  Thanks for any ideas!
0
Knightsman
Asked:
Knightsman
  • 5
  • 5
  • 3
  • +1
2 Solutions
 
peter57rCommented:
If the ldb really is the problem then cclose all users and then delete it if its's still there.

But I doubt if that is the problem.

Can you just clarify your usage.
It sounds from your post  like each user has its own independent copy of the databse - is that correct?

Or are you really trying to set up a multi-user operation?If so then have you split the databse into frontend and backend?
0
 
KnightsmanAuthor Commented:
I doubt its the lbd also, just weird that its like that.  

They all use the same database, no copies, shared.  This database works fine for them on the shared drive, but not on the NAS.
0
 
peter57rCommented:
I'm not a networking person so I can't comment personally but just googling the subject now suggests that there are loads of problems with using a NAS drive to hold an Access db.

Maybe not such a great idea, then.
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
Jeffrey CoachmanCommented:
Is this a commercially available NAS device or one you built yourself?

Is this issue only for Access databases, and all other files run fine?

Is this an issue with *any* PC running Access 2007?
What are the Advanced setting in Access for the 2007 machine?
untitled.JPG
0
 
Jeffrey CoachmanCommented:
Did you try copying the DB over again?
Perhaps this was a one time glitch when you copied the file?

Make sure the DB is in the Access 2003 format and is compacted and the code is compiled.
0
 
KnightsmanAuthor Commented:
Just checked the advanced settings, its set as your picture shows.  

I did try recopying the file, which allows the two computers to use it again, but once that one opens it, this happens.


Is this a commercially available NAS device or one you built yourself?
Iomega 1 TB Home Media Network Hard Drive Cloud Edition.  

Is this issue only for Access databases, and all other files run fine?
This is the only database they use, and only thing that needs to be on the shared drive.

Is this an issue with *any* PC running Access 2007?
unsure, there are only 3 computers with access.  which are 03, 07, 10.  (wish they would just let me upgrade them all)
0
 
peter57rCommented:
Are you saying that you have 3 users with different versions of Access all opening the same file?
If so, you are going to spend your entire life fixing corruption problems.  This is an absolute no-no as a setup.

You MUST split the database immediately and give each user their own frontend.
0
 
KnightsmanAuthor Commented:
I understand the corruption issues.  I am unable to that.  The database was written in 2000 because the users that use the database mostly still have office xp and 2003.  

I received this contract about 5 months ago with these issues, slowly trying to get them in the right position, but money is tight for them.  With access being >100 pop, even harder to pursued when they don't see how it works.

Might be able to get them to do a new front end...I didn't design the database.  
0
 
Jeffrey CoachmanCommented:
Then I'm with Pete, split the DB properly first....
0
 
peter57rCommented:
Splitting the database is free.  I'm inclined to bet that this is usage is the cause of your current problem.
0
 
KnightsmanAuthor Commented:
There wasnt a problem until the NAS came into play, and there is no problem right now, because they are using it off of the shared drive on the server.

The problem only occurs when they are running off the NAS device.
I understand your point, TRUST ME, I do.  But that's not the issue if it works on the server.
0
 
KnightsmanAuthor Commented:
From talking the guy that wrote it, it was built in 2000, has already been split.  Does it need to have a front end for each different version?  

Why would this work on a server but not a NAS?  

I'm not an Access person, im a hardware, networking, keep it up and running and all is happy in the world guy.  Thanks everyone for input, all help is appreciated!
0
 
peter57rCommented:
I can't comment on the NAS issue.  BUt if you have diagnosed that as the problem area then you probably need to get the Q posted ito a suitable networking zone rather than Access-  ah - I can see you have allocated it into misc networking- is that good enough? I don't know.


But the sharing issue is that you should not share a file between different Access versions.
If you have 3 users each with a different version of Access you need 3 front-end files.  They can be copies of the same file- they may not necessarily have to be compiled into the local Access version but they need to be physically different files. In my view you should make sure this issue is sorted out so that you can be sure it is not the cause of the problem.  I appreciate your point about 'only on NAS' but you need to eliminate any bad setup issues so that you are not sidetracked as you have been in this question.
0
 
QlemoC++ DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 5
  • 5
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now