Access 2003 and SQL Server 2005. Impossible?

  • Thread starter Thread starter rop
  • Start date Start date
R

rop

I am also receiving an error when I am trying to design or modify a SQL
Server 2005 object under an Access 2003 project. I was not able to obtain an
upgrade or a Workarround or some information.Could someone et me know how
can I solve this issue ?
The error message tell me that I need to go "office update" but all
criticals fixes are installed.Thanks in advance
 
I do not think you can use APD to make an application on SQL Server2005, at
least for now, until MS makes a Access2003 compatibility patch, like they
did to Access2000 when SQL Server 2000 was released. But I do not expect MS
would do that. With Access2003 APD, you may be able to browse tables, but
you cannot actually edit things as you do with SQL Server 2000. Remember,
SQL Server 2005 is released almost 3 years later than Access2003. I do not
even know upcoming Access2006 (Office12) will support ADP or not (At least
for now, the Access team in MS itself recommends using *.mdb as SQL Server
front end, instead of *.adp. That is what I've heard).
 
Back
Top