Add table to split database
in [Tables]
|
Prev: Linked servers
Next: Compile: File Not Found
From: sweeneysmsm on 10 Apr 2010 13:33 I have a split Access Database on a network. I need to add a new table to the database. Do I export it to both the front end and the back-end or do I run a relinking module or do they just find each other "across a crowded room" when the stars align:)? Thank you for any insight. Mary
From: Daniel Pineault on 10 Apr 2010 13:43 Ensure no one is working in the db (no ldb back-end file) and then you take if offline. Do not keep a copy on your server or else people may do work which they will loose! Then make the modifications you require (add the new table). Then place the back-end file back in place Open your front-end and Import -> Link the new table Finally, once you have made the form, queries, reports,... for this new table, distribute a new version of your front-end to all your users. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "sweeneysmsm" wrote: > I have a split Access Database on a network. I need to add a new table to the > database. Do I export it to both the front end and the back-end or do I run a > relinking module or do they just find each other "across a crowded room" when > the stars align:)? > > Thank you for any insight. > > Mary
From: sweeneysmsm on 10 Apr 2010 13:55 Hi, Daniel, Thank you for your so-speedy reply. One question: When you say "Open your front-end and Import -> Link the new table", are you saying that I first Import the table, and then link it, or do you mean to go to Get External Data but choose link instead of import. Or do you mean import the structure of the table and then Link it? Just want to be sure that I understand exactly what you are saying. Mary "Daniel Pineault" wrote: > Ensure no one is working in the db (no ldb back-end file) and then you take > if offline. Do not keep a copy on your server or else people may do work > which they will loose! > > Then make the modifications you require (add the new table). > > Then place the back-end file back in place > > Open your front-end and Import -> Link the new table > > Finally, once you have made the form, queries, reports,... for this new > table, distribute a new version of your front-end to all your users. > -- > Hope this helps, > > Daniel Pineault > http://www.cardaconsultants.com/ > For Access Tips and Examples: http://www.devhut.net > Please rate this post using the vote buttons if it was helpful. > > > > "sweeneysmsm" wrote: > > > I have a split Access Database on a network. I need to add a new table to the > > database. Do I export it to both the front end and the back-end or do I run a > > relinking module or do they just find each other "across a crowded room" when > > the stars align:)? > > > > Thank you for any insight. > > > > Mary
From: John W. Vinson on 10 Apr 2010 15:11 On Sat, 10 Apr 2010 10:55:01 -0700, sweeneysmsm <sweeneysmsm(a)discussions.microsoft.com> wrote: >go to Get External Data but choose link instead of import That's what you want to do. -- John W. Vinson [MVP]
From: Daniel Pineault on 10 Apr 2010 15:20
Since we are talking about a split database, then all you want to do is create a link in your front-end to your newly created back-end table. "Get External Data but choose link" -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "sweeneysmsm" wrote: > Hi, Daniel, > > Thank you for your so-speedy reply. > > One question: When you say "Open your front-end and Import -> Link the new > table", are you saying that I first Import the table, and then link it, or > do you mean to go to Get External Data but choose link instead of import. Or > do you mean import the structure of the table and then Link it? Just want to > be sure that I understand exactly what you are saying. > > Mary > "Daniel Pineault" wrote: > > > Ensure no one is working in the db (no ldb back-end file) and then you take > > if offline. Do not keep a copy on your server or else people may do work > > which they will loose! > > > > Then make the modifications you require (add the new table). > > > > Then place the back-end file back in place > > > > Open your front-end and Import -> Link the new table > > > > Finally, once you have made the form, queries, reports,... for this new > > table, distribute a new version of your front-end to all your users. > > -- > > Hope this helps, > > > > Daniel Pineault > > http://www.cardaconsultants.com/ > > For Access Tips and Examples: http://www.devhut.net > > Please rate this post using the vote buttons if it was helpful. > > > > > > > > "sweeneysmsm" wrote: > > > > > I have a split Access Database on a network. I need to add a new table to the > > > database. Do I export it to both the front end and the back-end or do I run a > > > relinking module or do they just find each other "across a crowded room" when > > > the stars align:)? > > > > > > Thank you for any insight. > > > > > > Mary |