Access 2003 project-SQL Express - cant save desig

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

Access 2003 project-SQL Express - cant save desig

Author

Topic

Gordon W
Starting Member

2 Posts

Posted - 2006-01-01 : 22:59:07

Hi

I have conntected an Access 2003 project to a database in SQL Express and when I try to create a new view or stired procedure I get the message

This version of Microsoft Access doesn't support design changes with the version of Microsoft SQL Server your project is connected to. See the Microsoft Office Update Web site for the latest information and downloads (on the Help menu, click Office on the Web). Your design changes will not be saved.

Is it a limitation or have I not got the appropriate permissions set up

And if it is a limitation does it matter

Thanks in advance

Gordon W

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-01-03 : 15:26:06

Hi Gordon,

This is a known limitation in Access. The problem is that Access is using VS 2003 designers, which are incompatible with SQL Server 2005. I don’t believe there are plans to change this near term for Access 2003. The text based “designers” still work; i.e. you can just type the SQL directly rather than use the GUI designers.

Hope this helps.

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Gordon W
Starting Member

2 Posts

Posted - 2006-01-03 : 17:25:29

Thankyou Paul, I presume you would still recommend using SQL Express rather than using MSDE, even though there are these limitations. Having decided to 'bite the bullet' and move my data from an Access back-end to SQL, I thought it made sense to use the latest SQL version? I would appreciate an opinion.

Thanks

Gordon W

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-01-06 : 16:11:17

Gordon - sorry for the delay in answering - I was checking with the Access team.

Creating linked tables inside an Access database (MDB) is the recommended way to expose SQL Server 2005 data inside Access 2003. Using Access 2003 projects (ADP) against SQL Server 2005 is not recommended at this time. Changes introduced in SQL Server 2005 have resulted in a number of issues that are exposed in Access 2003 projects.

If this works for you then I recommend you use SQL Server Express.

Hope this helps.

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

markc2
Starting Member

2 Posts

Posted - 2006-02-06 : 02:39:41

Paul,

Is there a time frame when an update to Access 2003 or a new version will come out where Access projects can be used with SQL Server 2005?

Thanks,

mark c

mikewa
Microsoft SQL Server Product Team

84 Posts

Posted - 2006-02-07 : 14:41:11

Hi Mark,

Sorry, we don't have a time frame for either at this point. As a matter of interest, you may want to check out the Access blog at http://blogs.msdn.com/access/. While the interaction with SQL 2005 is not discussed (yet) you may find the topics interesting.

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

markc2
Starting Member

2 Posts

Posted - 2006-02-08 : 01:53:41

Mike,

Thanks for the response. I'm working with a client whose in-house staff is currently working with Access so your link is appreciated. For now I/we will continue down the path of linking to SQL Server 2005 from Access as recommended.

mark c

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources