Recent content by TJBernard

I have an MS Access database with an OLE Object Field storing .PDF files. Some of the links have been broken/the OLE Object will not open up the .PDF file that was originally stored there. Is there anyway to query the OLE Object Field to pull back the records with broken links? I could not...

Hello, I have a database in which I am trying to update the MS Access table with data from MS Outlook. There is a new feature in MS Access 2007 that allows this by right clicking on the table and selecting "Collect and Update Data via E-mail". I am just wondering if anyone has had success with...

Huh, I figured out the code playing with something else. This worked for a work around... Dim FilterValue As String FilterValue = InputBox("Please enter the Case Name (Blank for all)", "Case Name") Me.Filter = "" Me.Filter = "(((TblBilling.CASE_NAME) Like '*" &...

I have a database that allows the users to filter the records based on criteria entered into an input box. The code applies filters, stored in queries, that allow for the users to enter text into an Input Box and the filter applies to the form. This has worked great in MS Access 1997, 2000...

These are some GREAT ideas, and I do believe this would work for me. On the database open, check to see if there is the computer name in a table list. If there is not, add the computer name to the table, and set a boolean field to true. If the computer name is in the table and the boolean...

I found this nice code that prevents a user from opening a .mde file on a computer more than one time. I was shocked to find out that a .mde file can be opened more than one time on a single machine. Unfortunately if the file is opened using MS Access 2007, it can be opened more than one time...

I got some more time to play with this. I was able to recreate the error in MS Access 2007, with a list box containing only 20 rows, rather than 2,000+. So the size of the row source for the list box is not the concern. 20 is rather normal, I would think. With the 20 values, I could see...

Thank you for your help. We have just started moving towards MS Access 2007 here at work, so I have 2003 on my desktop and 2007 on my lap top. I had a user complain about it, and I thought "hmmm, never heard of that before" and sure as can be, I tested it out and had the same problems. I...

Ah ha, I found out more information. Yes, the List Box property does have the Multi Select set to "Extended". But this is interesting. It is an MS Access 2003 database. When I open it in MS Access 2003, the list box works as I expect, I can deselect the one value in the middle I want to...

I have just come across what appears to be a glitch in MS Access, and I am not sure if there is a fix or not. Maybe someone here has run into it. I have a list box on a form with a large row set (over 2,187 rows). I have set the list box up with the "Multi Select" property of "Extended" which...

Here are work we use DSN Files to connect to SQL back-ends. We have just moved up to SQL 2008, and I am having problems using the File DSN type "SQL Server Native Client 10.0". I can connect to the database, with god rights, but if I log on as a regular user and use Edit rights, I am not able...

I never did find a solution. But that evening, when the servers performed their nightly processes, the file unlocked itself (not sure how). I then was able to delete the file the next day. Some process on the server must have been hung up, and caused the file to be locked.

Thank you The_Doc_Man. The IT team is looking into any server issues, or any processes running against this file. Sounds like it might be beyond the powers I am given. I will let you know what the final solution is. I, at first, thought it was something I could get to.

This would probably work to create a new .mde file, but my problem is not so much that I cannot use the .mde file, I have created a new .mde file that works just fine with a slightly different name. My problem is that I cannot delete the old .mde file off my network server. It says the file is...

Thank you for your time. I forgot to include that I had check this as well. The file is not read only. It is like a user was in the database, and some how did not close it correctly (maybe a Ctrl - Alt - Del) and it corrupted the file. I am not sure, this DB has been around for almost 3...