I made an .adp-file on my laptop and I want ot transport is to the
MSSQLserver on my work.
+ when I use the fucntion off access 2003 "extra" "database-utilities"
"database transport", access give me the message that there's no server

Hello everyone, sorry for the xpost, didn't know where to post.
I'm fairly new to Access, and I never used the DTS feature of SQL Server
2000 before. So I'm a little lost with my latest task:
using Access as frontend and SqlServer as backend with a DTS package to

I user one table for ProductSort ,and the fields like this-
ID|SortName|Notes|ParentID|
And if the one sort node have a son node ,
I let the son's ParentID=Parent's ID................

I am searching general information about ADP, Access&ODBC with SQL Server,
how to call to a store procedure from access, ...
¿Any webpage or tutorial?
Excuse my bad english.

Hi, I am writing an app in VB. I need SQL and so I am using Jet 4.0
In short, I am having trouble with an SQL query that involves data of
type BINARY in the WHERE statement.
Here's a resume. To show you my point pls download the small sample

I am building an Microsoft Access 2000 Project with SQL Server 2000. A
stored procedure displays all order lines for a given location. When I run
this stored procedure from the Access database window (and enter a
location), all order lines are returned and the data can be edited.

I'm developing an adp project connected to SQL Server 2k.
This will be used on clients with win2000, winXp Pro and winXp Home.
If I choose the integrated authentication, the adp/ade in the winXp home
does not work because it doesn't support this kind oh authentication.

I have a form (dialog form to display report) that has an unbound
textbox. I want to pass the value of this textbox to my report. But
how can I pass this value if i'm accessing SQL Server 2000 and
not the jet engine (mdb)?

I'm trying to use OpenStoredProcedure to execute a SQL query. Below is a
snippet of the relevant code.
stDocName = "sp_PXReport"
DoCmd.OpenStoredProcedure stDocName, acViewNormal, acEdit

i use to backup my tables using the adtg format (i.e. adPersistADTG used in
the save method of the ADO recordset).
I would like to build a procedure to recover my data from the tables saved.
Instead of writing lots of ADO code, i was wondering if it is possible to

I wonder if anyone else has experienced these filter problems I
have...
I have an Access 2002 adp connected to a sql 2000 server back-end and
a form that can be filtered using a similar 'filter form'. This builds

I have set up an Access Data Project to access my sql server and don't
know how to restrict access to tables while allowing the end-user to
create new queries.  In order to create a new "query" they can create a
view or stored procedure.  Is it true that they can only do this if

I have a ADP application that is used for reporting from a SQL Server
database.  Some users are having problems using the report, they get the
following error, "Cannot open user default database.  Using master database
instead.".  I have visited MS site for a fix

I am trying to get some data from a Quick Books file using QODBC driver into
Access. The tables can be linked okay but when the table is opened it takes a
long time to populate. After checking with the QODBC people they say their
driver works fine but that the problem is with ...

I have an access query for a report and I need to make it into a view for
SQL Server.  Here is the Access query,
SELECT CliEventTable.RegNo, CliCoreTable.CliDOB, CliCoreTable.CliSex,
CliEventTable.EventDate, Format([EventDate],"w") AS [Day], "Qtr" &