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
    272

    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
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    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
    272
    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
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Try different disks?, not logical partitions, but physical disks if you have more than one.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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)?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    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 offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Maybe I will have to forget about splitting
    Leave the frying pan and jump into the fire??
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  8. #8
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    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
    272
    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 offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  11. #11
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    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 offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  13. #13
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    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 offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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).
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  15. #15
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    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