Fields in SQL Server database on Access 2000 front end

V

Vanessa

Hello,

I'm fairly new to Access so bare with me please! :)

I seem to be having a problem with fields in linked tables. I have a
SQL field of varchar 2000. When linked in Access 2000 it's a mem
field. When I place the field on a form, and reference the field i
another form, the data doesn't appear properly. Sometimes it picks u
the last work in the sentence and displays it, sometimes it picks u
parts of a sentence. I seem to be encountering this problem in a fe
places. Any suggestions anyone????

Thanks in advance,
Vaness
 

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

Losing SQL Indexes when linking into Access 2000 0
How to generate a GUID in SQL Server via Access 2
2000-2003 to Access 2007 Switchboard 1
Access mdb or SQL Server Back End? 4
How to link a Access FE to SQL Server BE 10
Access form with SQL Server Append Query 0
How to adjacent field from a record 6
Access on VPN 1

Top