VB 5 app can't open local database
- From: "Steve Bowyer" <stephen.bowyer@xxxxxxxxxxxxxxxxxxx>
- Date: Tue, 12 Dec 2006 11:12:14 -0000
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.
.
- Follow-Ups:
- Re: VB 5 app can't open local database
- From: BogusID
- Re: VB 5 app can't open local database
- From: Paul Clement
- Re: VB 5 app can't open local database
- Prev by Date: Re: SQL UNION Question (or not UNION?)
- Next by Date: Re: VB 5 app can't open local database
- Previous by thread: Seek Method on Access97 Dbf - with ODBC Connection
- Next by thread: Re: VB 5 app can't open local database
- Index(es):
Relevant Pages
|
