Microsoft Access Database Question

[trelynda]

I have found that the easiest way to update my songlist is to actually open the songs.mdb file and update there, that way I can do multiple songs, artists, etc. That being said, I took the songs.mdb file from the computer at the bar that I work at and copied it. Took it home, where I also have access and updated all of my songs, correcting arts, lastname first, etc. Saved it and then copied it back into the correct folder at my computer at work, but hoster is still pulling from the old database. I even tried to convert the database to Access 97, but it is still not reading it. Any suggestions? I am using Access 2000 and system at bar is Vista with Access 2000. If I go into the database at work and update it, the updates show immediately, so I know it works.

[ddouglass]

When you first open it in Access it usually will ask if you want to convert it to current version. Just tell it NO. Not all of the current features will be available but it will also re-save after editing in the original (97) version.
If you copied it back to the correct location (C:\Program Files\Micro Technologies Unlimited\Hoster\database) it should have over-written the old one, so it couldn't be using it unless you wrote it to the wrong location.

[trelynda]

it never asked me to convert the first time i opened it in access 2000.

[admin]

Hoster 3.317 and below ONLY uses Access 97. We are considering also supporting 2000 if feasible. However, the 97 "jetengine" is only 8MB, and the 2000 "jetengine" is 60+MB... which is not feasible to download.

The manual states "The Songs Database is in Access 97, 16-bit format. It can be opened and modified with Microsoft Access 97 or 2000. To use it with Access 2000, you must first convert it from 97 format to 2000 format, make your changes, then export it back to 97 format so Hoster can open it again."

You are trying to be a power user. You can do this, but you must follow the instructions above.

Dale is right. If you write the new Access 97 format Songs.mdb back to the correct folder, which is slightly wrong. The exact address is:
C:\Program Files\Micro Technologies Unlimited\Hoster\databases

Put it back here, in the right 97 format and Hoster will find and use it.

[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?

[ddouglass]

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 think the information you are talking about is the title or artist information that shows in the playlist?? If so I believe that would be coming from the header of the file rather than the songs.mdb file. The songs.mdb information would show up in your songbook if you create one from Hoster.

Admin sorry about that...I didn't verify before typing in the path.

[trelynda]

that is the information that i am able to update within access and then , yes, go into hoster, search for song or sings i updated and the results show in hoster. In hoster itself, you cannot pull up one artist and then correct spelling or capitalize more than one at a time. This is why I go into the database file in the first place.

[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.