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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

split database question



 
 
Thread Tools Display Modes
  #1  
Old August 29th, 2006, 10:27 PM posted to microsoft.public.access.forms
chouetteray
external usenet poster
 
Posts: 5
Default split database question

I split the database and created a new table in the backend part. Then when
I went to the front end to create a new form I don't see the new table. How
do I get it to show up in the front end?
  #2  
Old August 29th, 2006, 11:04 PM posted to microsoft.public.access.forms
Al Campagna
external usenet poster
 
Posts: 421
Default split database question

chouetteray,
Whenever you add a new table to the backend, you must "link" it to the frontend.
File/Get External Data/Link Tables... and select the new table.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"chouetteray" wrote in message
...
I split the database and created a new table in the backend part. Then when
I went to the front end to create a new form I don't see the new table. How
do I get it to show up in the front end?



  #3  
Old August 29th, 2006, 11:05 PM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default split database question

On Tue, 29 Aug 2006 14:27:01 -0700, chouetteray
wrote:

I split the database and created a new table in the backend part. Then when
I went to the front end to create a new form I don't see the new table. How
do I get it to show up in the front end?


Open the frontend; from the menu select File... Get External Data...
Link. Navigate to the backend database and select the new table. The
link will remain part of the frontend, and the new table will now be
available.

John W. Vinson[MVP]
 




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:53 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.