Access 2000 support

[Bernard Harris]

I have created an access 2003 project but when I try to create a view in the
view designer I get the following message:

"This version of Microsoft Office Access doesn't support design changes with
the version of Microsoft SQL Server your access Project is connected to." I
am using Access 2003 and am connected to SQL server 2000. I went to Microsoft
's office website and downloaded the SQL Server Desktop Engine but when I try
to load it I get:

"A strong SA password is required for security reasons. please use the SAPWD
switch to supply the same." We use the windows 2000 operating system.
Any suggestions?

 

[Brian]

I believe this is an MSDE installation issue. There is a command-line syntax
to use when installing it that sets the strong SA password. Don't run it by
double-clicking the icon. Instead, open a command-line window, browse to the
location of the MSDE setup.exe, and type something like this.

setup sapwd="<EnterPasswordHere>" instancename="SQLServer"