Re: Access file corrupted?
it sound like the file is NOT closing...
re-create the error.. then open your task manager.. is ACCESS Running still?
ohh.. i just notice the "remote" portion of your post...
yuk.. working with access remotely is HORRIBLE.. im suprised u havent had more issues than this. yes, its getting delayed along the way.
Re: Access file corrupted?
If the mdb is on a Terminal server then that may also complicate the issue. If you create a new blank database and try the same scenerio does it also do the same thing or open normally?
Re: Access file corrupted?
This has happened to me on two new databases I created and am working on. I'm new here btw. They haven't had this problem with previous projects that are already being used by other users. But, they are doing new stuff in the networking area and we've been having some issues with the server so I think that's the problem. Anyways, I found a fix for it. I just right click my computer, go to manage, select Shared Folders, Open files and right click and close the access files that aren't display for me. THEN, I log off my connection to the server and relog back into it and I can delete the .ldb file and open it. Of course, every time it hands up like that I got to do what I just said above again, but at least it works.
Re: Access file corrupted?
There was a know issue with Access on a Terminal Server where the Temp folder would be in a different place or something and causing disk or network error and not allow access to open the db, but your not getting any messages, right?
Re: Access file corrupted?
Nope, I get no error messages. I just double click the access file to open it and it never appears, but the .ldb file appears next to it showing it's been opened/running. If I try to delete the .ldb file i get an error about a sharing violation. But, I just do the process I said in my last post and it lets me delete the .ldb and reopen the access file.