Re: splitting database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
Sorry to keep bothering you....

When I want to split the project as you suggested (keeping the 2 main tables in the same file as the report/querry...) I haven't got the possibility to select which table I want in the new file... all tables finally arrive in the new "splitted" file.

Any help is welcome

JP

Jeff Boyce wrote:
Jean-Paul

You could "split" your database as you've described, and, depending on how you name your "file b", you might not have any issues.

Another consideration, since you are talking about the possibility of replacing the "file a" with a new/updated version, could be to keep the application/forms/queries/reports/etc in "file a" AND the two tables you'll be updating. Then the only portion that would need to be linked would be the tables in "file b".

Just a thought...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Jean-Paul" <jp.dewinter@xxxxxxxxxx> wrote in message news:g2CDj.79185$uP2.37907@xxxxxxxxxxxxxxxx
Hey Jeff.... thanks for the reply and the "willing to help".

I try to explain what I'm up to (in the best English I know <BG>)

I wrote a project for a school my wife works in.
I use a table with all students, adresses and so on, and a table with the teachers details.
Beside these tw tables, I use tables where teachers all store their proper data in. These tables differ form teacher to teacher.
The idea is that when I put the first 2 tables in file a and the rest in file b, I only have to send each teacher file a when data change. The tables in file b are "individual" and will never be changed in global.

Hope you understand the situation better now.

Now I splitted the project in a table file and a "program" file, but I want to get 2 different table files and a program file.

Thanks for your kind help
JP Belgium (normally speaking Dutch)

Jeff Boyce wrote:
Jean-Paul

You've described "what" you want to do.

Now, "why"? What business need are you trying to solve by putting some tables in one .mdb file and some in another?

I ask, not from simple curiosity, but because knowing more about your underlying business need might help the folks who volunteer here offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Jean-Paul" <jp.dewinter@xxxxxxxxxx> wrote in message news:jUfDj.160624$_Y.24168@xxxxxxxxxxxxxxxx
Hi,
I know how to split my database so tables are in a different file then
the rest of my project.
But, I want to setup my project so that some tables are in file a.mdb
and some are in file b.mdb.
How can I do that?
Thanks
JP

.

Relevant Pages

  • Re: splitting database
    ... If I had a single .mdb file with everything in it, ... Microsoft Office/Access MVP ... Jeff Boyce wrote: ... These tables differ form teacher to teacher. ...
    (microsoft.public.access.setupconfig)
  • Re: splitting database
    ... These tables differ form teacher to teacher. ... Now I splitted the project in a table file and a "program" file, but I want to get 2 different table files and a program file. ... Jeff Boyce wrote: ... I ask, not from simple curiosity, but because knowing more about your underlying business need might help the folks who volunteer here offer more specific suggestions. ...
    (microsoft.public.access.setupconfig)
  • Re: splitting database
    ... You could "split" your database as you've described, and, depending on how ... These tables differ form teacher to teacher. ... Jeff Boyce wrote: ... underlying business need might help the folks who volunteer here offer ...
    (microsoft.public.access.setupconfig)
  • Re: splitting database
    ... Jeff Boyce wrote: ... If I had a single .mdb file with everything in it, and wanted to end up with, say 5 tables in another .mdb file, and link to those from a "new" ... "Jean-Paul" wrote in message ... These tables differ form teacher to teacher. ...
    (microsoft.public.access.setupconfig)
  • Re: Need help with Recursion Program today!!!!
    ... Do you know how to create a program file with a particular name? ... public class CountProgram { ... In not then you need to talk to your teacher to clarify what s/he ...
    (comp.lang.java.programmer)