Results 1 to 9 of 9
  1. #1
    Old13 is offline Novice
    Windows 11 Office 365
    Join Date
    Jul 2022
    Posts
    4

    Sudden error with linked file (Error 3125)

    Hello all... I work with several MS Access databases that I have used for years. Today, all of a sudden, MS Access is giving me the following error message whenever I try to access any linked (text) file I've been using for years:"This is not a valid name. Make sure it is a valid parameter or alias name, that it does not include invalid characters or punctuation, and that the name is not too long."Looks like all the linked tables of all my (nine different) databases have been affected... Has been any recent Office update? Any idea why such error may occur all of a sudden, after everything being working fine all these years until last week??I just want to emphasize that I'm not trying to link a new file... Those files have literally been linked for years and I use the databases on a weekly bases... Also, the linked files are very simple (no weird characters or "too long" names. For example: "SALES.TXT")



    I've taken note of this forum policy ("Posting the same question on multiple websites (cross-posting) is strongly discouraged on this forum. If you really had to do it, please specify it in your post and list all links to your messages on other websites."), but I am desperate, I have a lot of work to do and I have been unable to do anything because of this problem. I've asked about this in Reddit (https://www.reddit.com/r/MSAccess/co...l_of_a_sudden/) and also in the Microsoft forum (https://answers.microsoft.com/en-us/...d-80267037e935), for the record...


    Click image for larger version. 

Name:	AccessError.jpg 
Views:	30 
Size:	107.8 KB 
ID:	48210

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Also at https://www.utteraccess.com/topics/2.../posts/2801665

    You say the same text files used for years - so names are the same but the content changes? Files are replaced?

    Your narrative says SALES.TXT but image shows SALES.ASC. I have never seen asc extension. Do these files have various file extensions?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Old13 is offline Novice
    Windows 11 Office 365
    Join Date
    Jul 2022
    Posts
    4
    Thank you for the feedback June... The files are updated every month (from a government website), last updated was about 3 weeks ago and everything went smooth as usual.... The downloaded files have the .ASC extension, but are just TXT/CSV files... I tried renaming one file from SALES.ASC to SALES.TXT and re-link it with that extension (TXT) to see if that changed anything, but I got the same error trying to relink it.... I'll check your link ASAP...

  4. #4
    Old13 is offline Novice
    Windows 11 Office 365
    Join Date
    Jul 2022
    Posts
    4
    Interesting that the thread in your link mentions an Office365 update on June 29th, 2022, that's probably it

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Oh, that linked thread is not yours?
    So maybe Office365 update has bug people are now stumbling over. Maybe rollback and see if issue goes away.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Time to check your version, and roll back on a PC.
    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

  7. #7
    Old13 is offline Novice
    Windows 11 Office 365
    Join Date
    Jul 2022
    Posts
    4
    Quote Originally Posted by June7 View Post
    Oh, that linked thread is not yours? .
    Nope, hehe... In that thread the error occurs when running code, in my case I see the error even if I just try to open the file within Access (or try to open a query that uses the offending tables)... Looks like the Office 365 update is the most likely culprit. I can survive a few weeks by importing (instead of linking) the files I need (importing doesn't give me an error) and hope the bug is fixed in a few weeks (I've never done a Office365 rollback, and it looks like importing the tables will be less hassle...) Thanks again for your help and feedback!

  8. #8
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Just roll back.
    Instructions are in that link https://www.utteraccess.com/topics/2.../posts/2801687
    Sorted the other poster's problem immediately?
    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

  9. #9
    wildidee is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2023
    Posts
    1
    Same error 3125 since today with an MS Access application that creates DNS-less connections to SQL server.
    Using VBA code like
    Code:
                    Set td = CurrentDb.CreateTableDef(tblToCreate, dbAttachSavePWD, remoteTblName, strConnect)
                    CurrentDb.TableDefs.Append td
    MS Access in Office 365 Version 2212

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

Similar Threads

  1. Replies: 13
    Last Post: 11-18-2021, 07:44 AM
  2. Sudden occurences of 3027 runtime error
    By GraeagleBill in forum Programming
    Replies: 2
    Last Post: 03-29-2021, 05:04 PM
  3. Replies: 4
    Last Post: 02-17-2016, 01:53 PM
  4. Error 2105 all of a sudden
    By TaliaKlein in forum Forms
    Replies: 7
    Last Post: 11-09-2015, 10:47 AM
  5. Button to open form sudden error
    By tgunarto in forum Macros
    Replies: 2
    Last Post: 11-21-2014, 01:04 AM

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