|
Please
see below for answers to Frequently Asked Questions If
your question is not answered by the FAQ, send support queries to:
We
aim to respond to all support queries within 24 hours, Monday to Friday. |
|
|
|
Note: To avoid compatibility
problems, please make sure you have the latest updates and patches for Access
from Microsoft Update. Simply visit http://update.microsoft.com
to scan your PC. To keep your PC running smoothly and
securely, you should regularly check for updates from Microsoft. |
|
I can’t open it in Access 2007, why not? I get security
warnings when opening it in Access 2003, what should I do? |
|
From
Access 2003 onwards, Microsoft added security measures to the office suite,
to prevent malicious code from being run on e.g. word/excel documents
attached to spam email. This
unfortunately has the added effect of creating some mild inconvenience when
you work with your own custom Access applications. We
digitally sign the program code in our applications with a certificate which
verifies that the file has come from us and hasn’t been modified by anyone
else. To run Simply Orders or Invoices, you just need
to ensure that Access is configured to accept applications with digitally
signed macros. Click here
for instructions for how to check the Access 2007 Trust Centre Settings Click here
for instructions regarding Access 2003 Macro Security Settings |
|
Where can I download Microsoft Access 2007 run-time from? |
|
Click here to download Access 2007 runtime from
Microsoft’s website |
|
How do I share Simply Orders / Invoices with multiple users on a
network? How can I copy Simply Orders to a new PC? |
|
It couldn’t be easier to share
Simply Orders or Invoices with other users via a network.
Just
follow these three simple steps: 1.
Run the installation program on each PC to install Simply Orders 2.
Move the company data file (e.g. mycompany_data.mdb) and the associated
company logo file (e.g. mycompany_logo.bmp) to a shared network location 3.
The first time Simply Orders starts on each new PC, it will ask for the
location of the data file to be used (or, you can switch data file at any time
using the link on the left of the main switchboard screen). That’s it! |
|
What files should I back-up? What sort of backup system should I
implement? |
|
The
data is all stored in a file called “[mycompany]_data.mdb” – where
[mycompany] is the name you enter when creating your new data file. It
is essential if you use any business software to implement an
effective backup strategy. If you
haven’t already got a system, we recommend Mozy.com If you are going to make design changes to the
master copy of the database application itself, always make a backup
first. When making design changes,
consider keeping an extensive version-history in case something goes wrong –
i.e. keep copies of previous versions (by date or version number). |
|
What are the different file types/extensions that Access
uses (.MDB, .MDE, .ACCDB, .ACCDE, .ACCDC)? |
|
When
you design an Access database, up until Access 2003 the database file had the
extension .MDB – but for Access 2007, the file extension .ACCDB was
introduced. As
well as data tables and queries, Access stores the design information and
program source code (Visual Basic for Applications, or VBA) for your forms
and reports in the MDB or ACCDB file.
However, when you want to give you nice database application to the
end users, it is best if they don’t work with the MDB/ACCDB file, e.g. in
case it gets damaged. Normally what
you do is: 1. Split the application into a “back-end” (the data file)
and “front-end” (the user interface – forms, reports, etc) 2. The front-end is then compiled – creating a file with extension .MDE (up to 2003) or
.ACCDE (2007). The compiled file doesn’t contain any of
the application’s program source code.
It functions just the same as the original, but can be given to users
without fear of them being able to change / damage the application. Note:
In Access 2007, when compiling a digitally-signed application, a file with
the extension .ACCDC is created – this is then used to install the signed
ACCDE file on users’ PCs. For more on Access 2007 file formats, click here. |
|
Are there any books recommended to help learn
Microsoft Access? |
|
There
are lots of books on Microsoft Access, but our favourite is: Microsoft®
Office Access 2007 Inside Out (click
here to read about this book on Amazon.com) Click here For a full list of Access books on Amazon. |
|
All rights reserved worldwide © 2009-2010 Synstral Business Software HB, Storegårdsvägen 2, 534 94 Vara, Sweden |
||
|
Registered
in Sweden, No. 969739-9856, EU VAT number SE969739985601 |
|
|
|
