R
RW
The database in on a network server. Users access the database through Citrix.
The network server has been bounced.
The citrix servers are bounced nightly.
The network admin can not see the .mdb or .ldb files from the network
management software indicating no one is logged into the database. However,
the .ldb files are on the network server. The network admin can not manually
delete the .ldb files either (when using explore to view the files). It gives
a message that the database is locked.
If you open the .ldb file in notepad, it displays the Citrix server name as
the user.
I've downloaded LDBviewer and it shows Logged On "No" and Suspect "Yes".
How do I delete the .ldb files or change the database so it isn't "Suspect"?
This is preventing me from performing maintenance on the database. It should
be noted that I can go in and change forms, queries, Table design etc. - I
just can't Compact and Repair.
Thanks
The network server has been bounced.
The citrix servers are bounced nightly.
The network admin can not see the .mdb or .ldb files from the network
management software indicating no one is logged into the database. However,
the .ldb files are on the network server. The network admin can not manually
delete the .ldb files either (when using explore to view the files). It gives
a message that the database is locked.
If you open the .ldb file in notepad, it displays the Citrix server name as
the user.
I've downloaded LDBviewer and it shows Logged On "No" and Suspect "Yes".
How do I delete the .ldb files or change the database so it isn't "Suspect"?
This is preventing me from performing maintenance on the database. It should
be noted that I can go in and change forms, queries, Table design etc. - I
just can't Compact and Repair.
Thanks