BG Lad said:
Great one Albert. The DB is aready split.
The next question is: I am still using the .MDB format. Can I just
generate
my own .accdr type file from inside 2007?
Bill
You simply have to convert your mdb to access 2007 format first. then you
should at that point, convert your accDB to an accDE.
At that point you could if you wish rename the accDE to an accDR you can.
However, this step is really not necessary to unless you're not setting up a
user shortcut to your application to be launched. In other words if the user
has the full edition of access installed, then it's probably a good idea to
send them that accDE renamed as a accDR. (unless you're using some type of
system to provide a shortcut to your application, and all of which be using
that shortcut).
So, if the user has the runtime installed on the computer, renaming the file
to accDR extension is not necessary, and will not produce any different
results when the application is double clicked on to be launched.
However if there is the possibility that the user all have the full edition
of MS access, **and also** there's also the possibility that the user will
be double clikcing on the front end file you send them, then then yes you
should rename the file.
However your development practices should be such that when a user deploys
the application to the full addition, or the runtime addition, they really
don't see anything different in terms of the user interface presented to
them. this pretty much means you'll have set up the startup to enabled
custom forms and custom reddens from the very beginning of the application
when it's launched.
Of course, during development, you will hold down the shift key so your
startup settings dont run. You then develop for awhile, and then to test in
"user" mode, you exit..and then re-enter the application without the shift
key bypassed. You will likely do this dance all day long as you run/test as
user mode, and then flip back in to developer mode (shift key used..so you
dont get the main custom menus). So, you cant develop, or really modify
things when you run your application with the startup settings...so you must
shift-by-pass them when you want to work.
And, in fact, I use alt-f4 to exit the application...the mdb/accDB file
should still be highlighted in the windows explore..so, then you hit enter
key (and, hold down shift key if you need be). This key stroke sequence and
exiting and re-entering the application will occur CONSTANTLY all day long
when you are developing.
When you finally have things just right...you create the mde (or accDE)
you plan to distribute for your users...
