Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access ODBC Client Server > Access 2003 wit...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 11 Topic 1406 of 1511
Post > Topic >>

Access 2003 with SQL Server 2005

by =?Utf-8?B?S2xhdHV1?= <Klatuu@[EMAIL PROTECTED] > Nov 7, 2007 at 07:05 AM

I have converted and mdb to an adp using the upsizing wizard.  There were 
multiple problems with queries being converted.  If I try to edit a query
or 
use design view on a table I get messages saying 2003 is not compatible
with 
SQL 2005 and no changes will be saved.
I tried creating a query in SQL, but then the adp has no knowledge of the 
query.
The messages state to look for an update that will allow 2003 to use SQL 
2005, but I cannot find if there is any such update.

The question then is there such an update or if not, what do I need to do
to 
be able to use this as an adp or do I just have to redo the conversion and

keep it as an mdb?
-- 
Dave Hargis, Microsoft Access MVP
 




 11 Posts in Topic:
Access 2003 with SQL Server 2005
=?Utf-8?B?S2xhdHV1?= <  2007-11-07 07:05:00 
Re: Access 2003 with SQL Server 2005
Stefan Hoffmann <stefa  2007-11-07 16:13:51 
Re: Access 2003 with SQL Server 2005
=?Utf-8?B?S2xhdHV1?= <  2007-11-07 07:21:06 
Re: Access 2003 with SQL Server 2005
Stefan Hoffmann <stefa  2007-11-07 16:44:40 
Re: Access 2003 with SQL Server 2005
"David W. Fenton&quo  2007-11-08 19:39:17 
Re: Access 2003 with SQL Server 2005
Stefan Hoffmann <stefa  2007-11-09 11:44:06 
Re: Access 2003 with SQL Server 2005
"David W. Fenton&quo  2007-11-11 14:27:06 
Re: Access 2003 with SQL Server 2005
"Sylvain Lafontaine&  2007-11-07 17:10:32 
Re: Access 2003 with SQL Server 2005
=?Utf-8?B?S2xhdHV1?= <  2007-11-08 08:22:01 
Re: Access 2003 with SQL Server 2005
"Sylvain Lafontaine&  2007-11-08 12:47:46 
Re: Access 2003 with SQL Server 2005
=?Utf-8?B?S2xhdHV1?= <  2007-11-08 09:57:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 1:59:35 CST 2008.