Good Morning all,
I have some really odd behaviour on a split database I have.
I have just imported a database into an already large split database. Once imported the new parts of it work fine, no problems at all. I then put only the tables into a different location, deleted the tables in the FE and linked the BE tables again.
Again it works....almost! I have a query which takes data from a table, the table (BE) and query (FE) show the correct data, I have a form that uses data from the query, the form shows all the data correctly except for one field, it is really odd, it worked before I split the DB and the BE table and FE query both show the correct data, the form is showing all the other fields expect one. I've tried deleting the field from the form and adding it back in and it stays the same, the property settings are the same as all the other fields that are showing....I'm really stumped, not sure if anyone has experienced anything like this before?
The only other way I can think of to get it working is to hold the new database in the shared network and just put some code on the main DB to open the new section as a separate DB.....not ideal but at least it would work. Any ideas most welcome before I do this!!
Cheers
I have some really odd behaviour on a split database I have.
I have just imported a database into an already large split database. Once imported the new parts of it work fine, no problems at all. I then put only the tables into a different location, deleted the tables in the FE and linked the BE tables again.
Again it works....almost! I have a query which takes data from a table, the table (BE) and query (FE) show the correct data, I have a form that uses data from the query, the form shows all the data correctly except for one field, it is really odd, it worked before I split the DB and the BE table and FE query both show the correct data, the form is showing all the other fields expect one. I've tried deleting the field from the form and adding it back in and it stays the same, the property settings are the same as all the other fields that are showing....I'm really stumped, not sure if anyone has experienced anything like this before?
The only other way I can think of to get it working is to hold the new database in the shared network and just put some code on the main DB to open the new section as a separate DB.....not ideal but at least it would work. Any ideas most welcome before I do this!!
Cheers