Help with Access Database
I had an idea for a fairly complex Access database that my department could use to find teaching resources including past papers, videos and other stuff. In fact I designed it so that any department could make use of it.
I've set it up with some different fields according to resource type and it has hyperlinks to the resource and any linked resources. There are some fun bits too which allow linking resources and rating them.
I got myself on a VB/SQL training course and I managed to get it to work to a fashion. But as soon as I separated the back end so it would work with multiple users it slowed to an unusable crawl. It's a nice idea, but obviously my VB and SQL are rubbish.
Would anyone be prepared to look at this project with me? I reckon it could be a really useful tool for departments with lots of digital resources.
Hope someone can help!