Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Fri, 26 Sep 2008 14:13:01 -0700,    group: microsoft.public.access.queries        back       


backend table not showing in linked table manager   
I used a make table query to create a table. The table shows in the front end 
but not the backend. What should I do so the table will be in the backend 
instead of the front end? I tried to export the table but the Linked Table 
Manager still does not show the new table.

Thanks.
date: Fri, 26 Sep 2008 14:13:01 -0700   author:   themartellekid

RE: backend table not showing in linked table manager   
There are 2 methods:
First:
------
-create the table with a make table wizzard , using the option create in 
"another database"
- link the the new table manually or using VBA to the current db

Second:
---------
-Create in your back-end DB a dummy table with the same name of your new table
-Link it to yout front-end DB
-Create your make-table query, option create in "another database"
destination back-end DB


-- 
Kind regards
Noëlla


"themartellekid" wrote:

> I used a make table query to create a table. The table shows in the front end 
> but not the backend. What should I do so the table will be in the backend 
> instead of the front end? I tried to export the table but the Linked Table 
> Manager still does not show the new table.
> 
> Thanks.
date: Fri, 26 Sep 2008 16:33:01 -0700   author:   Noëlla Gabriël

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us