Unanswered: Help Field size SQL 2000 / Access 97 failure
Hi, I am in a very tight position right now. Any help
would be much appreciated.
I needed to make three nvarchar field sizes larger. I did.
There is an Access 97 db linking to this table. I deleted
the previous link to the SQL and created another one. I
had to rename it as it was named dbo... and all the code
called to it without the dbo. After this update, a
function or access module which appends data to this table
stopped appending. The query looks as if it is handling a
large amount of data but then nothing is added. No error
messages. I have tried everything I know how to do.
You would think this would be an easy task?
Amazing. I have spent all day on this.
Any suggestions or explanations?