Search results

yep the query worked fine, apart from truncating the message field..but the linked table did that too

Okeydokey, that query was written by my predescessor and I can see no reason why we need to sort by that column anyway so removing it makes everything work.. thanks for your help guys ill post here if the nvarchar(max) issue gest resolved at any point

Unfortunately taking this any further is beyond me, having scoured the net quite thoroughly now there doesnt seem to be a solution to it and im not experienced enough to fix this myself so I'll have to change to NTEXT until the problem is fixed.

It appears as text(255) - this is how I found out about the problems with nvarchar(max) in access 2003. So looking for now like I have to workaround it until a fix is available. MY query in sql view is as such SELECT tblmessages.ReportOrder, tblmessages.Hex, tblmessages.Status...

'There are problems with the support for nvarchar(max) in Access 2003. Replace this type with NTEXT and you should be OK.' http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.data.odbc&tid=b8e162dc-217b-43c5-8290-9bb98bc8a85d&cat=&lang=&cr=&sloc=&p=1

I can prevent truncation in the linked tables by using the NTEXT field type instead of NVARCHAR(MAX) However if I try to open an access query that links to the table I get the following error 'The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE...

Well the plot thickens.. the data is truncated at the end without using the data compatibility connection string (but my software did this as far as I know, it truncates to the field size unless field size returns '-1' as it should with nvarchar(MAX)) But either way the data is truncated at the...

Thanks! Interesting.. if I do this then the full string gets populated in the SQL table (if I look with the SQL Server mangement studio) However if I look at the linked table in MSAccess, the front is still truncated. Any idea why this may be? Is there any connection string equivalent for...

Hi peeps I'm having a problem where data is being truncated at the start when written into my table. It happens when updating a field with a string that is several thousand characters long. Apparently truncating at the start not the end is not normal behaviour for any database so im a bit...

According to that I'm already using the correct syntax, and the syntax used to work. All I've done is put an extra subform on the main form (which i want my code to ignore), there's no subforms within subforms or anything like that. edit: If I use Me.DisplayPanel.Form.CurrentView = 2 as a...

I have a bit of a problem with switching between form view and datasheet view now my main form has two subforms I used to use the following code Private Sub btnSwitchView_Click() intview = Me.DisplayPanel.Form.CurrentView ' change view If intview = 1 Then DoCmd.RunCommand...

If I were to approach this problem from a different angle. Is it possible to have a continuous subform with image objects referencing image paths on a hard disk? I can do this fine for a single form with one image, but I need a 1:many relationship with N images, with a different image...

im trying to follow these instructions http://support.microsoft.com/kb/175261 its asking me to create a class file though, im not even sure if i can do this in MSAcess! wah :S

Thanks kindly for the demo code. I included the MobBLob module in my client and tried the following: Dim strSQL As String Set rs = New ADODB.Recordset strSQL = "SELECT * FROM tblExhibitPhotos WHERE ID= 93 " rs.Open strSQL, gSQLdbase, adOpenKeyset, adLockOptimistic, adCmdText...

I think my database got corrupted... after following your suggestions my client broke in spectacular new ways I deleted my subform and rebuilt it from scratch and it seems to work now, thanks for your help D

Good morning I'm having trouble saving a bitmap from my database to file. It's stored as the 'Image' type in my SQL Server 2008 table, and is put into the table by simply dragging a bitmap file into a bound OLE object To retrieve it I'm trying the following code: Dim strSQL As String...

Hi all I'm very confused as to why my continuous subform displays no data even though I know it should be. If I do a record count of my SQL string: Dim rs As New ADODB.Recordset strSQL = "SELECT * FROM tblContacts WHERE UniqueRef = " & gUniqueRef & _ " AND DataSet =1 " & _ " AND...

Thanks. I'm successuflly updating the table with the following code, but I have one problem and one question. First here's the code I'm using: If Me.ReportAll = True Then strSQL = "UPDATE tblMessages SET Report = True WHERE UniqueRef=" & gUniqueRef Else strSQL = "UPDATE...

After a half day scouring the internet i have found the code I was looking for Me.Image.OLETypeAllowed = acOLEEmbedded Me.Image.SourceDoc = "firstTest.bmp" Me.Image.Action = acOLECreateEmbed

and to preempt any responses about it being a bad idea to store images in the database, I need a continuous form setup with N pictures that the user can scroll down and add more to. As far as I can work out this wouldnt be easily done with images stored in a folder. Feel free to correct me on...