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

 

[Pat Hartman]

jeo,
When you split the db into be and fe, the be is just another Access database except that it only contains tables. It does not contain forms/reports, etc. They are all stored in the fe.

You need to put the be in a server directory where the users can link to it. If you need to move it after you "split" it, you'll need to relink the tables. Open the fe, go to database utilities, linked tables manager and relink the tables. To force the relink, you'll need to check the box at the lower left.

Once you have modified the links, you can put the fe in any server directory that the users have correct permissions to access or you can distribute the fe to the user's PC's.

 

[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