Control Centre

[colenzo]

[FONT=&quot]Hey all, I’m probably asking a really stupid question, I’m a little lost and out of ideas at the moment.

I want to create a control centre of sorts to overview 3 databases live where i can see who is in them, whether new records have been added, possibly how long they have been in them and various other little titbits of information. The individuals using these databases unfortunately cant tell a desktop computer from a "modem", as one of them calls the tower sitting on the desk, so I need a way of keeping an eye on whose in what database, as i suspect that someone has been entering incorrect records.

Is this something I can create in a linked database, or is it something I'll have to get software for,

Any advice appreciated

Colenzo xx[/FONT]

 

[reddwarf]

you can use some basic sql to JOIN the tables asummin all of your tables have similar fields. eg USERNAME - TIMEINRECORD - RECORD NAME etc etc

but this is slow and complex.

best thing is to create a new db. LINK the tables from your other 3 projects into it. then create a "mini" dashboard for each. the use 1 form made up of 3 subforms ( one for each database ).

you will have to play with what data is in those subforms though. As far as I am aware there is no generic free dashboard for Access DB's. you might be able to get a "pay" one from somewhere though.