Connecting Access from MS SQL 7.0

Hi,

I have been trying to connect to access database from SQL Server 7.0.
This machine is having 7.0 as a default instance and 2000 as a named instance.
Also the machine doesn't have access installed and Microsoft.Jet.4.0 is of version SP8 for Windows 2000
The access database is password protected.
I have tried all, OPENROWSET, OPENDATASOURCE, linked server, and ODBC.

These are some of the commands which I have tried but gives following error.
*******************************************
SELECT a.*
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'F:\Geerimain\billing.mdb';'bhagath';'bhagath', Employee)
AS a

Server: Msg 7303, Level 16, State 2, Line 1
Could not initialize data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'.
[OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]
**********************************************

SELECT * FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'DataSource="F:\Geerimain\billing.mdb";
User ID=bhagath;Password=bhagath;Jet OLEDB:SystemDatabase="c:\WINNT\system32\System.mdw"')...Employee

Server: Msg 7303, Level 16, State 2, Line 1
Could not initialize data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'.
[OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]

**********************************************
SELECT *
FROM OPENROWSET('MSDASQL',
'Driver={Microsoft Access Driver
(*.mdb)};Dbq=F:\Geerimain\billing.mdb;Uid=bhagath; pwd=bhagath','SELECT *
FROM Employee')

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]

**********************************************

I have tried all possible combinations but most of the time I come up with Error 7399 or 7303
In case if anyone has some other syntax and successful with that, please let me know

Regards
JayDaft answer but... do you have any other way of confirming that you can open an Access database on that machine? Could be that SQL is just showing a general problem. Is MDAC installed?|||I have copied the mdb file on my machine and have Access installed.
I can open the access application using the username and password specified here.
Yes MDAC is installed, but which version can't say.
Can you tell me how to find that ..