Recent content by Hollar

The DB is on a network, I do not have Access security enabled. Each user has the network location setup in Access as a trusted location. This is Access 2010 and I thought there was some setting that I must have missed. In 2003 Access there was a setting for to share a DB if I remember correctly...

We have a small Access DB with just a few tables that comes up with this error message quite often. "The database has been placed in a state by 'Admin' on Machine 'LTUSKRALRSTACKS' that prevents it from being opened or locked." I thought I had the tables set with the correct permissions, but...

I am using a data macro from a table to send an email to alert a user of a new item has been added to the DB. How can I pull some of the new data and place it into the email? Thank you, Hollar

My first concern with this little DB is that it is changing its permissions to this read-only state all by itself. Changing the DB into a FE/BE is a good suggestion, but I have to let it be used for a while before I lock it down. Everett

I have a small Access DB (multi-user) on a network that keeps turning into a read-only DB, with a message bar saying please save as . . . and it will not let you complete that. It seems to lock the application, and when I can get everyone out and copy the file out I can finally get it back to...

Thank you, I guess I'll have to find another path.

I have an ACCESS DB that uses the attachment field type. I did a test migration to SQL 2003 and the attachment fields turned into memo fields. And naturally all the attachments disappeared. Does anyone know if SQL 2008 R2 supports this field type? Thank you, Hollar

Here is the short overview of my dilemma. I have a query against two tables based on the [Due Date]. When the query is called it presents two dialogue boxes with the “Start Date” and the “End Date”. What I would like to include in the results is any part number in [Status] that was “completed”...

All, I am new to the forum, I am about a half a programmer (meaning I don't write much code, but I make full use of the visual interface), have a number of years experience. I work for a large corporation in California. I will thank you all in advance for any help I receive. Hollar