Compiling front end of a split database

[jeo]

Hello. I'm very new in SQL server, but worked quite a bit with databases in Access. I know how to split a database. I also know that it creates a back end that is supposed to be stored on the server and a front end that is supposed to be distributed to all users. I have no idea what to do with my split database. How do I compile and install front end on users PCs and how do I put the back end on to the server itself?
Any help would be greatly appreciated.
Thank you.

 

[jfgambit]

Jeo:

Split the database on the back-end server:
Tools>DatabaseUtilities>Split Database

The wizard will guide you through the process. Once complete copy the Front End (Nameofdb_fe.mdb) to each persons computer, either have them grab it off the server or zip it and send it to them. They can park it anywhere on their system. As long as they have access to the server they will be connected to the db information.

 

[jeo]

what to do with back end?

Thanks for replying. So what do I do with the back end? What does it mean to put the back end on the server? How do I do that? Or may be I just need to leave it on the network and set up security for it?
Thanks ahead.

 

[jfgambit]

Jeo:
The back-end stores your tables (data). You can set security to the front-end and users can access the data from the back-end once they are logged onto the front-end.

Here is some good reading regarding splitting a database and security from MS.

Split DB

Also attached is a FAQ about security

 

[chewy]

I think what you are asking is where to put the db correct? You can put it anywhere the users will be able to access it. Make sure they have permissions to the folder it is in also.

 

[jeo]

So I don't neccesserily need an actual SQL server to do this? I can just put the db (and I mean the back end) on the commond= drive and give users permissions? Or do I actually need to put the back end on to the server and if so how do I do that?
Sorry about all the stupid questions, just trying to learn.
I really appreciate everybody's help!!!!!
Thank you so very much.

 

[chewy]

You can put it on any network drive that the users can access. Just make sure the database isnt open in exclusive mode. To do this use the File > Open method and browse for the DB and when you find it before you open make sure the check box Exclusive is not checked

 

[jeo]

I appreciate all the help! Learnt a lot from all of you today.
Thank you!

 

[jeo]

One more question though, what is a batch file for? I found some sample batch file. I learnt it needs to be written in Notepad, but how do I use it and what it's purpose is?
Thanks.

 

[Autoeng]

Read this.
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36445