Not sure how this happened, but my Access 2003 ADP database is not
prompting users for a connection password.  I looked in the database
Connection properties (i.e., Data Link Properties dialog) and noticed
that a password is being saved such that users are never prompted to

I do some work for an small, but growing, international organisation on a
vouluntary basis because I believe it helps a lot of people enjoy life
better. I want it to prosper.
It is using an Access Database being developed by a buddy of the Chief Exec

In my adp, I have a VBA function where I need to create a view dynamically
and then open it.
But meanwhile I need to refresh the views list somehow, otherwise it will
bring up an error opening the view.

I'm using sql 2000 and Access 2003. I have a adp database that contains about
200 clients. Part of the data is the client's doctor, nurse and other staff.
I'm trying to figure out a way to develop something so someone other then me
can update the information. I'm need a way to ...

I read that Binary in SQL is the equivalent of Yes/No field in Access.
Yet I can't get a check box to the update the binary field. How do I go
about this?
Thanks

I have Outlook 2003 on Windows XP with all the latest Windows Updates.  When
a message comes in with a hyperlink to say www.google.com, it take about 30
seconds before IE will even show up.  Once IE opens, the page is show
quickly but they 30 second delay is consistant.

So what do you ADP guys use to write your Update, Append etc Queries?
Is there a graphical tool like there is in normal access?
Have a fairly complex Update to run, and I don't want to write it all in
SQL.

I have a form (FactoriesOrders )with a ComboBox and a subform (FOrders) that
show the results of an SP.
The SP has a parameter and I have connected the parameter with the ComboBox
@parameter nvarchar(15) = Forms!FactoriesOrders.ComboBox

I occasionally accidentally launch and ADP file when I've already got it
opened, and I'm sure some of my users do it as well.  Access, of course,
informs the user that it's opening the project read-only.  Does anybody know
off-hand if there's a way to:

I am a novice to Access and I have a small Access project file and need to
use the below, can some help me with formulating :
[subdate], [duedate] &  [shipmode] being the fields in a query.
i want to formulate

I'm having problems getting correct parameter values to pass to SQL Server
from C# code.
In my C# code, I assign a parameter '@appID' and give it a value based on
the option chosen by a user.

I know this has been asked before but I can't find an answer I
understand.  I am new to ADP and in many ways wished I had just linked
tables in an MDB.  Never the less, the power and flexibility for other
front ends when all is done has kept me pushing forward.  Microsoft

Forgive my ignorance here and if this is the wrong forum then apologies and
can you advise where it should go please.
I am a mere mortal who has developed an Access 2003 shared database that has
outgrown its original single use brief and is now in use across the

I have the following:
1. An Access 2000 MDB file.
2. The MDB file has all forms, queries, and code.
3. The 30+ tables are all linked tables to two back ends.

Good morning.  We are having an issue and would like to see what our solution
could be.  We have an Access 2003 Project (.adp) connected to a SQL 2000
Server and all works great.  We are adding an additional link to a SQL 2005
server.  When the views are run individually, they ...