Database Connection Issues
Caution!
Being unable to connect to your production database and being able to connect but unable to see some of your data / records are two different and completely
separate issues. Determine first which one is the case before following an appropriate solution given on this page.
"I am trying to adjust connections settings but my database is not listed in the selection box"
- You might have selected a wrong data folder location.
If the data folder location was selected incorrectly, SpeedBase cannot find and show your database name. Beware that you should NEVER select
the "DB" folder which is a subfolder inside the data folder. The data folder is typically the parent folder of the "DB" folder and may have a different
name if you have selected a different location to keep your data in the past.
Check this page for more information about
selecting the data folder location.
"I am unable to locate or connect to my database"
- You might have modified connection settings or created a new database, hence connected to the wrong database file.
Open connection settings window from database menu. Make sure that both the data folder path and database name are all correct.
If in the past, you have created a copy of your data folder somewhere else, you might have multiple data locations with one of them being older.
So make sure that you have selected the data location from the right hard drive / computer / network location.
- Your database needs maintenance.
In some rare conditions, you may receive an error message that your database file cannot be opened even though your connection
settings are correct.
You are recommended to apply maintenance to your database once a month or after each large amounts of data import/delete.
To do this, click "database" menu, select "Backup & Restore", click the "compact/repair" button just for once. The optimization will
be completed in a few seconds.
- Someone who has access to your database might have accidentally overwritten your database by creating a new database or
restoring an older state of your database using the same file name of your database.
If you are sure that this was the case, you may restore your database from a recent backup.
Click "database" menu, select "Backup & Restore", select a recent database backup which was created before the event and click "restore" button.
Beware that SpeedBase might have created additional backups after the issue has happened. That means, you may still see
the same data after restoring from a backup. If that is the case, just repeat the process by restoring the next older backup file
until you can see the recent records/changes in your database.
"I can only see outdated data from the past in my database"
Please review the help topic "Missing Data" if your database shows only data from a past time and
no newly created/updated records or recent design changes etc. are visible.
If you could not resolve the issue, review also the help topic "Missing Data"
Contact support if none of the recommendations given above resolves the issue.