How best can I set and maintain a string for Application
path to be used any where in a VBA for Access?

I inherited a database, partially designed in 1999 by
someone with far more knowledge of ACCESS than me. I would
like to learn a few things about the logic used in the
design, as I try to simplify it for our use. He created a

Can anyone help me understand this Method?  I have a form
that when I try to print, I get the message "Can't open
any more tables".  I can Print Preview the form OK, but
when I try sending it to a printer, I get the "Can't open

I am trying to copy and paste (with a new name) a table in my database, but
get the following message when I try to do the "paste":
"the Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time"  ... I

I have an Access 97 database that uses ole objects from MS
word. Everything worked fine until I updated to Office
2000. When I installed Office 2000, I found out that I
could not use the database without updating it and saving

For the life of me, I can't figure out why my fonts aren't
accessible!
From within Access XP, I select Tools, Options, Datasheet
tab, Fonts.  The dropdown box has no fonts listed.  What

The database I have built is being shared by 5 people and
I've split it as recommended.  I have the database in
a "sandbox" area for the group to explore, the front end
files have not been put on their workstations yet--it's

I have created 4 databases for our HR division at work.  
All 4 databases reside on our network -- and user's have
shortcuts to each database on their desktop.  My problem
is that in 3 of the databases, I have created security

I currently have a secondary limited account setup on my
Winbdows XP machine. When the account status is set as
limited the user has no access to the internet but can
use yahoo messanger. When the account is set to

Is it possible to run access 97 and access 2002 on the
same computer(worstation).  If this is so how is it done
tks

Will Access 97 work with Windows XP, either Professional
or Home?

I have a database that will be used by multiple users.  As
advised in all the literature, I have split the database.
My question is where should the front end file reside on
the users' workstations?

Dialing from Outlook is simple and easy.  I need that
ability in Access.  How can i do that?

User wanted control to change look of forms.  Tried on
own to set dbase so no one could change the dbase or
forms.  Changed unknown settings on dbase so that no
design view is possible and you can not view tables or

I would like to over ride system restore so I restore my
computer back where it was before my borther in law
thought he help by making administrator and now I have
limited access.  Can't find administrator and never got a