"Darrick" <anonymous@discussions.microsoft.com> wrote in message
news:004b01c3aeba$11a12770$a301280a@phx.gbl...
> Hi,
>
> I keep getting a "Must use dbSeeChanges option with Open
> Connection Error", while connecting to a table that has an
> Identity field.
>
> I have also trying this line of code instead of the
> origionl (Listed below), but get the same error.
>
> Set TotalViewMURST = TotalViewMUDB.OpenRecordset
> ("TotalViewFileMUFiles_WIP", , dbSeeChanges) '
>
> I've never seen this error before, nor can I find the
> solution. I can't even find anything about it on Books
> Online.
>
> I would appericate any help you can offer.
>
> Thanks in advance.
> Darrick
> darrick AT pscufs DOT COM
>
>
> Here is my code:
> ********************************************************
> Public Function ConnectToTotalViewMU()
>
> On Error GoTo ErrorHandler
>
> Set TotalViewMUWS = DBEngine.Workspaces(0)
> Set TotalViewMUDB = TotalViewMUWS.OpenDatabase("",
> False, False, ConnectString)
> Set TotalViewMURST = TotalViewMUDB.OpenRecordset
> ("TotalViewFileMUFiles_WIP") 'Opens the recordset.
>
> TotalViewMUWS.BeginTrans
>
> End Function
> ********************************************************
>
>