Re: VB 5 app can't open local database

"Steve Bowyer" <stephen.bowyer@xxxxxxxxxxxxxxxxxxx> wrote in message
news:eaqdnSbtsfoSE-PYRVnyrQA@xxxxxxxxxxxx
My VB5 app uses an Access 97 database located on a shared drive. At
certain times, the app also uses a small 97 .mdb in a folder on the user's
local c drive. When properly installed on some new Fujitsu workstations,
the app fails when trying to open this local .mdb with the message:

Error 3051. The Microsoft Jet database engine cannot open the file
'c:\rcanet\tempdb\temp.mdb'. It is already opened by another user, or you
need permission to view its data.'

The code at this point is as follows:

On Error GoTo errorhandler
Dim tdb As Database: Set tdb =
ws.OpenDatabase("c:\rcanet\tempdb\temp.mdb")
Dim invtab As Recordset: Set invtab = tdb.OpenRecordset("tempint")
Dim sqla As String
Dim myrset As Recordset
'Clear any records from the tempint table
tdb.Execute "DELETE tempint.* FROM tempint;"
Screen.MousePointer = 11

The same executable file for the app has been working fine on other older
workstations, and the app continues to be able to open the main, remotely
located .mdb on the new workstations. The new workstations are XP, the
older ones are a mix of 2000 and XP.

Would be grateful for any tips as to what might be going on here.

Steve.





Hello Steve,

Does the local folder have an LDB file left behind?

Perhaps there is a user level rights issue on the newer machines?

It's possible IT changed policies and users have local admin rights on the
older computers but not on the new one's?
Try creating a system level ODBC definition for the file, testing at the end
of creation should reveal if that's an issue.

Regards,
David


.

Relevant Pages

  • RE: Possible to make files in application dir in Vista?
    ... want all the files to be created in the application folder, ... that app "portable". ... I've created an application which creates an .mdb database in the ... setup files can be written in that ...
    (microsoft.public.dotnet.languages.csharp)
  • VB 5 app cant open local database
    ... My VB5 app uses an Access 97 database located on a shared drive. ... the app also uses a small 97 .mdb in a folder on the user's local c ... When properly installed on some new Fujitsu workstations, ... Dim myrset As Recordset ...
    (microsoft.public.vb.database)
  • Re: Open MDB file on another computer?
    ... You can share the folder where the MDB is located, then when you open the db ... You have to share the folder. ... the admin went to the extreme of installing the app and MDB ... Is there a downside to this that I need to consider? ...
    (microsoft.public.vb.general.discussion)
  • DAO missing file errors
    ... I've decide to try change some apps from text file to mdb and I'm ... machines.I'm displaying data on a flexgrid,loaded from a text file into ... As this app needed to go on different machines I deleted the ... another folder on the development machine,(mdb is in same folder as ...
    (microsoft.public.vb.general.discussion)
  • Re: VB 5 app cant open local database
    ... ¤ drive. ... When properly installed on some new Fujitsu workstations, the app ... located .mdb on the new workstations. ...
    (microsoft.public.vb.database)
Loading