Search results

Well this turned out to be quite the gem. Using SQL Server Profiler I can see that the VIEW_METADATA attribute solves my problem with the SQLOLEDB driver. If I alter the view in question to have the VIEW_METADATA attribute, my ADO calls using the SQLOLEDB driver now access the view instead of...

Hmm, this looks very promising and seems to explain exactly the trouble I'm having when I use the SQLOLEDB driver. Thanks for this tip, going to give this a shot today hopefully.

Most of the large files are large design files for a 3D CAD system. If I had the time I would definitely switch to the method you mentioned.

Yeah, a shared server unfortunately. No need to apologize for the hack, I am definitely not above hacking! That is actually a pretty good idea, going to look into that, thanks for the inspiration. Someday I dream of getting away from putting blobs in the database entirely and just do links to...

Poor Minty, I feel like I've been bugging you about this for a long time lol. I have tried different permission levels, no luck. I'm starting to think there's really no hope unless I A) Stop using MS Access and build my own app or B) Try using a different version of SQL Server. Neither of...

This problem is still haunting me so I'm going to bump it with the hopes someone else may have a similar experience. The problem is either I can't upload blobs over 150MB from Access front-end to SQL Server via ADO but at least the code recognizes views vs tables correctly (my permissions...

Well unfortunately I ran into an issue. Although this code can handle larger files, it seems that using the sqloledb provider instead of the SQL Server driver causes issues with tables vs views in SQL Server. I use views to implement permissions in SQL Server. The underlying table will be...

I tried changing the compatibility to SQL Server 2008 (100) as this was the highest I could go (I'm running SQL Server 2008). It did not seem to make a difference unfortunately. I was able to finally have some success by changing some of the client side stuff, but I don't really understand why...

Hey arnelgp, thanks for sharing. I already have code that works great for files under 150MB. One of my test functions looks pretty much exactly like yours, the only notable difference is that in my connection string I have: Driver=SQL Server and you have: PROVIDER=SQLOLEDB.1 Could you tell...

Hi Minty, it is currently set to "SQL Server 2000 (80)"

Hi all, I am trying to insert a blob into a SQL Server linked table field and with files over roughly 150MB I get the following error: "not enough storage is available to complete this operation." The SQL Server field is varbinary(max) datatype so it should be able to handle up to 2GB. So...

Hi SonicClang, I have since transitioned to a different position within the company and am no longer actively working on any of the Access stuff I did last year. I never did get the chance to implement a check-in/check-out system, and we still have people trying to edit records at the same...

Well, here I am over a year later and I am starting to run into this problem more often. User A and User B start editing a record around the same time from a bound form. User A hits save and when User B hits save, they get an error saying the record has been changed and basically all they can do...

This looks like a great ribbon resource, thanks!

Hello all, I've created a custom ribbon for my end users (Access 2010) and everything looks and works great except for one issue that is becoming a deal breaker for me and my end users: I've got a number of tabs on my custom ribbon and on each tab there are a number of buttons that open...

Yes this is what I meant, my apologies for the confusion. I'll let you know how my testing goes and we can take it from there.

Hmm, interesting, I'm definitely going to have a look at this to see if it solves my problem. Do you appropriate GetChunk code that would go with this code?

I simply have a button on my file attachments form that says "Add Attachment" which when clicked runs a VBA module that pops-up a Select File dialog window and then pushes the selected file as a BLOB into a field in my SQL Server linked table. (Access sees the data type of field as "OLE...

Just thought I'd bump this in-case someone else has seen this problem since I originally posted.

Hello all, I am using the following code to store BLOBs in a linked table (SQL Server 2000): http://support.microsoft.com/kb/210486 This code works great for files up to 40MB or so (haven't been able to determine the exact limit). When I try to use it for files around 60-70MB I get the...