Results 1 to 8 of 8
  1. #1
    Jayshe9999 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2019
    Posts
    7

    Moving backend to SQL Server

    We are considering moving to SQL backend because of data corruption problems.



    30 users

    What SQL is recommended?
    Will the front end work seamlessly or is there a lot modifications needed?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    What version of SQL Server you mean? You can try Express, which is free.

    With linked tables, the app may work without modification, depending on your specifics. You gain a lot of tools you can use to enhance performance, but you can add them as needed. There are some things that work with Access tables but not ODBC tables, so only testing will determine how much modification you'll need to do.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Jayshe9999 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2019
    Posts
    7
    Which version do your recommend?
    Our server is Windows Server 2012 R2 standard edition 64-not (virtual) 16gb ram. Intel xenon cup 3.0ghz (4cpus) solid state hard drives.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Like I said I'd start with Express (2017 if you meant that):

    https://www.microsoft.com/en-us/sql-...-2017-editions

    Non-Express editions aren't cheap.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Just curious...... do you know WHY you are having corruption issues?

    Is your dB split?
    The BE is located where each user has R/W access?
    Each used has a COPY of the FE on their local computer?

  6. #6
    Jayshe9999 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2019
    Posts
    7
    It's been running fine for two years on a 2003 server with the split database and the front ends locally .When we switched to the 2012 virtual server is when the corruption started. We switched back to 2003 server. Running good again.

    We are currently averaging around 5 concurrent users . That will probably go to 15 when we add new applications .

  7. #7
    Jayshe9999 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2019
    Posts
    7
    Our IT guy says we are using the virtual machine as a file server and the server can't be the problem it has to be the program .Since access doesn't have error logs we can't figure out the problem . Since we will have to upgrade eventually we might as well do it now .

  8. #8
    theviking is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Northern New Jersey
    Posts
    15
    I agree with your IT guy, Access on the new VM server should not present a problem. I suspect it's a connectivity issue on the new box. Access is not a stateless database and as such needs to see a constant connection to the file server directory where your BE is stored. Ensure your connection to the new FS stays active. I would ask your guy to add a policy to ensure the network adapter stays active and there are no sleep settings active in the power plan.

    This could also be related to the SMB protocol in use. Have your IT guy check to see which version is in use and possibly enable an older version to test.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Moving backend of database to new location
    By acrowe97 in forum Database Design
    Replies: 2
    Last Post: 10-22-2018, 07:49 AM
  2. Moving Backend to Oracle or MySQL
    By ckulow in forum Access
    Replies: 1
    Last Post: 12-19-2017, 10:51 AM
  3. Replies: 3
    Last Post: 07-04-2017, 08:04 AM
  4. Moving an existing Access Database backend into a SQL Server?
    By IncidentalProgrammer in forum SQL Server
    Replies: 9
    Last Post: 09-16-2014, 08:13 AM
  5. Moving Backend
    By shariq1989 in forum Access
    Replies: 1
    Last Post: 08-05-2012, 02:46 PM

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