If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add table to split database
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 |
#2
|
|||
|
|||
Add table to split database
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 |
#3
|
|||
|
|||
Add table to split database
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 |
#4
|
|||
|
|||
Add table to split database
On Sat, 10 Apr 2010 10:55:01 -0700, sweeneysmsm
wrote: go to Get External Data but choose link instead of import That's what you want to do. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Add table to split database
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 |
#6
|
|||
|
|||
Add table to split database
On Sat, 10 Apr 2010 10:33:01 -0700, 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 One note: I've found problems when you make design changes to tables in the backend. It may be a bit paranoid but now if I make ANY structural change to a backend table, I'll be sure to open the backend exclusively; make the change (or add the table or whatever); open the frontend and DELETE the link and compact and repair the frontend. Then I'll use File... Get External Data... Link to (re)link to the table. -- John W. Vinson [MVP] |
#7
|
|||
|
|||
Add table to split database
Thank you for this good advice. I am actually not making a change to an
existing table, but rather adding an additional table. I will keep what you said in mind for the future. Mary "John W. Vinson" wrote: On Sat, 10 Apr 2010 10:33:01 -0700, 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 One note: I've found problems when you make design changes to tables in the backend. It may be a bit paranoid but now if I make ANY structural change to a backend table, I'll be sure to open the backend exclusively; make the change (or add the table or whatever); open the frontend and DELETE the link and compact and repair the frontend. Then I'll use File... Get External Data... Link to (re)link to the table. -- John W. Vinson [MVP] . |
#8
|
|||
|
|||
Add table to split database
Thank you to all who helped me to clarify my task. I really appreciate it.
Mary |
Thread Tools | |
Display Modes | |
|
|