edit views sql 2005

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to edit/create views from Access 2003 adp when connected to
a sql 2005 data file. But now it is saying my version of Access does not
allow me to do that. Any work around?
thanks
 
The only work around that I can suggest is to use an Access 2003 MD
with pass through queries. I have tested these using both the new SQ
native drivers and the existing ODBC drivers and these work wit
SQLServer2005

It does mean that you have to do everything using TSQL, but it wil
work

Hope this helps. I presume MS will issue some kind of update for this
or will we have to wait for the new version of Office
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADP with SQL 2008 Express 1
Access 2000 and SQL Server 2005? 2
Protecing Design View on an ADP 7
Access 2007 Creating ADP (Access 2002 -2003 format) 10
Not able to create new tables/queries in .adp 4
Access 2003 ADP and SQL Server 2005 6
Access 2007 Front End for SQL 2005 35
Is adp or mdb better SQL Server 2005 front end? 6

Back
Top