Locked Backend File

[DMT Dave]

Hi Guy's when i have gone into backend tables, i have tried to design an existing table to add a field and it returns a locked message, its only on that table

all machines apart from mine are shut down so i don't believe other machines would have locked this table

I can still add data but wont or can't delete locked file

Task Manager doesn't display any access related files open



strange thing is, if i copy the backend file and place into a different folder, i can then edit that table!!

Is there way i can force the locked _be file to be deleted ?

Do you think one the other machines also shut down but if they have not closed access prior to shut down, could that lock it ?

Quick and easier fix for now is that i could re-link tables in front end to new located backend but that's cheating when the original location should allow me to remove locked file

Any ideas why based on info described ?

[Welshgasman]

Is there a lockfile present?

[DMT Dave]

Hi WGM, thank you, yes there is a lock file present in Original Folder, ironically as stated, if i copy backend to another folder, tables a fine to design etc...

[Welshgasman]

So try deleting the lockfile?

[DMT Dave]

This result is when i try and delete

[Welshgasman]

So the answer would be yes?

[DMT Dave]

As backend is on server, if there is bad connection, will that stop files wworking in a folder ?

I can't understand if so because other tables are fine apart a particular one but copy full backend to another location, the said table can be edited!!!

[DMT Dave]

Ha ha ha ha, thats like ive come to a left hand bend in the road, what should do ?

Well: Turn left why not LOL

I will try again to see if i can delete and see what it says

[DMT Dave]

I thought it wasn't as easy as turning left at the bend in the road



All other machines are switched off and nothing running in task manager relating to access, perhaps apart from backend i trying to edit

[Welshgasman]

Ok, so some FE is still open?
Look inside the file, it might give you a clue as to who it is?

It is not you is it?

[DMT Dave]

Ive closed my front end to edit the back end and other machines are switched off in the office.

How do you mean look inside the file ? i haven't one open, with all instances of access closed even closing the backend, it won't let me delete....

please forgive me if am missing the point ?

[Welshgasman]

How do you mean look inside the file

Right click and edit?

[DMT Dave]

WGM, i owe you an apology, i was remoting in but when i left the office yesterday, another machine hadn't shut down, what made me think it was shut down, I couldn't connect to the said machine remotely so assumed it was switched off, the dog is barking again

Much appreciated

[Welshgasman]

WGM, i owe you an apology, i was remoting in but when i left the office yesterday, another machine hadn't shut down, what made me think it was shut down, I couldn't connect to the said machine remotely so assumed it was switched off, the dog is barking again

Much appreciated

Forget about it all now and have a good Xmas and New Year.

[DMT Dave]

Likewise you too thank you for all of your advise