multiple-step operation generated errors

  • Thread starter Thread starter Mark Gordon
  • Start date Start date
M

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.
 
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.
Click to expand...

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?
 
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

Steve Jorgensen said:
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,
Click to expand...
eh?
 
Back
Top