access 2007

[sandrao]

Previously we were able to have Access open up to a designated form. This
info was in the start up procedure. How can I have the same results in
access 2007.
I would like to have a certain form appear by itself without the data
information appearing. Is this posssible.

 

[Allen Browne]

To specify a startup form in Access 2007:
Office Button | Access Options | Current Database | Display Form

To have the form load to a new record, set its Data Entry property to Yes.

 

[Albert D. Kallal]

there is number of ways to accomplish this.

however, the "new" trick is simply re-name the file extension.

A standard file name is:

You DataBaseName.accDB

Simply re-name the above to:

You DataBaseName.accDR

The "r" stands for runtime. You can also use a /runtime switch if you want
to make a shortcut for the user(s), and not have to re-name the mdb file.

You can also hit the official button, and then click on the "access options"
button (lower right of screen)...that button will allow you to turn off the
navigation pane, and set the start-up form..and a custom ribbon if you such
desire...

 

[Allen Browne]

Albert, do you have any info on this?

Do we rename ACCDE files to ACCDR as well?

Renaming an MDB to MDR and opening with A2007 doesn't seem to work.

The help file (HA10067831) says:
ACCDR is a new file extension that enables you to open a database in
runtime mode. By simply changing a database's file extension from
.accdb to .accdr, you can create a "locked-down" version of your
Office Access 2007 database. You can change the file extension back
to .accdb to restore full functionality.

The only reference I could find on ACCDR was for interaction with
Sharepoint:
http://support.microsoft.com/kb/926803/en-us

Is the runtime installer publicly released yet?

 

[Albert D. Kallal]

Albert, do you have any info on this?

Do we rename ACCDE files to ACCDR as well?

If we want to "hide up" things, then yes...I would suggest doing this.

in a20033 (or a2007), creating a mde never did hide any of the interface...

so, fact, for my a2003 "mde" files, I usually did provide a shortcut with
"/runtime" switch.

And, I even supplied that "/runtime" shortcut for users with the FULL
version of ms-access.

The reason why always provided a shortcut is because I always wanted to hide
the ms-access interface. If I use the access runtime, then I do NOT need the
/runtime switch. However, if a user all of a sudden gets the full version,
then my application is going to display a lot of extra things. So, even when
the user has a full version or runtime version of access I simply always
used the /runtime switch to hide things.

So, my goal was to keep the user experience *consistent* regardless of what
version they have.

So, now, in a2007, I don't have to provide a shortcut. (and, those pesky
uses can now browse to the folder,skip my shortcut..and STILL run in
/runtime mode).

I do think that this "R" use idea is much better for when using a mde
(accDE -> accDR), but you *can* use it for accDB.

to be honest, I never used the /runtime switch for a standard mdb in
a2003..and likely would not do so for a2007 (or, now use the "R" ability).

I don't like recommending here in the newsgroup that users just start willy
nilly re-naming file extensions (not the best thing to teach everyone!!!).
However, most machines have file extensions turned off by default. A good
number of users don't even know what a file extension is these days!!!

So, for budding access developers...if they don't (or can't) provide a
runtime shortcut..then the "R" idea is a rather nice option now...

 

[Allen Browne]

Thanks.

I only ever used the /runtime switch for testing purposes, but I like your
suggestion here.

 

[David W. Fenton]

I do think that this "R" use idea is much better for when using a
mde (accDE -> accDR), but you *can* use it for accDB.

But anybody could change the extension, so wouldn't you want to have
a check for the filename in your app's startup routines?

[]

However, most machines have file extensions turned off by default.
A good number of users don't even know what a file extension is
these days!!!

This is a terrible, terrible thing, and you should do everything you
can to get your users to *stop* working without displaying
extensions. Depending on hidden extensions is a form of security by
obscurity, which is no security at all.

 

[Albert D. Kallal]

But anybody could change the extension, so wouldn't you want to have
a check for the filename in your app's startup routines?

yes, that is a good idea/suggestion....