Problem upgrating from A2000 > A2003

  • Thread starter Thread starter Filips Benoit
  • Start date Start date
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
 
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
 
The updating-problem with the combobox was caused by a to complex
recordssource of the form.
Strangly it worked perfect in access2000.

Filip
 
Back
Top