Question db Error msg, just installed Windows 7

[Joe8915]

Running Windows 7
SQL BE
Access FE
Running on a Network
Office 2010

Here is my issue. I just had Windows 7 installed, had XP prior. The db gets an error msg that it was closed un-expertly. After I make the changes in the db, I compact and Repair What happens the ldb file is still there when closed. When that happens in XP, I just deleted the file and went on without a hitch. This only happens when I modify the db.

I have a security file when the users log on, which is located on the network in another file. I see the ldb file there when I close my file. I believe I will have that file whenever a user is logged into the db. I was thinking to delete that file, but I held off on that idea.

I did notice when I log into the production db, which is located on the network, I will get the same error. So then what I do is delete the db on the network and log off the computer and log back on and the db is ok. I have a script running whenever you log off and log back on a new db is inserted.

I hope I made some since. Any Ideas?

Just wanted to say thanks to all who is ever help me out. Just seems I don't say it enough

 

[gemma-the-husky]

it may be a W7 problem

sometimes when i delete files in W7, they do go, but the folder display doesn't change. if you try and delete them, you may get a "file not found" message.

i have seen that with .ldb files

 

[Joe8915]

Now thats interesting. This is my first full day W7. Giving me a run for the money with db. Still having problems on my production side, still getting a error message. I will do a screen shot and attach it on the next post.

Bottom line I know what it is, its the ldb file hanging up and once that happens I cannot get back into the db.

Iam thinking maybe I have to refresh my tables to SQL, if I can into the db.

Any thoughts?

 

[Joe8915]

Ok found out what the problem was. When a error msg comes up W7 tries to figure out the problem. What I was doing was just closing the window before W7 does it for you.

So bottom line don't close it before W7 does it or you will end up with the ldb file.

Now there is something new for sure.