G
Guest
Hi, I am in a very tight position right now. Any help
would be much appreciated.
I had to make three SQL table nvarchar field sizes larger.
I did that after backing up the table.
There is an Access 97 db linking to this SQL 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 even reverted back to the previous field sizes in SQL
table and relinked in Access with NO success? I don't
understand the problem here? Does it have anything to do
with changing the field size?
I have tried everything I know how to do.
Any suggestions or explanations?
Thanks,
Kerri
..
would be much appreciated.
I had to make three SQL table nvarchar field sizes larger.
I did that after backing up the table.
There is an Access 97 db linking to this SQL 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 even reverted back to the previous field sizes in SQL
table and relinked in Access with NO success? I don't
understand the problem here? Does it have anything to do
with changing the field size?
I have tried everything I know how to do.
Any suggestions or explanations?
Thanks,
Kerri
..