I'm trying to use the NorthwindCS.adp.  If I menu File!Connection..., I can
only sign on as (local) using NT credentials in order to see that
"Connection Succeeded."  If I try to connect using the machine name
ROBERT-0AX0AGG0 the connection will fail.  If I try to log in as sa, the

I've encountered a problem with reports not displaying
numeric data correctly with an Access 2002 ADP client
against a SQL Server database.
For example, with a numeric format and two decimal places

I have a subform in which the record source is the following Stored
Procedure:
***********************************************
Create Procedure WOApproveAccess_sp

 i'm using access2002 as my front-end and sql as my
database. i encountered a problem assigning my variable
to a textbox, it prompts me an error saying "you can't
assign a value to this object"

I am trying to apply SP-3. Here is what I get. Tells me it
can't install and then sends report to MS with error #
1601. Anyone know the fix?
Thanks

What are the advantages and disadvantages of developing a client-server
desktop application using Access ADP project as compared to a VB 6 or .NET
desktop application in a multi-user environment?
Is locking an issue with an Access project, for example?  I mean, is ADP

my ADP application makes 3 connections to SQL server..
when the adp file is running opens a form that display
data from a recordset.. and it doesn't have bound combo
boxes.. so I dont know why 3 connections ?

I have an MS Access Project using Windows NT Integrated
Security.  This works fine for local users, however,
remote users who connect and authenticate through the VPN
at Windows login cannot use the application.  They receive

I am trying to run Access based database into SQL server
2000. Now all backend tables in SQL server and query,
forms, modules in local (client) PC. sql SERVER gives
error as "zn is not a recognized function name" Can you

why my ADP application makes more than one simultaneous
connections to SQL server? Is there any way to control
maximal number of connections being created?
I use Access 2000 and MSDE.

I have an Access database running on a Windows 2000 Server.
All of my employees require access to the database to amend and update it.
But, I need to be able to stop people from being able to copy the access
data files from the server. I've tried permissions, but i didn't get very

I want to view the contain of the *.ldf file.
I try to edit this file using various editors, but i got the text unreadable
Is there any way to deal with it?
Thank you in advance

I have an ADP ptoject running OK on Access XP.
When I try to generate the ADE, I get an error message (in French)
Microsoft Access ne peut cr?er la base ADE
In English, it should looks like : Microsoft Access cannot create the ADE

I'm new in Access and I'm trying to count record on a field that has a
boolean type. I just want to find out how many true records are there ?

We have a fairly comprehensive Access DB and realize now that we need a more
scalable backend without the file size limitations.  I tried the upsize
wizard using MSDE and it looks fairly promising.  If anybody can help me,
I'm wondering: