Runtime Error 3045

[lovell811]

When I run through this code:

DbN = "\\Green4\MSSQL\DATA\MSSQL\Data\SalesInvent_Data.MDF"

Set PTDB = Workspaces(0).OpenDatabase(DbN)

it gives me "Runtime Error '3045' could not use: "\\Green4\blablabla, file already in us.

But it isn't, what's going on. Is it a problem in the code or with SQL??

----------------
Joe

 

[lovell811]

any suggestions? ----------------
Joe

 

[BlackKnight]

Hi,

Could it be that you have a pending transaction meaning a transaction without a commit in that workspace on the SQL table?

Have a good one!
BK