N
norm
I am trying to split my Access Data Base into a front end and a back end,
but I keep getting a:
SUBSCRIPT OUT OF RANGE error
I tried making a copy of the data base deleting the tables, then linking to
another copy of the database (the back end) It works fine one the machine
that is holding both front end and back end files, Now if I create another
front end on one of my network machines and link the tables to the original
back end file (the host machine) my forms will not diplay any data, if I
close one of the databases, the other one works fine, it does not matter
which machine is accessing the data but the form must be closed on one of
them in order to work. I am using Access 2003.
but I keep getting a:
SUBSCRIPT OUT OF RANGE error
I tried making a copy of the data base deleting the tables, then linking to
another copy of the database (the back end) It works fine one the machine
that is holding both front end and back end files, Now if I create another
front end on one of my network machines and link the tables to the original
back end file (the host machine) my forms will not diplay any data, if I
close one of the databases, the other one works fine, it does not matter
which machine is accessing the data but the form must be closed on one of
them in order to work. I am using Access 2003.