Would someone provide a gentle explanation of how programs such as Adobe
Acrobat and Crystal Reports are able to add toolbars to the Access UI.  (So
that when you start msaccess.exe these toolbars are visible immediately and
do not depend on a database being open).

I've got a "base.mdb" secured with "system.mdw". There's also a
password set on "base.mdb" . After configuration ODBC driver ( system
DSN ), supplying user and his pass too, when I try to connect do it I
receive error "Invalid password". What I'm doing wrong ? Is it related

How do we open up an MS Access ".mdb" file (from Office 2000 format I
think),
WITHOUT the macros running?!
Our MS Access guy is on holiday for 2 weeks.

I'm sure this has been answered before but I can't dig up any posts that
give a good answer.. and I'm sure I've come across it before but forget how
I dealt with it.
I have an ADP (A2000, SQL2000). I have a form with a linked subform. The

i recently started using .adp project file in access 2003 with sql
server 2000 as backend. when using regular .mdb in access 2003, i could
call a module in a query simply by writing for example: Calc: Sum(A,B)
where i had a function in VBA for example:

I am getting an intermittent problem when I try to create an Outlook
mail item using access vba. Having tested if outlook is already running
so that I can either create an outlook.application or get an
outlook.application, I sometimes get error 70 permission denied. I

I'm curious to know if anyone in the group can recommend any free
Access2003 applications that are available for download and which
feature great interface (ie GUI) design?
I'm looking for inspiration for a major project I'm about to begin. I'm

   I created a database for a friend a few months ago which has been
working fine. However, he now wants a few changes implemented to accommodate
his growing needs. When I gave him the database, I split it in anticipation
of this so that I could give him a replacement fromtend ...

I am getting a type mismatch message under strange circumstances.
Here's whats going on:
1.  I have split the database into a front end and a back end.
2.  I have compiled the project.

Bear with me for all these questions which may be basic.
We are planning to move our Backend from Access to SQL Server
enterprise.The front end would remain Access.The SQL Server group in
our organization is allocating servers to us.As a lead developer of my

We've fooled around with Access a bit, but only using the
single-user store-bought version. It seems to be a good
database - versatile and infinitely programmable - and
can apparently be used as a front end to SQL server if

The error occurred in line #5130. Ideas as to why?
qryITSLetterList returns 1 single record - but I don't
think that should be a problem. Hmmm???
5100        Dim MyDB As Database, rstITSLttrs As Recordset,

I was wondering if anyone could help i have picked this database up
from a
designer who has now left the company. The code is a couple of years
old.

I am getting and setting registry values successfully with two functions
from
the Getz/Litwin/Gilbert book: adh_accRegGetVal and adh_accRegWriteVal.
I have two cases now where these do not work under Access 2002.  There is

I'm getting Error 3051 with the following snippet of code.  What I'm trying
to do is to open an update version on the server (ServerFile) to check it's
version number in a front-end table(VersionRef) and compare it with the
version number of the LocalFile which has the same ...