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