Microsoft Access Database Question

[mindonstrike]

Originally Posted by trelynda

I opened and updated access database. Then I concerted to 97 and placed in folder and renamed it songs.mdb. I know it is not recognizing it because my changes dont show up in hoster. I will try again tomorrow when i go back to work. Should i delete all other instances of the songs databases?

I had this big long post written out and then it hit me you said the bars computer is Vista.

Dollars to donuts this is the issue.
Assuming yours works like mine. Navigate to the location listed by admin, you'll probably see the bucket.mdb and the new songs.mdb you copied back. Right above those listings you'll see a button marked "compatability files". Click on that and voila there you should see the old songs.mdb that Hoster is still accesing. Just copy the new songs.mdb into this location and it should start working for you .

With Vista anytime you can't find something or something doesn't behave as expected it's usually because of the "compatbility file" thing.

And if this isn't it post back and we'll try something else.

Sam

[trelynda]

By George, I think you've got it! I logged in using go to my pc and found the compatibility button. I will try it tonight. Need to do a few updates anyway. Will let you know but I think this is the issue and would be the same for anyone that uses vista and wants to update their database via access.