Page 1 of 2 12 LastLast
Results 1 to 15 of 26
  1. #1
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    109

    Database is slowing after splitting

    I have a database which I split into front end and back end.



    I protected the backend with a password and a such, the front end couldnít find the back end.

    So I opened the front end, deleted all the linked tables in there and created a new link from the backend to the front end which worked perfectly.

    But after this, the system seem to be very slow when loading forms but that wasnít the case before.

    Any help with this to make it faster again will be greatly appreciated

  2. #2
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    780
    If the backend is on the server side and the front end is on the local PC it might be the network thzt is slowing down the database.

  3. #3
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    109
    Quote Originally Posted by NoellaG View Post
    If the backend is on the server side and the front end is on the local PC it might be the network thzt is slowing down the database.
    Both front end and backend are all on the same local drive.

    They are not even on a network yet.

  4. #4
    Welshgasman is online now Expert
    Windows 10 Access 2007
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    993
    Try different disks?, not logical partitions, but physical disks if you have more than one.
    Please, please use # when posting code snippets.
    Cross Posting Etiquette: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?search_query=debug+access+vba



  5. #5
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,171
    try compacting. I see no reason why relinking to the same tables would cause it to slow down. You don't also have the be open, nor is there a left over version running in the background (check in Task Manager)?
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  6. #6
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    109
    The issue existed on my laptop but thought if I tried on a different machine it wonít be slow.

    So far I have tried on two machines and is still slow. Maybe I will have to forget about splitting

  7. #7
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,171
    Maybe I will have to forget about splitting
    Leave the frying pan and jump into the fire??
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  8. #8
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    1,924
    Are you loading forms with all the records from the underlying tables?
    Do you have lots of sub-forms and combo's based on tables?

    How many records are your in your tables?

    If you remove the password protection do things improve?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  9. #9
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    109
    Quote Originally Posted by Minty View Post
    Are you loading forms with all the records from the underlying tables?
    Do you have lots of sub-forms and combo's based on tables?

    How many records are your in your tables?

    If you remove the password protection do things improve?
    Without the password protection, it is much faster

  10. #10
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,171
    I have linked tables to a password protected be with no ill effects and that was over a network. Maybe slowness on a local drive because your be has a password is a new thing, but if not there must be something else at play. You were prompted to provide the password when you linked the tables, yes?
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  11. #11
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    109
    Quote Originally Posted by Micron View Post
    I have linked tables to a password protected be with no ill effects and that was over a network. Maybe slowness on a local drive because your be has a password is a new thing, but if not there must be something else at play. You were prompted to provide the password when you linked the tables, yes?
    Yes I was prompted
    Of which I entered the password

  12. #12
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,171
    I googled "ms access 2016 db slow after linking password protected tables." First link I followed has a post with the accepted answer as being due to encryption. Was also suggested that a cause can be not using a UNC path but I don't think that would apply when the 2 files are on the same local drive. So are you using encryption? If not, I'm out of ideas except to say researching with that (or similar) term might reveal valuable information. If interested in that post it is at
    https://social.msdn.microsoft.com/Fo...orum=accessdev
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  13. #13
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    109
    Quote Originally Posted by Micron View Post
    I googled "ms access 2016 db slow after linking password protected tables." First link I followed has a post with the accepted answer as being due to encryption. Was also suggested that a cause can be not using a UNC path but I don't think that would apply when the 2 files are on the same local drive. So are you using encryption? If not, I'm out of ideas except to say researching with that (or similar) term might reveal valuable information. If interested in that post it is at
    https://social.msdn.microsoft.com/Fo...orum=accessdev
    I tried something but donít know if it is the best way out.

    I created a new database as my backend which I set the password on it . Then, I imported the tables from the front end to the back end using the link table option.

    By so doing, the database backend will contain a linked table from the front end whilst the front end contains both the actual tables and forms.

    Then I disable to shift bypass key.

    The way makes the database faster again.
    Is this the best?

  14. #14
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,171
    No, that makes no sense. Why have a be where the tables are linked to the front end file? Your fe file won't even bother with the be (although opening tables in the be will show the linked data but that is a 'backwards' setup).
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  15. #15
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    109
    Quote Originally Posted by Micron View Post
    No, that makes no sense. Why have a be where the tables are linked to the front end file? Your fe file won't even bother with the be (although opening tables in the be will show the linked data but that is a 'backwards' setup).
    So what do you suggest I do please?

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-09-2020, 03:57 PM
  2. TOP Query slowing down dramatically
    By cowboy in forum Queries
    Replies: 21
    Last Post: 06-26-2020, 06:25 AM
  3. TempVars Slowing Down Query?
    By jnoonan22 in forum Queries
    Replies: 4
    Last Post: 12-31-2015, 12:13 PM
  4. Function call in query slowing it down
    By sneuberg in forum Queries
    Replies: 2
    Last Post: 10-17-2014, 10:32 AM
  5. Database Splitting
    By Matthieu in forum Access
    Replies: 8
    Last Post: 02-08-2010, 03:37 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums