Tom,

In reality although the DTC's are a great idea they are very flaky. Far
better to learn to program ASP and ADO than waste time trying to get the
DTC's to work for you. See end of Chap 8.

I know this is probably not what you were hoping for but the best use
for the Data Environment is to be able to look at the db without having
to have Access or SQL open as well.

BTW Did you know you can create a SQL db with Access 2000? Create an
Access Data Project and it works like a SQL db in VID meaning you can
create tables etc.

HTH

Martyn

-----Original Message-----
From: Thomas Goyett [mailto:drchronos@y...] 
Sent: 27 February 2002 01:44
To: Interdev_Programming
Subject: [interdev_programming] Visual Interdev, Acess 2000 and Forms


Hi All,

I'm just starting out with the beginning book here and have typed in the

examples in Chapter 5 of the book the first one that gets into data
bases. 
The book gives instructions on how to do it in both sql7 and Access. I'm

using access 2000 with PWS.

In have in my property / data view window the wrox cameras data base
that 
I have copied in from the download and can go in there and from the data

view I'm able to edit and add to the data base and then save it and go 
into access and see that I'm actually altering the data base from
interdev 
and seeing the changes in Access.  

I can also go into the Global ASA file in the project explorer and see
the 
Data Environment and the wrox cameras. Below that I can also see the 
little sql icon for products that I made.  If I double click on that I
can 
see the results of the query that I've typed into it so I know that the 
sql is correct.

But when I actually get to the page itself thats where I get into
trouble 
I have dragged in the sql statement from under the global asa file and
put 
it in the page.  Then I dragged the data grid over and in its properties

I've made sure that its looking at sql1 which is the name of the 
recordset. I know that is working because I've customized the labels of 
the table rows.  So there has to be a connection between the grid and
the 
recordset there too.  

But then when I view the page in the browser there is noting on the
screen 
where the grid should be.  

It would seem that you can successfully use access 2000 with visual 
interdev so has someone actually gotten this to work?  Being that this
is 
the first try on the beginning chapters that leads me to believe that 
somthing in my definations isn't right and I'm not referencing the
opbject 
correctly or somthing because as I said I can see the record set created

by the queary and am able to enter data into the tables and then have it

show up when I open it independently in access.

Any one have any ideas about what I can do next?

Thanks in advance for any help that anyone can give me on this.

Tom Goyett
(drchronos@h...)

$subst('Email.Unsub').