Big Problem.. :(

I have finished working on my database, and everything is great when i am running it on my computer.....when i put it on the server to be used by the users....it is only opening as READ ONLY...and they are not able to enter or update any data into the tables..............pls help,,,,i feel like my whole project has just failed...!!! how can allow the diff users to access it from the shared folder and be able to update and add to the tables..

re: Big Problem.. :(

Hi totomalas,

Can you describe the problem in greater detail?
1. Which database are you using?
2. The username and password you're using to connect with database, does it have sufficient privileges?
3. If you're using SQLite, you'll have to provide read-write access to the folder on server in which your database file lies.

re: Big Problem.. :(

yes i can provide more details

The database is located by the LAN Admin in a shared folder on the LAN. but the users dont have access to that folder,,as if they go through my computer and try to open the file, it says Access denied...however, I have created a small C# software with a link, to the Database in the shared folder...the user presses on the link, the database opens....but read only..!!


1).I am using MS Access 2003/2007....
2). the database is not locked.
3). I m just using Ms Access....

i hope you can help

re: Big Problem.. :(

Okay, thanks for the details. Looks like a folder permissions issue than a database privileges.
Well, Have you tried the following:
your_folder_containing_MS_Access_db -> (right click)->Sharing & security->Permissions->And make sure that "Everyone" is selected under group or usernames and in the permissions section,"Full control" has been checked under allowed operations.
This should grant access to all users within your network to read-write contents of your folder i.e. the MS Access database file.

Hope this is of some help!

re: Big Problem.. :(

There could be a number of reasons for this. First check out the rights that the users have to files in the folder where your database resides. Your LAN Admin may be able to help you with that.

Let us know what you find.