A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Add table to split database



 
 
Thread Tools Display Modes
  #1  
Old April 10th, 2010, 06:33 PM posted to microsoft.public.access.tablesdbdesign
sweeneysmsm
external usenet poster
 
Posts: 74
Default 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  
Old April 10th, 2010, 06:43 PM posted to microsoft.public.access.tablesdbdesign
Daniel Pineault
external usenet poster
 
Posts: 658
Default 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  
Old April 10th, 2010, 06:55 PM posted to microsoft.public.access.tablesdbdesign
sweeneysmsm
external usenet poster
 
Posts: 74
Default 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  
Old April 10th, 2010, 08:11 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old April 10th, 2010, 08:20 PM posted to microsoft.public.access.tablesdbdesign
Daniel Pineault
external usenet poster
 
Posts: 658
Default 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  
Old April 10th, 2010, 09:16 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old April 10th, 2010, 11:10 PM posted to microsoft.public.access.tablesdbdesign
sweeneysmsm
external usenet poster
 
Posts: 74
Default 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  
Old April 10th, 2010, 11:12 PM posted to microsoft.public.access.tablesdbdesign
sweeneysmsm
external usenet poster
 
Posts: 74
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.