Data Access Page

C

Chris

I am trying to create a data access page that connects to
a SQL server. Everything is fine until I go to web view
or page view. When I do that the navigation bar becomes
greyed out and I can't add any data.

I have checked permissions on the SQL server and all
looks well.
I have even tried creating a new db and new page on a
different server and it doesn't work.

any ideas? I'm guessing it has something to do with
access but i'm not sure what it is.
 
K

Ken Snell [MVP]

I believe that DAPs connect only to ACCESS database. You need to use ADPs to
connect to SQL Server.
 
G

Guest

I have a dap connected to a sql db but i cant get any new
ones to work. What is a adp?
 
K

Ken Snell [MVP]

It's an ACCESS Data Project. It's part of ACCESS, but you have to set up a
new database and make it that. I've not worked with ADPs yet, so you'll need
to look at Help and post with questions to the newsgroups. There is a
newsgroup for them:
microsoft.public.access.adp.sqlserver
 
Top