Database Startup in Access 2003

[silva]

Due to irritation with that stupid security warning when starting up a
database, I employed the following script to start one:

-------------------------------
Const cDatabaseToOpen = "<filepath>"
Const msoAutomationSecurityLow = 1
On Error Resume Next
Dim AcApp
Set AcApp = CreateObject("Access.Application")
If AcApp.Version = 11 Then
AcApp.AutomationSecurity = msoAutomationSecurityLow
End If
AcApp.OpenCurrentDatabase cDatabaseToOpen
If Err = 0 Then
AcApp.Visible = True
AcApp.UserControl = True
Else
AcApp.Quit
MsgBox "Failed to open '" & cDatabaseToOpen & "'." & vbCrLf &
Err.Description
End If
-------------------------------

And due to the fact that it opened the DB in a smaller window, I created an
AutoExec macro to maximize the Access window on DB startup. However, the
macro only successfully maximizes the window when I open the DB without the
script. It'll run just about anything in the macro except for the maximize
command when I use the script. The following command was suggested for the
startup script, "Application.RunCommand acCmdAppMaximize", but I don't know
how to implement it as the code. It won't run in the .vbs script (throws up
an error), and I don't know any other way to do it other than using the macro
titled AutoExec.

Is there any way to get this to work properly? I'd like to get this to work
without need of certificates (not going to pay for one, and I don't have
administrative priviledges on this P.O.S. pc to install StartCert or whatever
it's called) or setting the individual pc's to low security as any DB I use
would be saved on a network drive that'll have the same path on every pc on
the network.

 

[Albert D. Kallal]

Why not just have the user set their security to low. Once this is done,
then they not see any nags at all.....

 

[Dominic Vella]

I agree that it is terribly irritating. I wouldn't reduce my security
level because I'd like users within a business organisation to think twice
before opening non-business databases, or any other MS-Office product with
macro's for that matter.

Once upon a time you could create the certificates for your own business
however this facility is no longer available. May be it opened a security
risk or possibly because licensing companies weren't getting as much
revenue.

The end result is that this security issue is here to stay until Microsoft
can come up with some other clever method handling this matter, which is
probably Not in the near future.

Mind you, after explaining to my customers the reason for the security, and
they have gone through the motions of starting up the databases a few times,
they get used to it.


Dom

 

[a a r o n . k e m p f]

I think that Microsoft purposefully handicapped Access, because they
understand that Jet is a disease and should be discarded.

Excel has millions of macro-viruses.. and yet they decide to pick on
MS Access, instead.
and they prompt, like what-- FIVE times?

It's just a symptom that MS hates Access, they're an Excel-centric
company.

-Aaron

 

[Aaron Kempf knows nothing]

"a a r o n . k e m p f is a disease and should be discarded.

 

[George Hepworth]

At the risk of sounding hypocritical, I can't help but point out that ONE
irrational troll posting non-sequitars in these forums is quite enough
distraction.

Occasionally there is a need to post corrections to some of the troll's more
egregious mutterings, especially when it is clear that they might lead an
innocent novice astray. Even then, some of us probably go to far from time
to time.

However, posting taunting remarks such as this surely serves no useful
purpose for the community as a whole, as amusing as they might seem to be.


George


"Aaron Kempf knows nothing"

 

[Danny J. Lesandrini]

Some of these posts appear to be from trolls, and I suppose there's little
one can do about those. This newsgroup seems to be the unhappy recipient
of others because it's alphabetically the first.

Could one or more of our MVPs request that Microsoft set up a decoy group
that would come alphabetically before microsoft.public.access? How about
one of these ...

microsoft.public.aardvark

or a better decoy might be these ...

microsoft.public.aa.your.email.questions.qnswered.here
microsoft.public.aa.having.trouble.connecting.to.internet
microsoft.public.aa.test.your.newsreader.here

Just a thought.

As for Aaron Kempf, I think he's an asset to the community in many ways. First,
he *is* an expert on ADPs, as far as I can tell. I've had off-line discussions
with him and I'm impressed.

Aaron's zeal for ADPs and his approach may put some off, but frankly, it's his
love for them that prompted me to put the last two apps I built from scratch
into ADPs and I'm glad I did. They were fun to build, perform great and have
allow me to expand my toolset.

I hope putting in 2 cents in Aaron's behalf doesnn't start an argument. There's
no need for that. Room enough for everyone, isn't there?

 

[George Hepworth]

Danny,

No one would argue that he is not passionate about ADPs and SQL Server;
he's made that clear enough <LOL>. I'll have to take your word for it that
he is has skills with them. Nothing he's posted here would suggest that
except in a very indirect way.

However, that's not really the point.

The point is that for at least the two or three years that I've hung around
here, nearly every question he has answered, regardless of the actual
CONTENT in the question, has been a variation of "You have a problem because
Access sucks. SQL Server is good. People who use Access are stupid."

Okay, we get it, Dude. Aaron hates Access and Access developers. Let's move
on, okay?

I'd be hard pressed to locate more than one or two posts in which he even
made an attempt to address the actual content of the question posted. It's
sad and regretable because that approach does him and his "cause" more harm
than good. People have stopped taking him seriously because of it. That's
just about the saddest thing I can say about any person; he has become a
standing joke.

George

 

[Tony Toews [MVP]]

Aaron Kempf knows nothing

"a a r o n . k e m p f is a disease and should be discarded.

As much as I dislike Aaron please don't post such attacks.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

Maybe you should catch a clue and start using SQL then

 

[silva]

It would seem that my question about trying to properly maximize Access upon
opening via VB script will go unanswered. As annoying as it is, I guess I'll
just deal with the security warnings.

Based on what I've read in the replies, I'll say this... I've used both
Access and SQL (or some variant), and I found that both have their avantages
and disadvantages, and places where one will be more useful than the other.
So let's leave it at neither one is better than the other.

 

[George Hepworth]

Case in point, no?

message
Maybe you should catch a clue and start using SQL then

 

[Danny Lesandrini]

Yes, Aaron is a zealot and the approach he's chosen to advance his
cause is virtually ineffective. I can't argue with that, and for that
matter, I'm only now getting back to reading the newsgroup, so I'm
not so familiar with the recent content of his rants. Years ago, as I
recall, there was actually some content in his message

Aaron should read How To Win Friends and Influence People by Dale
Carnegie. Actually, I recommend this book regularly to everybody.

http://www.amazon.com/How-Win-Frien...bs_sr_1?ie=UTF8&s=books&qid=1233596314&sr=8-1

 

[John W. Vinson]

Aaron should read How To Win Friends and Influence People by Dale
Carnegie. Actually, I recommend this book regularly to everybody.

I think he's been working from the companion volume, How To Lose Friends and
Alienate People.

 

[Gina Whipp]

I needed a good laugh!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[a a r o n . k e m p f]

wrong.

Access has a place-- it is merely a frontend to SQL Server

jet sucks and it always has.
If you use Jet, you should go and take a class on SQL Server--- it's
just a much much much more advanced database

but at the same time, it's easier, simpler, more stable.

there is no benefit to Jet.

SQL Server has better design tools.

it's just pointless to use an old database format.

 

[a a r o n . k e m p f]

yes, I do have a copy of both books.

but I mainly spend time in computers books; I'm sure.. I'm _POSITIVE_
that I have a better library than anyone else on this group

 

[Danny J. Lesandrini]

Aaron, I wouldn't say it's pointless. I mean, I love SQL Server for
all the reasons you mentioned, and many more, but there are clients
I have who simply cannot afford or will not expend the money for
SQL Server.

I suppose MSDE or whatever it's being called these days is an option,
but I had a bad experience with MSDE when it first came out, and I've
never been able to trust the platform, which brings us back to JET.

Additionally, there are applications that simply don't require the power
of SQL Server, nor the security, nor the other features.

I'm into Astronomy these days and it would be great to have the Hubble
Telescope in my back yard but weighing the costs, I decided an 8"
Celestron SCT would do. Same with Access, JET and SQL Server.

By the way, I was hoping to show the group that there exists another
side to you. You could do so much good as an ambassador for ADPs
if you simply softened your approach. Just my 2 cents.
--
Danny J. Lesandrini
(e-mail address removed)
www.amazecreations.com


wrong.

Access has a place-- it is merely a frontend to SQL Server

jet sucks and it always has.
If you use Jet, you should go and take a class on SQL Server--- it's
just a much much much more advanced database

but at the same time, it's easier, simpler, more stable.

there is no benefit to Jet.

SQL Server has better design tools.

it's just pointless to use an old database format.

 

[a a r o n . k e m p f]

SQL Server is the same price as Jet. Free.

SQL Server 2005/2008 Express has no real limits.. I push a million
reads a day from SQL Server Express without a problem.

I really don't know where you get off-- tellnig people that SQL is
more expensive

 

[Danny J. Lesandrini]

IAaron:

t's sad that you're so angry. I don't want to see your posts anymore.
As it turns out, I have the power to block them. Bye.
--
Danny J. Lesandrini
(e-mail address removed)
www.amazecreations.com


SQL Server is the same price as Jet. Free.

SQL Server 2005/2008 Express has no real limits.. I push a million
reads a day from SQL Server Express without a problem.

I really don't know where you get off-- tellnig people that SQL is
more expensive