Access deleting comments in views and select SPs

[belovedcej]

Okay - this will sound crazy - but I don't have enterprise manager (don't know why - and I don't make a fuss.)

So I do all my server development using the Access IDE - tables, views, SP - everything.

When typing Alter procedures, I can include comments and formatting no problem.

But when making views OR a stored procedure that is little more than a select query with a single parameter, any formatting or comments I include are deleted.

Has anyone dealt with this before? Any magic "fixes?

 

[belovedcej]

well, if anyone runs into this problem, here's how I fixed it. Actually, the help files in Access had the answer.

I open my view in design view, right click to get properties, and type my comment into the dialog that appears. I don't know if the comment shows in enterprise manager or not, but at least I can comment things now.