Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Jet database engine cannot open the file <filename>...

Status
Not open for further replies.

aker

Programmer
Mar 27, 2002
52
US
Hi.
{
SQL 2000 running on Windows 2000 Server SP2 Jet 4.0;
Windows NT 4.0 Domain/File Server located the Clipper 5.01a dBases and program;
Clients running Windows 98 with mapped drive to NT4.
}
I have encountered a small problem. I created a DTS to transfer Clipper database files to SQL. Normally this would work when the dbase files were in use but not today. Nobody has exclusive rights to the files - opened in shared mode.

To check, I created a new DTS with the characteristics:
Source: Dbase III;
Destination: Microsoft OLE DB Provider for SQL Server.
In 'Select Source Tables...' I select a file, then Transform. Immediately appears the message:
Code:
Error source: Microsoft JET Database Engine
Error Description: The Microsoft Jet database engine cannot open the file <my file>. It is already opened exclusively by another user, or you need permission to view its data.
Context: Error calling OpenRowset on the provider

Things I have tried:

Security and Sharing permissions of databases - Full;
Permissions of SQL database - Full;
TEMP to %SYSTEMROOT%\TEMP
TMP to %SYSTEMROOT%\TMP

Any other suggestions much appreciated. Temporarily I create a copy of files and import them from there no problem.

Regards.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top