Search results

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...

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...

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 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 have a strange issue. I have an MS Access .mde file that seems to have corrupted on me. The .mde file sits on a network server, and when I try to open the database I get the message... "The database Cars.mde is read only. You won't be able to save changes made to data or object definitions...

This is a new one, I have not experienced this problem before. I have an MS Access 2003 DB that is linked to a SQL 2000 back-end (to store the tables). On my form I have a "Delete" button to delete records. The code is simple and has worked in the past for me... Dim I As Integer...

Hello everyone and thank you for your help. I know the OLE Object Viewer draws a lot of questions here, I have myself asked about it in the past. It is such a buggy little tool, yet it is so useful. I have a strange issue. I have two MS Access DB's that both have the OLE Object Viewer placed...

I have a simple ADP project that has a large grid view form, which once the ID field on the grid view form is double clicked, the information for that specific record opens up in a regular form (for record changes). Everythng works great. On the double click of the ID field, I just open up the...

I searched Google and this forum, and maybe I did not know the correct phrase to search against, but I did not find anything on this issue. I have an MS Access 2003 database with a SQL back-end. It works great, quick, multiple users in at the same time with no issues, etc. But a user has...

I have an MS Access 2003 front-end (queries, forms, reports) connected to a SQL server back-end database (SQL Server 2000). When I try to run an append query against any of my SQL tables with a unique identifier, I get the error... "Explicit value must be specified for Identity Column it table...

I have a database in which the tables are located in one MS Access file, and the queries, forms, reports, etc. are all located in a seperate MS Access file (MS Access 2003). The MS Access file that stores the tables, I call the "back end file". I got a call regarding the database, and found...

I need to disable the [Shift] key so that when the users open my MS Access database, they cannot by pass the open form and display the database window. We had code that worked correctly with an MS Access 2000 MDB, and even works with an MS Access 2003 ADP, but the same code is ignored by MS...

I am trying to brainstorm this idea, and I just cannot come up with anything. I have an MS Access database that will now be tracking invoice information. The users were wondering if on the form that displays the invoice information, if they can have quarterly and yearly totals for the invoice...

It has been requested that one of the columns in a Datasheet form be of a different font color. The reason is, if the users double click on this column, it opens an expanded pop-up form with data relating to the data in that specific cell. So the users thought it might be helpful if this one...

This should not be that difficult, but I am not able to get the code to work. I have a continuous form, that is populated by a selection data string (plugs the string into the record source property for the form) once the form opens (depending on the criteria the users choose). Now that the...

I have a SQL Report published to the report server, and set-up to e-mail to select users. The users have requested this report appear in an MS Word format (.doc or .rtf). According to a book I have, this is possible, but on our report server we do not have this option. The options we have...

When you want to delete a record out of MS Access, you get the default pop-up message confirming you want to delete the record [YES] [NO]. I have a few users who are not paying attention and hitting a combination of keys (I am guessing Alt + D) and getting this message. They then do not look...

I have an MS Access front-end with a SQL back-end database. It works great, I connect the MS Access front-end to the SQL back-end using a File DSN. I have a few users (who are in the database the most) who get ODBC disconnection errors time to time. The cause of the error is not consistent...