Problem with MS Access

[Roy Dennis]

Probably best to wait for Dale to answer this but just to be clear the file you should be looking for to open in Access is Songs.mdb. If you are trying to open Songbook.rtf that has to be opened in Microsoft Word.

Roy.

[Ernie]

I installed Hoster and did a rebuild. When I checked Hoster in programs... Songs mdb is not there????????

[ddouglass]

Originally Posted by Ernie

I installed Hoster and did a rebuild. When I checked Hoster in programs... Songs mdb is not there????????

Songs.mdb is located in C:\MTU\Hoster not under the program files area. This is thanks to Vista and Windows 7.

[Ernie]

Dale,
Sorry, I didn't realize I had written PROGRAM instead of MTU. In MTU Songs mdb is not there. I'm still using XP. I'll try a reinstall tomorrow morning. Should I choose everything in custom install?

Your help is always appreciated!!
Ernie

[ddouglass]

Originally Posted by Ernie

Dale,
Sorry, I didn't realize I had written PROGRAM instead of MTU. In MTU Songs mdb is not there. I'm still using XP. I'll try a reinstall tomorrow morning. Should I choose everything in custom install?

Your help is always appreciated!!
Ernie

Look for Songs. Since you re-installed XP then everything was set back to default which means you will not see the extensions unless you set it to show them again.

Install all the items for Access except the "Samples" unless you want them too.
As to the other parts look through the items and see if there is any thing you want. Then after you have re-installed it go to Microsoft Updates and get any security updates for Office 2007 2003 which ever you are installing.

[Roy Dennis]

Originally Posted by Ernie

I installed Hoster and did a rebuild. When I checked Hoster in programs... Songs mdb is not there????????

The .mbd file is usually in C:\ MTU\ Hoster and can't be changed.

Roy.

[Ernie]

Dale,
I uninstalled Office and then did a FULL reinstall. I then went to Hoster and opened Songbook and then choose what to display. When I hit enter, a page came up and displayed this.... Unrecognized Database Format 'C:\MTU\Hoster\SongBook.rtf'. In MTU\Hoster, I do have Songs but no Songs.mdb, also Bucket just says Bucket. Don't know where to go from here!?!? I could sure use your help.

Thanks,
Ernie

[Roy Dennis]

If you cant find Songs.mdb just open the file named Songs. To view the file extension you will have to reset the view option in folders. From the control panel select "Folders" from the window that opens choose the view Tab, scroll down and untick box "Hide extensions for known file types" Then scroll down further and tick box "Remember each folders View Settings" Then OK.
Now open C:\MTU\Hoster Folder and you should now see the .mdb extensions.

Roy.

[Ernie]

Roy,
I did get the extensions, but when I double clicked it a page still opens and says....Unrecognized Database Format 'C:\MTU\Hoster\SongBook.rtf'. It just won't display the list!?!?!? I still don't know what to do!! Thanks though, at least I was able to take another step.

Thanks again,
Ernie

[Roy Dennis]

As I stated earlier Songbook.rtf is a Microsoft Word format and you open it in Word or Word pad. If you want to view your files in Access you need to open the files "Songs" which if you have your folder view set to show the extensions will show as "songs.mdb"

If you want to open the Songbook.rtf file right click the file from the window that opens choose "open With" if you have Word installed it will show there together with Wordpad, choose Word

Roy.

[ddouglass]

Originally Posted by Ernie

Roy,
I did get the extensions, but when I double clicked it a page still opens and says....Unrecognized Database Format 'C:\MTU\Hoster\SongBook.rtf'. It just won't display the list!?!?!? I still don't know what to do!! Thanks though, at least I was able to take another step.

Thanks again,
Ernie

Roy is right Songbook.RTF is not a database file. It is a text file that you need to open in Word or Wordpad.