multiple-step operation generated errors

[Mark Gordon]

I am using Windows 98se, Access 2000.

I've done a lot of programming in Access and wanted to start working with
MSDE.

I installed MSDE and created a project with no trouble.

When I create a table I get "multiple-step operation generated errors".
Anytime I try to open the table I get the same message.

I'm stumped.

Thank you.

 

[Steve Jorgensen]

I am using Windows 98se, Access 2000.

I've done a lot of programming in Access and wanted to start working with
MSDE.

I installed MSDE and created a project with no trouble.

When I create a table I get "multiple-step operation generated errors".
Anytime I try to open the table I get the same message.

I'm stumped.

Thank you.

Sometimes, you can get more detail on what caused that error by looping
through the connection's Errors collection. Be sure to use the same
Connection object, referenced by a variable to check the Errors collection
that you used to execute the statement. CurrentProject.Connection will not
give you the same instance each time.

I find that when the Errors collection does not provide the detailed error
information, it usually means that I have a mismatch between the number of ?s
in my SQL statement and the number of parameters I'm trying to add to the
Command object's Parameters collection - yeah, real helpful error message, eh?

 

[Mark Gordon]

Steve,

I think I follow what you are saying, however, I am not doing any of my
operations in code. All of the steps I described are through the Access
GUI.

Mark
(e-mail address removed)
314-647-4187

Sometimes, you can get more detail on what caused that error by looping
through the connection's Errors collection. Be sure to use the same
Connection object, referenced by a variable to check the Errors collection
that you used to execute the statement. CurrentProject.Connection will not
give you the same instance each time.

I find that when the Errors collection does not provide the detailed error
information, it usually means that I have a mismatch between the number of ?s
in my SQL statement and the number of parameters I'm trying to add to the
Command object's Parameters collection - yeah, real helpful error message,

eh?