Missing Data & Recovery
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 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.
- Quick search is still effective.
If you have recently used the quick search box, it might be still active and filtering the records. Close "advanced search" if it is open
and click "X" button to clear the search results.
- 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 (or another SpeedBase user) 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.
- 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.
- (For multiuser license only) 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 only) 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.
- (For multiuser license only) 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).
- You've 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.
- Restart SpeedBase.
You may have modified a temporary setting which might have caused confusion and unexpected results. Click "Data" menu, select "Exit"
to Exit SpeedBase and the restart it. This will clear up any temporary setting you may have changed.
"I can only see outdated data from the past in my database"
- Current settings you have applied might have made your data invisible.
Scroll up and check the previous section on this page for possible causes.
- An older backup of your database has been restored.
Someone who has access to your database might have restored an old snapshot backup of your database. If a backup database is restored,
you will only see records created/updated until the time of the creation time of the backup.
To go back to your most recent state of your database, click "database" menu, select "Backup & Restore", select a backup which has been
created at an -OLDER- time than the previous restoration time, then click "Restore" button. Review your database throughly to make sure that the most
recent changes are visible.
Beware that SpeedBase might have created additional backups after the issue has happened. That means,
you may still see older records 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.
- Check the help topic "Connection Issues" for other possible reasons.
"I have accidentally modified a record. How do I restore the previous data of the record?"
If you still haven't clicked the save button after the modification, just click "Reload" button from the record toolbar to load the last saved data
of that record.
If you already have saved the record, the previous data has already been overwritten. Click the "History" button from the record toolbar and select
a date to display historical data of the record. The historic data will be displayed as read-only but you will be able to review and copy any historical
field data and paste to the actual record window.
"I have accidentally modified large amount of data by doing an incorrect import."
"I have accidentally deleted records or database fields."
Changes you have made on your database cannot be undone.
For built-in database (default setup): You may consider restoring your database from an existing snapshot backup.
Click "database" menu, select "Backup & Restore", select a recent database backup which was created before the change and click "restore" button.
For SQL Server database: You may consider restoring your database from an existing SQL Server backup which you have created manually or by your backup software.
This applies only if you have purchased "SQL Server Connectivity" and switched to your own SQL Server in the past.
Beware that, by restoring database from a backup, you approve to lose all changes you have made after the creation date of the backup file.
For more information, see the help pages Snapshot Backups,
Cloud Backup or SQL Server Backup
depending on the backup model you are using.
"I have mistakenly made a series of updates on my records, how can I locate those 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:
If you could not resolve the issue, review also the help topic "Connection Issues"
Contact support if none of the recommendations given above resolves the issue.