"SMcK" <NP****@gmail.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...
>
I have a PDA-based (Syware Visual CE) database which I need to sync to
an Access database. The Access database contains three tables: 1 is
the data itself, 2 is a linked table that prefills several fields in
the main data table based on the value of one of it's fields, and 3 is
table the PDA database creates to sync cases. I've been using Access
2003 until now. I need to be able to distribute the Access database
and PDA database to users who may not have Access. Therefore I want
to use Access2007 w/ the free runtime module to create runtime
versions of the database for distribution.
You have to check if your software supports the use of a2007 with that
"sync" software. don't assume it will.
I've installed Access 2007 on a computer and downloaded and installed
the free runtime module. I have no experience with 2007 other than to
open the 2003 database that we *had* been using, convert and save as
an accdb database. I understand that I have a choice of saving as mdb
or accdb, but I haven't figured out how to save as mdb.
The process of converting to a "previews" version, such as using a2003 to
create a access 97 mdb file is the same. In a2003, you simple open the
database, and then go:
tools->database utilities->convent database->
So, you had that ability in a2003 (as always, lots to learn in a2003
also!!).
-Do I need to install anything else besides the AccessRuntime.exe?
Not really. However, even with a2003, I sure you always provided shortcut,
provided a custom interface, and hidden the ms-access interface (right?). If
you
looking to deploy applications, then you have hopefully crossed a few of
these bridges. For example, for updates, you MUST be using a spilt
database..right?
-Does anyone see a potential advantage or disadvantage to using either
an accdb or mdb database?
Like the whole computing industry been for the last 20+ years, if you use
new features in word, excel, or this case ms-access then obviously you have
to use the new file format. So, same for excel, word or ms-access. If you
want to
use new features of the product, for the most part, you have to use the new
format.
-How do you save an Access2007 databas as an mdb?
In a2007, they made it is same as the rest of office. So, in place of using
tools-database utilities in a2003, you now can use "save as", and it gives
you the ability to save as a2000 to a2003 formats. (office button, save-as->
you see the list).
Is it simply a
matter of saving as Access 200-2003? If so, will the 2007 runtime
still work?
I would not attempt this unless you have a lot of experience. I been of late
developing on a2003 box for someone that has only a2000. It is *remarkable*
how many bug fixes, and replot issues occur when I move my software
*backwards*. In other words, a2003 is far better then a2000. Many things
that
work great in a2003, don't work well in a2000. I only learned this by
deploying the application, and seeing it not run correct on those a2000
machines.
The bottom line here is that you really need a few months of experience
doing this,
and finding out what works, and what does not.
Do keep in mind that the runtime is not diffent then the full version of
ms-access. Once you install the full version, or the runtime, then it is
simple matter to copy a mdb, or accdb to the target machine.
The a2000 runtime was 150 megs in size, and often required a
re-boot during the install. So, you are installing a large application from
the
office suite, not some tiny little runtime program.
I repeat, there is NO DIFFERENCE in using the runtime except that you need
to
build your own custom interface. However, if you been serious about
building access applications, then you likely hidden the ms-access interface
for years, and been provding custom menus etc for years also. How much you
been doing this in the past is going to reflect on how much work it going to
be for you and using the runtime.
>
-Now that I've installed the runtime how do I save a runtime version
of the database?
You don't save a "runtime" versions. You simply copy your mdb, or mde to the
target machine (once again, I assume again that you for years been using a
mde
in your applications). If you not been using a mde, then I don't think your
ready to deploy applications, and need a few more months of experience using
ms-access. Once the runtime is installed, it just like you have now, you can
double click on the
mdb, and it runs.
>
-Are there potential problems of using the runtime on computers with
an earlier version of Access installed?
Absolute yes. Remember, using the runtime or the full version is not a
difference in terms of the problems you encounter. After all, they are
compatible!!! So, if you install two different full versions of ms-access,
or
two different runtime version of ms-access on the same machine, you going
got
have lots and lots of problems.
If you want you can purchase some commercial scripts and installer that will
reduce this problem. Many of the problems (and pay for solutions) are
outlined here:
www.sagekey.com
Again, the problems are the same with the runtime because it is the same
system as the full system. Only some
menus, and design ability is turned off..but, it really the same large
install).
I'm sure this stuff is simple for people who do it a lot but I've not
had experience with 2007 or developer toolkit issues before.
Well, it not so much having experience with a97, or a2003, or a2007, but it
just a question of your approach. Your looking for shortcuts here, and
software don't work that way. You need experience running this stuff. You
can't jump to a whole new version of ms-access,and not have a learning
curve. You need to run and test and develop your application for a good
month or so on the new version.
I remember when I converted from a97 to a2003. It took a good month or so to
really get up to speed, and learn the differences. The jump to a2007 is even
larger...
So, I can't imagine any self respecting developer not spending a good month,
or
two using a2007 on a daily basis to develop and test your application. Then,
and
only then can you consider the runtime, and deploying this application to
your
users.
>
Can anyone talk a newbie through the basics?
Do you use split databases now? You should, I explain this here:
http://www.members.shaw.ca/AlbertKal...plit/index.htm
Have you been deploying mde to your users? Again, the above split article
mentions the mde issue.
Using the runtime:
Have you built and been using a hidden interface for a long time, and
users never seen the ms-access part of the application? This issue will
reflect how much work you have to use the runtime.
In my case I had never seen, used the runtime. However since I been
providing
custom menus and interface, then using the runtime was no work for me. I
give some ideas on interface and some screen shots of ms-access here:
http://www.members.shaw.ca/AlbertKal...erFriendly.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com