Question Multiple users, one db

[theKruser]

I have a DB that 2 people currently use on a server. I am going to be adding several more users once the DB is done. I did this once before by splitting into FE/BE and it worked, but had issues. When I, as the adminitstrator/creator, accessed my link to the DB and made format/table/query/etc changes, the new items created were only visable by me. I need a solution that will allow multiple users simultaneously updating records while maintaining one user (me) with full global acceess and control. Any suggestions??

Another question would be assigning user names and passwords unique to users that will dictate their level of access (i.e. changes they are allowed to make, forms they can access, no access to queries, etc.).

Thank you for your help.

 

[georgedwilkinson]

I think I saw code here or somewhere that re-links tables when the FE is opened. That's what you're gonna have to do. Search relink or re-link on this forum.

Also, take a look at Bob's (free) FE distribution tool at: http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx

 

[theKruser]

Thank you for your help. I will give that a shot.

 

[Alansidman]

theKruser;
Here is a link to another forum that gives you a permissions set up that should allow you to do what you want. I have used this in the past and found it very effective in limiting who can do what.

http://www.mrexcel.com/forum/showthread.php?t=248191&highlight=Permissions

Alan

 

[theKruser]

I successfully split my database, but when I attempt to create an MDE, it tells me that Access cannot create an MDE database. I have compacted and repaired to no avail. Small database, less than 30 actual objects. Any ideas as to why this might be?

 

[The_Doc_Man]

Manually compile any VBA modules and see if anything barfs. If so, fix it.

Also, was the database created in the same version of Access that you are using to create the MDE?

Also, if the file is being created in a shared area, check permissions on the folder to see what you can or cannot create, update, delete, etc. Doing database changes often requires you to have everything except "Change Ownership" and "Change permissions" on the folder in question.

 

[theKruser]

Only had one module that i was not using anyway. I am not real big in VBA. I deleted it, compacted and repaired and still no good. Same version of access. I moved the FE off the server and onto my desktop.

 

[theKruser]

I am not sure what an .accde is. I read in one of the posts that for deployment, it is far better to use an .mde than .mdb. I am using Access 2003 file system with Access 2003 to try to create an .mde from an .mdb. I am not real well versed in Access, but I am trying to learn. Any info you can share will help immensly. Thank you.

 

[theKruser]

Unfortuately I cannot post it. There is info in it that I cannot release. I do thank you for your offer to help, though.