Single Database Multi Users

[Seahawk0966]

I have gone thru all the Threads and cannot find the answer to my question...

I have one application on 3 different workstations and one database.. Now I want all workstations to be able to read the database but only 2 will write to it..

HOW!!!?? I have fought this for 1 week and am pulling the little hair I have left out thinking this thru... ;>

 

[rob444]

Have a look at:
set exclusive off
set multilocks on

in the helpfile.

Rob.

 

[JRB-Bldr]

"Now I want all workstations to be able to read the database but only 2 will write to it.."

It sounds as though you are not looking for a enabling "single user at a time" to write, but instead you are looking to set user-specific privilages to allow 2 specific users Write access and the others Read-Only.

If that is correct, then you might want to consider adding a User Login utility to your application. That will "tell" the application who is using it and thereby allow it to programatically support user-specific data table access privilages.

There are other previous postings on creating User Login utilities. Use the Keyword Search (if it is working) and see if you can find your answer. If not, come back and we'll continue the discussion.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[Seahawk0966]

jrbbldr,

That is pretty much what I want to be able to do.. I will go do the search and see what I can find and get back to ya here when I get back whatever I do get..

Thanks

 

[susansuzl]

If one of the computers an XP?

Our program runs multiple platforms (Mac & Win, including XP). We have had a number of support calls recently (last 2 weeks) of users experiencing "File Access Denied", "File is use by another", and even "File Does not exist" (though it does). Miscrosoft's Knowledge Base Article 812937 says they have found an issue with XP locking files. I'm wondering if this is the cause.

Have any others experienced something this?

XP SP 2 says it will resolve this issue. Our IT tech says SP 2 has other stuff that will be potential problems so he doesn't want us to install that. Support offers a hotfix - if you call them. (Of course they'll take your money if your issue isn't the same).

Support is pulling their hair out! Ideas?

 

[JRB-Bldr]

susansuzl - it sounds as though you are introducing a new question onto an non-associated existing thread about supporting user-specific Data Access rights to an application's data table(s).

I'd suggest that you begin a new posting.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com