ADP Read Only Problem

[Arturo]

I upsized a 2003 mdb to ADP and connecteed to a 2005 SQLEXPRESS database. I
am creating DAP's in it. It works quite well for me.

I needed two other tables after I did this. I Imported them into the ADP and
created a new page. I added combo boxes to the page in design view and used
one of these imported tables as the source.

It allows me to make a selection in the combo boxes. After I try to leave
the field I get a message saying the data source field is read only and
forces me to discard the selection.

Is there a way to make this work.

Thank you.

 

[Arturo]

Let me add to this post. I currently have the SQLExpress server on my local
hard drive. My plan is this. After the pages are created the SQL Server will
be set up on a web site. Therefore, I believe I can make multiple ADP's that
are connected to the SQL Server on my hard drive. After they are all ready, I
can redirect the connection string to the SQL Server on the internet site.

Is this doable?

 

[Paul Shapiro]

Check that the new tables have a Primary Key assigned in SQL Server. Without
that they will remain read-only in an ADP no matter what else you do. If
it's still read-only, post the Create Table statement and the sql expression
you are using as a record source.

DAP's have been deprecated for some time. If it does everything you need
then maybe that's ok, but you shoudl check that it will work with your web
hoster. If it relies on software components the host machine will not have
installed, it won't work there. If you're considering other data-driven web
page approaches, ASP.Net is the current Microsoft technology.

 

[Sylvain Lafontaine]

Let me add to this post. I currently have the SQLExpress server on my
local
hard drive. My plan is this. After the pages are created the SQL Server
will
be set up on a web site. Therefore, I believe I can make multiple ADP's
that
are connected to the SQL Server on my hard drive. After they are all
ready, I
can redirect the connection string to the SQL Server on the internet site.

Is this doable?

Technically, this shoud work OK but practically, it won't. Most web hosting
services will keep their SQL-Server safely hidden behind a firewall and
hosting services that will give you the opportunity of showing a SQL-Server
to the Internet will probably cost you a lot.

Of course, you could choose to host the SQL-Server on your own machine and
serve it to the internet but then real, big problem here will be that first,
a lot of potential users (most of them?) will be themselves located behind a
firewall so, unless they know how to configure it, they won't be able to
reach your own very little server and second and not the least, using DAP is
much, much harder than you might think it is after the first encounter.

They might be good for simple tasks but from the moment that you'll want
anything more advanced than basic forms, you'll hit a wall in term of an
exponentially increasing level of difficulty for designing and building
them.

It's not for anything that they have been deprecated by MS many years ago
and have been removed totally from Office 2010.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)