Help with Access Database

[LozWesson]

Hi!
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!
Cheers,
Loz

[pallen]

Dont really know that much about access,but have you tried to compact and repair the database? Failing that, when you have split the database have you used the network name for the backend? I have found it can work better if you use the IP address rather than the network name.

Thats about the extent of my experience sorry. I'm sure someone will be able to help though.

[SYNACK]

Just to clarify, how is the project put together. Is the application based solely in access or does it have an asp or other typeof front end on top.

If it does have a presentation layer like this I would make sure that they both resided on the same server and make sure the MDAC components are up to date. If this does not increase the speed enough you may want to use the access upsizeing wizard to upgrade it to a SQL express DB as access has awful performance and data consistency problems when dealing with large databases.