I am hopping someone can help me on this forum but giving me some suggestions or web sites. I have an acces 97 database with a couple of tables. One to many relationship. I have upsized to sql because the table was getting too large. I linked the tables back to access renaming them to what the old name used to be. The subforms does not seem to work.
I tried to update the relatiionships back in access(one to many relationship) but it does not work. Has anyone attempted to use sql back end and access frot end with subforms. Please help me if you can. I am learning very slowly sql so I am thinking that I probably have to do something else in sql to the tables but at this point I am not sure.
villica
I tried to update the relatiionships back in access(one to many relationship) but it does not work. Has anyone attempted to use sql back end and access frot end with subforms. Please help me if you can. I am learning very slowly sql so I am thinking that I probably have to do something else in sql to the tables but at this point I am not sure.
villica
