Seperation

[RyanB]

Hi,

Someone told me that it would be wise to seperate my front end of my database (forms, etc) from the backend. before i get too far and it becomes hard to split

just wondering how I can achieve this??

Thanks

Ryan

 

[rpadams]

Are you serious!!

You have posted on this forum before. I can't believe that you are asking about a FE-BE split without looking at the hundreds -- maybe thousands --of prior posts on this topic. One last comment -- spelling counts! SEPARATE. There are many, many very helpful people on this forum who give their time to others. Don't waste their time!

 

[RyanB]

No need to be rude mate,

I searched and didn't find anything...

Instead of being so rude why not post a link to one of the topics seeing as you know more than I do....

 

[maxmangion]

As rpadams suggested, if you search this forum, there are plenty of threads covering this topic. However, if you would like to automate the process rather than splitting your database manually, you can use the built-in tool in Ms Access - the Database Splitter. You will find this tool from Tools -> Database Utilities -> Database Splitter ... then simply follow the wizard.

 

[Pat Hartman]

I don't recall any that talk about "when" to split. As long as you use the wizard, it doesn't matter if you have 1 table or 100. You just run the wizard and it takes care of the process. If you do it manually, it becomes more work when you have more tables. I generally split the db once I have built all the tables. Once the db is split, any design changes to the tables must be made to the back end db. You can wait until just before you are ready to deliver the db to the users. I don't recommend that unless you thoroughly test every sub and function. I do it early rather than late to avoid the final retesting that doing it late requires.

 

[Crilen007]

hehe pat, he did ask how.

"just wondering how I can achieve this??"

 

[Pat Hartman]

We see different questions -

before i get too far and it becomes hard to split

- this was what he was wondering how to do. I read the question as one of timing (when) rather than method (how). And timing was what I addressed

 

[RyanB]

Thanks for your help Pat, good to see there are still some helpful ppl on this forum...

I didn't know it was such a crime to not know the keywords to use for a search...