Search results

Thank you. I'll try save as txt - other does not work

I was working on subreport (Access 2003 or 2007). Everything was ok. Then suddenly it does not open anymore neither in design nor in preview. Instead a pop-up appears: "There isn't enough memory to perform this operarion. Close unneeded programs ...". The data source for the subreport is a...

You won't believe it - but this function works ok without special referencing a library - windows library is referenced by default? Thank you Mike!

Thanks. I forgot to which library "WScript... " belongs?

Access 2003/2007 Application.CurrentProject.Path - returns mapped drive path. Question: how can we get full network path, smthng like \\server\sharedrive\etc ? Thanks

Aha! looks like it works ... Thank you, Bob

Thanks. Problems: There is no Visible property on the form. So I placed on Form_Load me.visible=false does not work On Unload code works ok.

I see ... so ... THANKS! Let me try it

I have Access 2007 front end to SS2K8. I have a local audt table that writes the date/time of user login. When the user closes the db by clicking Exit button the info from this local table is sent to Sql server back end. But ... when the users clicks X button it does not happen. Is there a VBA...

Guys, I found the solution (probably just for SS2K8 and earlier versions) - I changed datatype from nvarchar(max) to text - and now everything works ok. Thank you for having fun with me! Val

SQL-Hell: if not a driver - then Access. We know that both (n)varchar (max) and memo are not stored in the table (record size cannot exceed 8 kb), the table field has only pointer to external space where these fields are stored

Mike, you are right. But ... try to link you SQL Server table to Access and see - the (n)varchar(max) field is truncated (as we know now - to ~ 255 characters cut from the end of the record). And my problem is that users need to see the whole record in their Access reports Thanks

SQL-Hell: do you mean that (n)varchar (MAX) was not truncated in your Access applications?

I understand that truncation happens in the driver code - (both SQL Native client or ODBC driver for SQL server). Bob: varchar (8000) is NOT truncated, but we cannot jump the 8000 byte treshold (that means 8000 ascii characters) - this is the size of the SQL server page, and the record cannot be...

Yes, I'm using SQL Native Client 10

Bob: Interestingly, when I deal with these tables through stored procedures/ADO command/Recordset I have to change the type cast (CaseSummary as Text) - CaseSummary is the name of the navarchar(max) field - then I have the whole record. If I do not cast it - it returns in Access rubbish like a...

Mike, these limitations of Memo fields existed in all earlier versions of Access. My maximum size of the text in this field of SQL Server table is currently less than 12,000 characters. Note that Access prototype of this application had Memo field with the same records - and no problem of...

Bob, sorry. It's longer: convexity stroke. Brainstem reflexes are present. Prognosis not good in terms of functional recovery. Tube feedings started Family initially wanted aggressive care , then decided against trach and ventilator was withdrawn and patient expired 4/16/2012. So it was...

BobLarson: Yes, it is truncated. What I see in Access: convexity stroke. Brainstem reflexes are present. Prognosis not good in terms of functional recovery. In SS (i highlighted what was not truncated in Access): (Related Case #2912) 71 year-old female with a history of multiple strokes...

My Access 2003 (or 2007) has linked tables to SQL Server 2008. Forms, reports and queries are, naturally, local. Problem: all data nvarchar(max) fields are truncated in some very wierd way. How can it be fixed? Thanks