mdb database

[Asterix]

Hi all,


Is it posible to store data to a mdb file on a network drive
and get data from the same file with an other PC without getting an error?
Why i'm asking this is that i dont have a network to test this.

example:

*****PC 1*******

Set PerformSet = Db.OpenRecordset("Database", dbOpenTable)
PerformSet.LockEdits = False
'add a new record
PerformSet.AddNew

bla bla bla

*****PC 2*******

Data2.DatabaseName = Database
Data2.RecordSource = _
"SELECT bla bla bla
"From Data " & _
"WHERE bla bla
Data2.Refresh


*****PC 1*******


PerformSet.Update
Set PerformSet = Nothing



Thanx

[Wen Lie]

I guess it's okay to save on the 1st pc, and then retreive the saved data on another pc.

Coz, I'm doin' that way at my office.
All programs using Multi User on a Network Database.

It's okay so far...

Cheers,
Wen Lie

[Asterix]

Thanx Wen!!!!!!