Run-time error '3078' - in multiuser environment

Hallo Hi...
I'm having problem when I try to run my application in the local area network. The error message as below:-

Run-time error '3078'
The microsoft Jet database engine cannot find in input table or query "biblio". Make sure it exists and that its name is spelled correctly.

This application works fine if I run in the local machine.

I'm using acess database as below (DAO):

dim db as database
dim rs1 as recordset

set db = workspaces(0).opendatabase("C:iblio.mdb")
set rs1 = db.openrecordset("Titles", dbOpenDynaset)

Please if any body can help me....

Hi,

I think you need to place the mdb file on a shared folder on the network server and change the code to point to the network file. Or else what your program will be doing is trying to open the file locally at your user's terminal.

Eg:
dim db as database
dim rs1 as recordset

set db = workspaces(0).opendatabase("\SERVERNAMEDIRECTORYNAMEiblio.mdb")
set rs1 = db.openrecordset("Titles", dbOpenDynaset)

Hi Braindead,
Now I've got the idea. Anyway thank you very much.