+ Post New Thread
Results 1 to 8 of 8
Group Project Thread, Help with Access Database in Coding and Web Development; Hi! I had an idea for a fairly complex Access database that my department could use to find teaching resources ...
  1. #1

    Join Date
    Jan 2008
    Location
    London
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Help with Access Database

    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

  2. #2

    Join Date
    Mar 2007
    Posts
    307
    Thank Post
    3
    Thanked 9 Times in 8 Posts
    Rep Power
    16
    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.

  3. #3

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,986
    Thank Post
    850
    Thanked 2,653 Times in 2,253 Posts
    Blog Entries
    9
    Rep Power
    764
    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.

  4. #4

    Join Date
    Feb 2009
    Location
    Littlehampton
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Network Location

    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.

  5. #5

    Join Date
    Feb 2009
    Location
    London
    Posts
    9
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    used to use access but migrated to sql server - much better. can have a look if it would help

  6. #6

    Join Date
    Feb 2007
    Posts
    82
    Thank Post
    21
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Another Route

    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!!

  7. #7
    PeterG's Avatar
    Join Date
    Jan 2009
    Location
    Ramsgate
    Posts
    42
    Thank Post
    8
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Back End ?

    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

  8. #8

    Dos_Box's Avatar
    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    9,785
    Thank Post
    572
    Thanked 2,151 Times in 981 Posts
    Blog Entries
    23
    Rep Power
    625
    You have checked the dates on this thread haven't you?

SHARE:
+ Post New Thread

Similar Threads

  1. Open password protected access 2007 database with ASP
    By ryan_powell in forum Web Development
    Replies: 0
    Last Post: 31st January 2008, 02:52 PM
  2. access database
    By Uraken in forum Coding
    Replies: 0
    Last Post: 11th October 2007, 11:19 AM
  3. Reading an Access database with .Net 2.0
    By Jobos in forum Web Development
    Replies: 2
    Last Post: 22nd May 2007, 09:49 AM
  4. HELP!!!! - Database
    By lalalalalalalalalalala in forum How do you do....it?
    Replies: 1
    Last Post: 21st March 2007, 09:03 PM
  5. Replies: 4
    Last Post: 28th February 2007, 09:37 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •