Split Database

[Guest]

Some while ago, I split my database into a Front End (Forms etc) and a Back
End (Tables only). I have since added some further tables and all works well.
However, when I check through the Table Manager to update everyihimg, i find
that my new Tables are not listed. When I check back in the Datasheet and
select the Tables tab, I see that the old Tables have a little arrow at the
side of them and my new Tables Don't. My conclusion is that the new files are
located in the Front End and the old Tables are listed in the Back End. How
can I get the new Tables to appear in the Linked Table Manager Window so I
can sellect them? OR how do I move the New Tables from the Front End to the
Back End?

Thanks RayC

 

[Larry Daugherty]

First backup both FE & BE.

Open the back end and Get External Data - Import. Navigate to the
Front End, select the new tables and import them. Close the Back End.

Go to the Front End and delete those tables you just copied to the
Back End. Get External Data and this time choose Link. Navigate to
the Back End and select those same new tables. Click OK. You're
done. If all went well you can delete the backup.

HTH

 

[Guest]

Larry's method will cure the current problem; however, be aware that in the
future, you should create your tables in the Back End. A table resides in
the mdb in which it is created. Then, when the table is created in the Back
End. Open the Front End and use the Linked Table Manager to link to the
table.

I suggest using that rather than the File, Get External Data because you
need to be sure you are setting the correct path. If you have deployed your
application correctly, each user will have his own copy of the Front End
linked to the Back End in a shared folder or on a file server.

As I am sure you are aware, the same network folder will most llikely be
mapped to different drives on different computers. In other words, you may
have the folder mapped to drive F: on you computer, but another user may have
it mapped to drive M:. If you link to the Back End from your computer, the
person who has the folder mapped to M: will get an error, because it is
looking for the Back End on drive F: and it will not find it. So, when you
do your linking you will want to use UNC drive mapping which is
\\Server\folder\subfolder. That way, as long as the user has permissions to
the folder, it will not matter which drive that have it mapped as.

 

[Guest]

Great
So simple when you know how.

Thanks and Regards RayC

 

[Guest]

Really good stuff, all of the things that I would not hav thought about.
Thanks for the response.

RayC