Question help with split database

[Jason1]

Hello,

I am running access 2007. I have created a database. The database has been split, and is mapped to a network drive on our company server. I then copied and pasted my front end files to anther computer on the company floor. I also mapped that computer to the network drive. Using the second computer, I cannot add any new records to the database. I have no trouble viewing past files, but cannot enter any new ones. Can someone tell me why this is happening, and how to fix it.

Thanks

 

[Galaxiom]

Sounds like the user doesn't have write permissions on the Back End.

 

[Jason1]

That could be the case. How would I go about setting those permissions?

 

[MSAccessRookie]

In every organization there is at least one person or group that controls access rights. Often that person is called something like the System Administrator (SA). Contact your SA, explain your need, and the SA might be able to assist you.

 

[Jason1]

well sadly enough, at this point that is me. Building this thing from scratch.

 

[MSAccessRookie]

Ask yourself a question. If you needed to use another Network drive, or add a new one for your own use, or if your computer needs upgrades or repairs, who would you turn to for assistance? If you would be expected to do these things on your own, then you might be correct. If there is someone or group to help you with these things, then the SA is probably that person, (or at least in that group).

 

[Jason1]

MSRookie,

The way I look at this forum is as follows, there are there are two types of people on this forum. Their are the people who know the answers to the questions and the people who are trying to complete a project and learn along the way (question askers). I am a member of the latter group although I would be asked to do the work you have stated in your previous post. If I had trouble performing any of those tasks, I would probably find a forum and ask how to complete them. I have stated many times on this forum that I am totally new at this, and am slowly working my way though this project. I have learned a lot along the way, but have found that by swallowing my ego and asking questions on this forum, I can move along much quicker than if I were to research every little detail on my own.

I prefer to tap into the pool of knowledge that you already possess. Any help would be appreciated.

Thanks

 

[gemma-the-husky]

I think what you are being asked is this:

Who set up your network for you? Who sets up new users, and their login profile? Who allocates passwords? How do you decide how to set up your network folders? How do you prevent some people in your company seeing stuff they shouldn't? Who manages your data backup strategy? Who manages your cabling? Is it all the same people?

Now maybe you do have a third party to help you (either inside the company, or outside), or maybe you do all this yourself. If you do it all, then maybe you accept some system settings without realising the full import of what they all mean.

The underlying issue is that access is just another programme that runs in one folder, and tries to manipulate data in another folder. Now maybe there is an error in the database, which is causing this. Maybe the database is opening in exclusive mode by one user so that subsequent users are readonly (rather like an excel file). Probably a number of other reasons I can't think of. But one possible reason for you not being able to enter data, which is easy to check, is that the particular user doesn't have the correct level of windows permissions for the data folder.

I think you should also realise that everyone here is providing solutions and advice, often very valuable solutions and advice, for nothing. I often think, especially in corporate environments that it is not reasonable to expect all this stuff for nothing, and at times companies should be prepared to pay for support and advice.

Hence the observation about the systems administrator is completely valid, and might help you resolve your problem.

 

[MSAccessRookie]

Well said Dave. Thanks for clearing up my point about the SA.

 

[Jason1]

I understand where you two are coming from, and please understand that I find that these forums are a huge help. I could not complete many of the tasks I undertake without the help of the forum. The point I was trying to make in my previous statement was that basically, I don't have a choice, the buck stops here. I am not educated in networking or database design and management. I have taken on the project, and to this point have done fairly well. This forum and the people in it are a large part of the reason I have done as well as I have.

I appreciate everything that everyone one here has done to help me out.

It just seemed as though I was being told this was over my head, and I should go find someone who can help me out. In all reality that is what I was doing. I was going to the place where there were people who could help me out. Anyway, that being said, I apologize if I sounded ungreatful.


I also think I may have misunderstood the question. MSrookie was asking about the user passwords and permissions in window as a whole. I was under the impression there was a permission setting in Access itself.

Thank you all for your help and please don't think badly of me. I'm just a guy trying to do the best he can with what he's got.

 

[Jason1]

I have checked the permissions related to the server drive. All of them are set to full access. I am currently trying to get this to work with only two computers. For a while the computer where the database was originally created and then split worked just fine, but the computer I copied the front end to will only show previous records. When I open a form and try to enter a new record it will not let me make a new record. I can look at all the past records though. This is the first database I have split. Is just copying and pasting the front end from computer to computer enough, or do I need to reconnect the tables to the server through the network drive somehow?

I'm trying to be a clear as possible. On the second computer I pasted a copy of the original front end, and mapped the network drive to the server as I had done when I split the database originally. Is there anything else I need to do on the second computer housing the copied version of the front end?

 

[gemma-the-husky]

it sounds like your two databases are not looking at the same back end

in code you can get the backend by

msgbox(currentdb.tabledefs("somelinkedtable").connect)

this will give you a string that looks like this

;database="path to back end"

I suspect that these will not actually be the same in your databases, and therefore you need to look at how you connect to the back end.

 

[Jason1]

Thanks Gemma I will give that a shot. In the mean time I have come up with another possible culprit. I have it running flawlessly on 3 computers now, but there is one computer there is a fourth computer that is a problem. It is the same computer I have been dealing with from the beginning. The only differences I can see at the moment are that the three working computers are running windows xp pro, and the one that doesn't work is running windows 7 pro. Could this have something to do with it??

 

[NigelShaw]

Hi

Windows 7 has a permissions problem with c:\program files\ as it is now somehow protected. I found this out with Sage. I had to install it outside of program files for it to work. I couldnt write data to sage at all. There is a registry hack for it but it was easier to have the install location in c:\my file rather than c:\ program files\ my file

Is this where you are installed?


Hope that helps


Nidge

 

[Jason1]

Thanks Nigel. I managed to get it to work. I ended up putting the split files in a shared folder on the server as apposed to mapping its own network drive.