Data type changed when linking table from Access 97 to Sql Server 2000

M

M Wang

Hi All,

Recently I moved all the tables of a MS Access 97 database
to the SQL Server 2000 using DTS, and I kept all the
queries, forms, etc, in Access 97. The MEMO type in Acc97
was changed to NTEXT type in SQL. After I linked the table
from Acc97 to the SQL server, I found that the data type
was changed to TEXT in Access. Since the size of the TEXT
type in Access is 255, errors happened when I had a long
text. Since I have to keep the Access97 front end, does
anybody have suggestion?

Thank you,
Michelle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Custom Data Types Not Visible In Access Linked Tables 1
Cannot link to SQL server 17
Memo filed in SQL-server with Access 97 0
Issue with Data Types when linking to SQL Server 2
Linked table column type changes from text to memo 1
Move Access Table to SQL Server 1
Append data to linked SQL Server 2008 table 0
Conneting to SQL server, Need advice 4

Top