Microsoft Partner
this is the latest version of security update, the
"March 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting

In MS Acces Application front end, I used local tables to do some works. In
ADP project, I can't do it; So I have to use temporary tables.
I would like use this kind of table during the ADP connection.
Can I do it with the term : create table ##Tab ....... ?

I have a message "3704 Operation is not allowed when the
object is closed"
Can you help me in this case ?
Thank you in advance.

I have an Access XP project, connected to SQL Server 2000 and it's working
fine in the local network.
I have a laptop that I want to install the project on it and work remotely
with current data.

Hello erverybody,
Can someone tell me what the best way is to use a dsn-less connection code.
Should i use it in a form or use it in a module?
Greetings,

Hello, there, I am trying to learn adp and got some questions. I
downloaded a SQL Evaluation from Microsoft and made a simple DB. Then
I create a adp using Access 2002 by choosing 'existing data'.
Everything is fine, I can see the tables I built in SQL Server and I

I am designing an application utalizing SQL Server 2000
and Access Project 2002 technologies. We are considering
using run time versions of Access 2002 for the
distributed application. All of the future users of the

I have an Access2k application that I am trying to move
the BE to MSDE. I have loaded MSDE and copied the BE table
to MSDE. I copied the Application, placed it in it's own
directory and renamed it. I was able to link to the

In my Access 2000 project, I have a form in datasheet
view.  When I open it now, I see all my records.  I would
like to open it to see a blank form where the user can add
a new record but also query existing records.  Someone

In order to use Olap up against my SQL server i got some hints in this group
about i should use the PST from the SP my SQL is running. But what if i dont
have any SP on my SQL?
There is a special applikation thats running on my SQl that does not work

I've done extensive designs on forms that I have exactly
the way I want a user to see them, however I need to have
users perform data entry over the web.  Data Access Pages
seem like the perfect solution however I don't want to re-

in msaccess i can refer to the name of the result column, max(id) as tmp,
here I can use "[tmp] * 10" f.ex. in another column, how can I do this in
mssql2k/msde2k ?
- Magnus

don't post your true email on this page - you will get
scores of virus-containing messages.  unfortunately, i
learned this the hard way.

I use the date and time functions on forms and reports in
my Access/SQL Server project.  When I run the ADE on the
local machine everything works fine.  When I run the ADE
on a Terminal Server I get #name? in various date and

We are testing out some rights and issues with an .adp
project.  When I log in with my normal account and install
the .adp project with the MSI Installation package, the
database installs and works just fine.