after splitting my database to allow multiple users, some queries have stopped workin

[vid]

Hi!

I have a database which multiple users must have access to at the same time. I read online about splitting the database to allow that, so i went ahead and did that.

In my database there are buttons to generate reports based on certain queries. After splitting the database for some weird reason, the queries don't work anymore. And its only these queries which don't work. The ones on which the report is based. Rest all work well...

I'm clueless.. please help!!!!!!!!!!

I'm attaching the 2 split parts of my database! hope that helps...

 

[RainLover]

Try relinking your tables.

Also Date is a reserved word and should not really be used as a Field Name.