Distributing my database?

[mrgreen]

I'm pretty much a nooby when it comes to this subject. Basically, I've created a db placed it on the public network (split the db and the back end is on the network also. Gave each user a shortcut to the db. I'm assuming this is bad practice? I'm running into some issues like not being able to access certain forms even though the option for multi-user is selected, not being able to edit certain records so on and so on. I would like to put the back end on our Server and give each computer being used their own copy. I'm just not sure what that means. I've read it but what do I need to do? Is there a guide? Anyway if someone has some time I'd appreciate it.

 

[pbaldy]

This should get you started:

http://www.accessmvp.com/JConrad/accessjunkie/splitting.html

 

[mrgreen]

pbaldy, Thanks for the reply!! I finally got a chance to look at this and the only thing I'm struggling with is the trigger to say, "Hey we don't match!" I've written my batch file and that part works great. Do I just have a linked table on the backend containing the latest version and an unlinked table containing the local copies version then just compare the two? One article said something about comparing tables???? Again I'm a super nub so not sure what exactly that means. While I do care if the tables are correct I'm more worried the user won't have the correct forms.

I'm probably rambling any thoughts?

 

[pbaldy]

There are any number of ways to trigger it. Personally, I have a local table (unlinked as you called it) in the front end. When I make changes to the front end I add a record to this table, incrementing a version field (I also have fields for the date and a description of the changes made in that version). When I'm done I replace the master MDE on the server. In my version control utility, I simply compare the max version number of the master MDE on the server with the version on the PC. If they're different, I copy down the new version.

A mentor of mine uses a batch file. Two samples here (not sure if you have to join to download):

http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/

 

[mrgreen]

pbaldy,

Thanks for the post. I also will be using a batch file. I think I will also create the fields you described (date, What's different?, etc...).

Thanks for the info.