FAQ (Frequently Asked Questions)
Before contacting SQLView support, please see if your question
is answered in our FAQ section below. Click
on any question to display the answer.
This works well with third-party sync tools that allow you to customize which Outlook folders to synchronize with your PDA. As a rule, if you can sync Exchange Public Folders, you can sync SQLView folders. We have good experience with solutions from www.chapura.com: PocketMirror for Windows Mobile and KeySuite for Palm. Yes, and you have two options for this. Like regular Outlook Items, SQLView items have 'Created By' and 'Modified By' fields which can easily be displayed in a form or list view. Or, for more flexibility, you can use SQLView's Relationship feature to create detailed links between items, like Account Manager - Client. Yes, SQLView lets you set detailed permissions on a per-folder basis. Yes, forms are customized centrally and assigned to Folders. So you decide which form is used on which folder(s) network-wide. This is what the SQLView feature 'Related Items' was created for. Please take a look at our User Manual or SQLView Help, which explain the details. There is no problem in saving some data in SQLView and some in Exchange. SQLView works with folders just like Exchange, so you can decide to leave your email and Calendar in Exchange, and put all other folders into SQLView. You can create one or more Email folders in SQLView, and then create a rule in Outlook to move a copy of your emails into that.
The entire SQLView database, including emails, is stored on the 'server' (which may just be a normal user PC running either SQL Server or our free MSDE module), and can easily be backed up. No, this will not be possible: the Single-User license is just that, it does not work as an “additional-user license”. Anyone using a Single-User license will always fail to connect to a SQLView database if there are other users connected. Outlook 2000 must be in Corporate or Work Group. For details, please refer to Help in Outlook 2000. This only applies to Outlook version 2000. The rule is: Every Outlook user who wants to connect to a shared SQLView database at the same time needs a license. If a machines only stores the SQLView database, it does not need a license - unless it is also used to access the SQLView database through Outlook. Make sure the Outlook Folder list is displayed on the left of the Outlook screen, this will show all SQLView folders you are currently connected to. The MSDE workload governor
is based on concurrently executing batches of Transact-SQL
statements, not on the
number of concurrently connected users. You can have many
users connected to an instance and never hit the workload
governor so long as you never have more than five users
try to execute Transact-SQL statements at the same time.
When the sixth batch of statements comes in, it does not wait
for one of the previous five to complete. What happens is
that the workload governor starts slowing down all of the concurrent
batches. The more concurrent batches there are over the
limit of five, the more the database engine slows down all
the batches.
The more data a batch requires, the slower it will run.
This means that systems which only slightly exceed the limit
and don't process much data in each request may not have any
noticeable performance impact. A system that regularly
processes many concurrent requests that require the retrieval
of a lot of data would notice a slowdown.
In other words: Although there
is no 'real' user limit, database performance will decrease
significantly if over five users work on it concurrently,
and return to normal when the number drops to five or less.
For more information on MSDE, check the Microsoft MSDE web site: http://www.microsoft.com/sql/msde/default.aspYou may have accidentally changed the list
sort order, by clicking on a column header. Most
people are used to a certain sort order, e.g. Contacts to
be sorted by LastName, or Mail by Received date. In a list
view, sorting is visualised by the Sort pointer (the small
3-D triangle) next to the header title, e.g. pointing down
for Descending order. Inadvertently clicking on another column
header will sort by that column. To revert to your original
sort order, click on the column header of your choice until
the Sort pointer shows the correct direction, then scroll
to the top of the list. For more tips on troubleshooting Outlook views, see
Outlook Help. Yes, without any limitations. Just remember that Outlook 2003 may not display your SQLView folders automatically at first, e.g. if you already have a large number of other Outlook folders. Click the Folder List icon at the bottom of the Navigation Pane to display a tree view of folders, including SQLView folders. Yes, without any limitations. If your computers are member of a domain, it is easier and more secure to use Windows Authentication. If your computers are not in a Windows domain, you need to use SQL authentication. You can only use the SQLView menu if a SQLView folder or an item in a SQLView folder is selected. The SQLView menu is context-sensitive: commands are only enabled if you have selected database items they can be used on. This may come up when create or modify an Outlook view and use a field that can potentially change the number of rows displayed. For example using Groups, since an item can appear in more than one Group. In these cases, you will need to create a filter for the view.
|