MS access permissions

[DigitalGeek]

I am trying to read and write to a access database.

It works fine on my logon at home, at work I get an exclusively or no permission error, I have tried to change the permissions but now no user can access the tables?

what can you suggest?

 

[phantomCO]

dig,

I think we need more info to answer this one like what OS's, how are you reaching it locally and remotely (name, dsn, etc.)
It is doable, I've done it in the past but there are some quirks depending on the OS.

phan

 

[DigitalGeek]

I am using win xp/office xp, deployement is W2K/OXP(I know I need .NET for 2K)...

I create the tables in access to make life easier, I am using OLEDB for the connection. My local sign on is Admin, when I login as a user on my machine I get the same message.

I have tried create another user in Access(there was no difference).

If I open the database in access at work, it's read only???

 

[kcj402003]

Try using the MS Access Workgroup Administrator to join the system.mdw

 

[phantomCO]

dig,

To be honest, we set permissions on the system level, not in access. I'd hope OfficeXP is better, but 97 & 2K just seemed to never be predictable when accessing remotely from a front end.
I'd like to see what everyone else's experience has been lately since I have a project coming up with remote access.

phan