Hi I am trying to use a Access to link to tables in a SQL server database. However it is doing some of the strangest things. Persently now I have copied the backend from the access database into a SQLserver and then I linked all the tables, but the forms are showing anything at all, if I login to some seperate forms it seem to pick up the content of the table and if I log onto the tables singularlyu it semes to be fine. It just all the usual login and startup form just show gray screens.
Does anyone have any idea what could be causing this and how I could fix it , thanks Ed