MTU.Community


Go Back   MTU.Community > Hoster Software > Hoster Help

Hoster Help Post Hoster questions, tips and suggestions here.

Reply
 
Thread Tools Display Modes
  #1  
Old February 25th, 2020, 08:44 PM
mdulle mdulle is offline
Registered User
 
Join Date: Jan 2006
Posts: 22
Hoster Database Product

Hoster originally used an Access MDB database to drive program operation. It appears that this is no longer the case. I found it useful to be able to use MS Access or Excel to take a look at the database to sort data and check for incorrect data. Is there a way to do that now? If you moved to a true SQL database, then it seems that the addition of new Generes would be a simple add to a table (unless a complete recompile is required). Also, is there a request to be able to add custom fields? I want to be able to record the year of the song for sorting in the database and songbook.
Reply With Quote
  #2  
Old February 26th, 2020, 09:56 AM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,343
Re: Hoster Database Product

Hoster still uses Songs.mdb as well as singers.mdb.
The default place where the Songs.mdb and Singers.mdb and any other data files was changed sometime ago from C:/MTU to C:/ProgramData/mtu.com/Hoster/ which is normally in hidden folders but can easily be found from Tools menu Hoster Datafolder.

These can still be opened in Access although MTU does not recommend opening any of these files in Access.
Safest way to open them in Access is to create a copy first and only open the copy.

Most changes you make in Access will be lost as soon as you rebuild the database. Hoster creates the Songs.mdb from the data in the kmh or kmf files. It does not write the data back from the MDB file into those files.

I attach a couple clips from the Manuel with info on Microsoft Access use.

Might be best to suggest your ideas for being able to add fields and genre in the Hoster new features request forum as it is more likely to be seen there by the programmer.
Attached Images
File Type: png Warnings.png (67.8 KB, 5 views)
File Type: png Songs database facts.png (69.3 KB, 4 views)
__________________
Roy.
Test Laptop: Windows 10 Home Premium 64bit. Acer Aspire 5738G Intel core 2 Duo T6600 ATI Graphics 500Mb dedicated. 4Gb Memory 500 Gb SSD Drive. K-lite Mega version 1205
Show Backup: Windows 10 Acer Aspire Touch Screen V15, Intel core i5, Iris Graphics 6100 up to 8277mb dynamic video, 16Gb memory, 1 TB hybrid HDD. K-lite Mega pac.
Show Computer: Windows 10, Dell Inspiron 15 7000, CPU I7-855OU, Ram 8GB, Graphics UHD620 + Nvidea GeForce 940MX, Hard Drive SSD 256GB + 1GB internal.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On


All times are GMT -4. The time now is 05:46 PM.


Powered by vBulletin® Version 3.7.1
Copyright ©2009 - 2024, Jelsoft Enterprises Ltd.
The contents of this forum are copyrighted by Micro Technology Unlimited, 2000-2008. Use of any material from these Forums is prohibited without written agreement from MTU.