Problem upgrating from A2000 > A2003

F

Filips Benoit

Dear All,

Access adp on sql-server 2000

After upgrating to A2003 updating data with a combobox the program hangs.
Traying to change te combobox recordsource i get this error:

This version of Microsoft Access doesn't support design changes to 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.

The solution in :
http://support.microsoft.com/default.aspx?scid=kb;en-us;313298

tolks about SP 'dt_verstamp007' but I have dt_verstamp006

What should I do.
Is the failure of the combobox also caused the absence of dt_verstamp007
???

Filip
 
S

Sylvain Lafontaine

Have the latest service packs for SQL-Server been applied?

Here is the code for dbo.dt_verstamp007:

/*
** This procedure returns the version number of the stored
** procedures used by the the Microsoft Visual Database Tools.
** Version is 7.0.05.
*/
create procedure dbo.dt_verstamp007
as
select 7005

GO
 
F

Filips Benoit

The updating-problem with the combobox was caused by a to complex
recordssource of the form.
Strangly it worked perfect in access2000.

Filip
 

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

Top