Prev: repair database exclusive open
Next: Filtering a Form Based on a Subform
From: iccsi on 4 May 2010 15:36
I name my System Table USystblsystem in the backend for the system
purpose.
I tried to link USystblSystem to my frontend, but the system table
does not show in the list.

Are there any way to link backend system table to frontend?

Your information is great appreciated,
From: Marshall Barton on 4 May 2010 18:43
iccsi wrote:

>I name my System Table USystblsystem in the backend for the system
>purpose.
>I tried to link USystblSystem to my frontend, but the system table
>does not show in the list.
>
>Are there any way to link backend system table to frontend?


When you name a table USYSsomthing is it treated similar to
the internal Access table named MSYSsomething and are
hidden by default. Try showing the hidden tables and if
that doesn't help try renaming the table without the USYS
part.

--
Marsh
MVP [MS Access]
From: iccsi on 7 May 2010 08:21
On May 4, 6:43 pm, Marshall Barton <marshbar...(a)wowway.com> wrote:
> iccsi wrote:
> >I name my System Table USystblsystem in the backend for the system
> >purpose.
> >I tried to link USystblSystem to my frontend, but the system table
> >does not show in the list.
>
> >Are there any way to link backend system table to frontend?
>
> When you name a table USYSsomthing is it treated similar to
> the internal Access table named MSYSsomething and are
> hidden by default.  Try showing the hidden tables and if
> that doesn't help try renaming the table without the USYS
> part.
>
> --
> Marsh
> MVP [MS Access]

Thanks millions for helping,
 | 
Pages: 1
Prev: repair database exclusive open
Next: Filtering a Form Based on a Subform