ANYONE EVER DESIGNED A DATA ACCESS PAGE???

[MelF]

I have a form based on the table Customers. Now I've developed a DAP that also has the Customers table as its record source. My DAP fills out fine and saves fine; however, this data is not populating the Customers table. Any idea what's going on?

 

[Mongooses]

There are a few things you need to check - first look at the data properties of the page and ensure that a recordset has been selected (or you could click on the field list and see if there is a table associated with the form) I suspect this is ok. The next thing you should look it at is how the page is deployed. If the page is on a server then you need to open the DAP and click SELECT PAGE from the EDIT menu. The look at the data properties and check the UserRemoteProvider this must be TRUE if you want to access this over the web and False if you are using it on a local machine. There are many security issues as well with DAPs. I suggest that you look closely at

http://msdn.microsoft.com/library/default.asp?URL=/library/techart/DeployDAP.htm

HTH,
JC

 

[MelF]

JC - Thanks so much for the suggestions, I've already started reading up on those links you gave me.

One question - At this point I'm not really ready to publish yet. I just want to make sure the page is working with the table before sticking it out somewhere. I'm confused because my table is populating the page, but the page is not populating the table. Shouldn't this be working despite how it's going to be deployed?????????

Thanks!!