Search results

I am having a recurring issue with an Access Lock file that does not get deleted when all users exit the application. It does not look like users are prevented from opening the db, but I want to repair the db and am not sure if this is OK to do with the lock file hanging around. I was...

I am running Access 2000. I was wondering if anyone knows if there is a way to open querys in SQL View when the Design button is clicked. I edit my querys in SQL View 90% of the time and find it cumbersome to have to change views from the UI designer to SQL every time. Thanks

In Access 2000, I have created a report that uses a Query as the RecordSource. rptMyReport RecordSource: qryInventoryDetailsDivisionParam The Query requires one parameter which it gets from a form. SELECT [InventoryItems].[InvCtrlNum], [InventoryItems].[ItemDesc]...

I am running Access 2000 and included the Microsoft Office 10.0 Object Library in my VBA references. I am now sharing the DB on the LAN and one of my users does NOT have the Office 10.0 Object Library. We both have the same version of Access and VBA and the same OS - XP Pro SP 2. Microsoft...

I have configured my Access db Security so that users in my Clerks group can do pretty much anything except Delete records. The db now resides in a shared folder on our LAN. When I launch my DB from my PC as user CLERK1 (with the /workgrp option and the appropriate MDW file), I have no problems...

I am getting a "Recordset is not updateable" runtime error when the following line of code tries to execute. ' Set the combo to the 1st record Me.ComboSubtypes = Me.ComboSubtypes.Column(0) This ONLY occurs with users in my new Inquiry group (defined in the Security/Permissions). The...

I am receiving an unexpected message when a user tries to launch a form that the user does not have permission for via the Access Security-Permissions setting that I have configured. I am trying to set my Access db up so that Guest users can only access 2 Forms - the Switchboard and the Main...