[Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the object 'Users.dbf'. when starting GoldMine

Version 1

    Details

    - [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the object 'Users.dbf'.  Make sure the object exists and that you spell its name and the path name correctly.

    - This happens after modifying the database via the back end, for example when copying data from one table to a different. GoldMine Technical Support does not support any such actions but a DBA may consider such actions under certain circumstances.





    Resolution

    [INFORMATION/VERIFICATION]
    - Please refer to the related Knowledge Article # 20117 first, especially when no back end modification was performed.
    - If the database was modified from the back end then the most likely reason for this error is that the indexes are missing from the GoldMine Database Table (either only USERS or even more or all tables).
    - In order to verify this,
    1. In the SQL Server Management Studio browse to and expand the GoldMine database
    2. Browse to and expand the USERS table
    3. Browse to and expand the Indexes for the USERS table
    >> RESULT:
    There are no indexes at all for the USERS table


    - Usually for the USERS table there should be 3 indexes


    [RESOLUTION]
    1. Run the following Script against the GoldMine database from the SQL Service Management Studio
     (this is intended to create the USERS table indexes)


    /****** Object:  Index [USERGRUP]    Script Date: 11/14/2016 2:20:49 PM ******/
    CREATE NONCLUSTERED INDEX [USERGRUP] ON [dbo].[USERS]
    (
        [U_USERGROUP] ASC
    )WITH  (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF,  DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON,  ALLOW_PAGE_LOCKS = ON)
    GO


    CREATE NONCLUSTERED INDEX [USERS] ON [dbo].[USERS]
    (
        [USERNAME] ASC
    )WITH  (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF,  DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON,  ALLOW_PAGE_LOCKS = ON)
    GO



    CREATE UNIQUE NONCLUSTERED INDEX [USRRECID] ON [dbo].[USERS]
    (
        [recid] ASC
    )WITH  (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF,  IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS = ON)
    GO



    2. Start GoldMine BUT make sure on the Login window 
    a. To use a user with master rights
    b. Press the CTRL key when clicking OK (because only with this you get into the maintenance window)



    3. Button Maintain
    a. All Database files + Files in GoldMine Directory + Current Contact Set


    b. Next
    (there is NO Need at this point to run a full rebuild but only a re-index)

    c.  Next >> Finish

    4. Please verify afterwards if you can log into GoldMine again as usual