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.

[Yardley]

Where do you have the files stored?

The front end should be stored on the local PC.

If the users access the front end from a network drive or share it will double the network traffic as it copies the query to the local PC before accessing any data.

You should also make sure that the query only selects the data it needs.

[alan7736]

used to use access but migrated to sql server - much better. can have a look if it would help

[benIT]

Have you thought of using sharepoint, even the free one to start with. This would then hold the documents in the database, it also dynamically updates links if document names change etc.

may save you some hassle, plus give you lots of bonus features!!

If not hope you find your answers, I am sure you will here!!

[PeterG]

Hi,,

This is my first post here and i have had some experience of access can you personal message me the details of the database and we can see what we can do....

How are you operating it on the network.


Pete