Missing Data & Recovery
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. You must first understand 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"
"I can only see outdated data from the past in 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.
- (For multiuser environment only) Another user 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.
"I do not see some or any of my records / catalogs anymore"
- The filters you assigned to the views might be hiding (filtering out) some records.
You are recommended to keep at least one view without filter attachment on each catalog. Right click the catalog,
select "create new view", add desired fields to the "displayed field" box. Save changes. Click on the new view you just created.
- Current view does not contain any fields to show.
If you create a view but do not add any fields into the "displayed fields" list, then no records can be displayed.
Open view settings and add at least one field.
- The missing records might be displayed on a different page than the page you are displaying.
Change the current page using the page navigation buttons on right bottom of the window. You may also use the search box
or sort records by clicking on a column header to find the record(s) you are looking.
- You might have set some of your catalogs as invisible.
Click "database" menu, select "catalogs", can you see now all missing catalogs? If yes, select the catalog, click "Properties",
make sure that the box "display on catalog tree" is checked. Click "reload" from toolbar after exit.
- You might have restricted your own access rights.
- Click "security" menu, select "user groups", select your user group, click "modify". Make sure that all permisson boxes are checked.
- Click "security" menu, select "Access right manager", delete or deactivate all access right entries.
- You might have logged on to SpeedBase with a restricted user account.
- Make sure that you did not moved your user account to a restricted user group.
- (For multiuser license) You didn't click the reload button.
Beware that adding or modifying a record on a client computer will not automatically
update the view on other client computers. Other clients may need to click the "reload" button once to refresh their screen.
- (For multiuser license) You might have logged in as a SpeedBase user which does not belong to any user group.
When you create a new user in SB, you should always attach that user to one of the user groups (or to the default "system administrators"
group if you didn't create any user group before). Otherwise the user will not have access right to any data.
Click "Data" menu, select "Exit" to terminate SpeedBase. Restart it and make sure to login using a user name which has admin rights.
You may then attach the previous user account to a user group you want.
- You enabled cache for current catalog.
If you enable cache for a catalog, records which you created/modified recently may not be displayed until you click "reload" button.
This feature should only be used temporarily and in exceptional cases when the network is too slow and you accept that data displayed
on screen may not be up to date.
To disable caching, right click the current catalog, select "properties", uncheck "use cache" box and save changes. Click reload button.
- (For multiuser license) Another user might have accidentally deleted your records or a catalog which was containing records.
If you are sure that this was the case, you may restore your database from a recent backup (see below).
"I have accidentally modified my data by doing an incorrect import."
Changes you made on your database cannot be undone. You should restore your database from existing backups.
Click "database" menu, select "Backup & Restore", select a recent database backup which was created before the change and click "restore" button.
"I have accidentally deleted records or database fields."
"I have mistakenly made a series of updates on my records, how can I locate these records?"
Use the system field "Modified On" as a sorting criteria to find the most recently updated records:
Use the system field "Created On" as a sorting criteria to find the most recently created records:
Contact support if none of the recommendations given above resolves the issue.