I am using Access 2003 and have created an .adp, the back end is SQL Server,
I would like the ability to link to a text table located on the network.  I
get the following error when I try to do this.  "You cannot link to tables in
file 'filename.txt' because your Access project ...

I have a form with a subform embedded in it.  The sub form is continuous
forms and uses a view as the data source.  In the footer of the form I have
several fields that are total fields for the sum of fields in the main body
of the report.  ie in the detail I have a field which ...

Hi everybody.
I have a master table
Table: PROJECTS
ID_PROJECT

Greetings all.  I am using Access 2000 and SQL Server 2000.  I have a form
with subform for comments.  I was receiving errors that said "the data will
be saved but can not be displayed...", and found a KB article saying it was
an issue with ADP 2000.  So, my solution was to ...

I am a first time user on access and trying to copy and paste the SQL
content in an ASP file; however, my output has duplicate content. Is there a
comment used in the SQL I can use to get one time content.
Please advise.

when i am setting up my email what do i put for the smtp server. it keeps
saying that what i am putting is not correct. anyone know what i should do?

When a form was bound to a jet table I could get the new autoincrement
pkey value in the before insert event. Is there a way to do with with a
slq server 2005 odbc linked tables? Something like the dbSeeChanges
param that one can use with recordset inserts?

I'm developing a VB6 application with a MS Access 2000 database (for
reporting purposes etc.) using an ODBC link. Some tables of it are linked
(another ODBC link) to a SQL Server 2005 database. I need to show some
records in my application coming from a MS Access query running on ...

I have a rather complex inquiry screen that calls a dynamic sql sp to return
qualifying records to a continuous form.  What I would like to do is to offer
a the users a way to get a report of the resulting set.  To offer it here to
the users means that they don’t have to go to a ...

In Access 2007 the accdb supports a feature Collect Data via Email which
dynamically creates an html form in an outlook email message from which the
response automatically updates the database.
I could see plenty of use for this functionality in my own ADP application.

anybody give me the bulk insert query
thanks,
Siva

me llamo richard .... soy de venezuela ..
chaoopp

If in an ADP you open a Report using a Stored procedure and set the Input
parameter as e.g
@orderno int = Forms!Orders.Orderno and you have a subreport Order lines
which is more efficient

I have an adp linked to SQL 2000 back end. I have a from from which the user
selects a month by clicking on one of a group of radio buttons (Frame2) and a
year by selecting from a list (List470.) After making the selection, the user
clicks a control buttton with the following ...

I am trying to do a simple select and part of the selection criteria is a
GUID column from a SQL table.  How do I get the value and not the ???  Below
is what I have
Strsql =  "SELECT ExhibitorAddressID " & _