Viewing linked tables in split database
am 07.01.2008 17:38:55 von Patrick Fisher
I have a split Access 97 database, in the back end I have two linked tables,
one is an .xls file the other is a .csv file, the are supplying data which
changes several times a day. My problem is that I cannot see these tables in
the front end. Apart from running maketable queries in the backend in order
to make them into tables that the front end will see. I don't have a
solution. I do not want to link them to the front end as there are about 10
PCs involved. Any ideas anyone?
Cheers
Patrick
Re: Viewing linked tables in split database
am 07.01.2008 17:56:09 von none
"Patrick Fisher" wrote in message
news:3pedndtm2bo_yB_anZ2dnUVZ8s2mnZ2d@bt.com...
>
> I have a split Access 97 database, in the back end I have two linked
tables,
> one is an .xls file the other is a .csv file, the are supplying data which
> changes several times a day. My problem is that I cannot see these tables
in
> the front end. Apart from running maketable queries in the backend in
order
> to make them into tables that the front end will see. I don't have a
> solution. I do not want to link them to the front end as there are about
10
> PCs involved. Any ideas anyone?
> Cheers
> Patrick
>
>
If they are linked to the backed, how is the data being made available to
the front-end applications?