新聞財經娛樂♬資訊 News Economy

As an act of desperation, noting that it only happened with a single user, we created a new AD account for her, and it worked fine.  The original account had all the same correct permissions, and we have no idea what the problem was.  However, it's solved now.  Thanks for the help everyone.

Andrew

Try to look for  in google for Digital Certificate for  Macro or Aplication or http://msdn.microsoft.com/en-us/library/aa141471(v=office.10).aspx
It might be Security issue on the your Excel application or sheet, so other users might
not get the most of your  update .

Hope it help

Duncan

Nobody really has any ideas about Excel's behavior here?

Andrew

Nothing is changing in MS Access - it's existence is irrelevant to the issue at hand. What is changing is the order of the columns in the Excel data table.  If I refresh the data table on my PC (or any of the others) there is no problem.  The columns are ordered as in the query.  If I refresh it on her PC, the column order changes.

Andrew

<As I ststed, the user has nothing to do with it...>
Well, you actually stated this:
<but you can never underestimate users, can you?>

So it was not inherently clear to me if this meant it was, or was not a user issue, or if you were not sure.


JeffCoachman

That's why I asked...
If the user can change the Column Order, then there really is no solution other option than to not allow them Access  to the columns directly.

Again, if it is just this one user and everything else about their setup is the same as the other users, then it would point to the user...

The issue is where are the columns being changed?
In Access or in Excel?

No progress on a solution.

OK, so where do we stand on his...?

mann: I know I can do that, but I need to figure out the problem, in case there's something else affected I've not seen yet.

jeff: yep, but you can never underestimate users, can you?

Andrew

Not sure either...

Are you quite sure that the user is not changing the column order?
;-)

JeffCoachman