Sudden database problems

[Albilly]

Hi to all,

I have been working on a db for a couple of weeks now, on my side, everything is working the way it should be. We have different proces to test and approve db changes (meaning different folders with different users for testing like QA, PPROD.
I just deployed a version with minor changes to be tested (QA) and suddenly, errors are popping
If the user is opening the db using Access File Open; MsAccess says it cannot find the database ....... Please verify the filename and path ( this might not be the proper explanation since that user is using french)
When the same user is trying to open the same db via Access (File Open)

When trying to open the same db by double click on it, a different msg appears saying that the user does not have the permission to open the db, please contact the db admin for permissions...

When I try myself well everything is just OK. I have tried a couple compact and repair, decompile the file and still no luck,
did anyone encounter those problems and did you solve it, I just have no clues on this

Thanks

 

[sneuberg]

We have had similar problems when deploying a database. It works for some but not others. In our case the backend was on a server and the IT guys had not given the people with the problems the necessary permissions.

 

[Ranman256]

while no one is in the db, check to see if there is a lock file open, .ldb or .laccdb
delete it.
then open.

 

[Albilly]

Hi,

our backend is on a SQL server and yes, I have check the user permission and she has them, so that is not the problem for sure

 

[Albilly]

RanMan256, these is no on else using the db, no lock file open at all, already check it out before posting

 

[sneuberg]

If whether or not the access application works depends on the location where it is run or the user I suggest you concentrate on what's difference about those locations or users. Given these symptoms "MsAccess says it cannot find the database" and " user does not have the permission" I'd say it must be something in the environment and not the application.

Suggestion trying other known good applications in the same locations and users to confirm this.

 

[Albilly]

I have checked with the admins and they claims that nothing changed. I always backup my work once a week, friday PM,
Yesterday, I needed to make some small changed , half dozen line of code to add validation, complile make .accde and problems.

I decide to test something else, I copied my last friday backup in the QA folder and then wow, it works, no problems at all. works just fine.

It is very hard for me to see that half dozen new line of code can create such problems all of a sudden, specially in a function that was and is working just fine

Very strange