• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Search results

  1. sportsguy

    Solved I am not an idiot but

    @neuromann9999, ever lose 1/2 Million $, everything you have, with an arrogant attitude, thinking that you know everything? try it some time, and then you might realize that only idiots think that some things are easy and only idiots think they know it all. . . Thanks pbaldy. . . I just...
  2. sportsguy

    Solved I am not an idiot but

    I have a table, built from an excel source file to paste the excel data into (everything in this f* company is in excel) One of the field names is "EE_Status", short text 10 I cannot for the life of me, get the column to show up up in normal view, it shows up in design view, but not in the...
  3. sportsguy

    Naming a VBA selected range

    so far, All examples have failed, and yet, I don't exactly know why. I have extracted data from a SQL Server onto a tab named DATA, the row count will be different each time, but the column count is fixed. I highlight the data and am trying to assign the highlighted range to the name PIVOTDATA...
  4. sportsguy

    Agent Job Error running SSIS package importing Access database table

    @pisorsiaac - LOL! no worries, I want to get the certification, I admit that I am a SQL SERVER dba poser, I just don't have time, and at the end of my career, I don't have alot of studying desires! So I cheat alot (google), but I also don't like posterswith no experience or obviously haven't...
  5. sportsguy

    Agent Job Error running SSIS package importing Access database table

    thanks for the reply, obviously I am a poser :(. The actual error message is "The requested OLE DB provider Microsoft Jet OLEDB.4.0 is not registered." so the follow on messages are all about the failures due to that issue. And yes, the error only happens at run time. Let me look at the flat...
  6. sportsguy

    VBA to query the data from sql server and save the recordset in a table/view

    instead of creating a new table via vba, its easier to create a new table by copying and renaming an existing table with the desired or identical server table structure. This approach assumes that the SQLSERVER table structure remains constant. Then just run an append query, column for column...
  7. sportsguy

    Agent Job Error running SSIS package importing Access database table

    Hack SQLSERVER 2016 dba here, ie, not technically certified, but have enough experience to create properly designed tables, indexes, view queries, security users, schemas, procedures, and running all procedures from O365 ms Access from a button. However, I can't get a local file system SSMS...
  8. sportsguy

    Trying to Link Azure server hosted locally to Access

    Using the CAST function solves the issue. . .
  9. sportsguy

    Trying to Link Azure server hosted locally to Access

    I used the sql server native 11 ODBC driver, but I can't open any columns with a decimal column type. Is there a different ODBC driver I can use, or any settings, or do I need to set the columns to currenty or long or something Access will recognize? I have set the columns in the security area...
  10. sportsguy

    Office 365 Access 32 bit fails to compact a *.mdb database

    not repairing and compacting an Access 2003 *.mdb file, even when mt. Error message is "Selected collating sequence not supported with the specified file format." Any suggestions? Registry, retirement, lottery to put me out of my misery? thanks sportsguy
  11. sportsguy

    Getting Error 3035 System resource exceeded.

    SOLVED: Getting Error 3035 System resource exceeded. Found the answer: a back end database had exceeded the 2GB limit, because a back end database doesn't compact on close after a query action. I finally looked at the back end opened it, and then closed it, and now all is fine in access land...
  12. sportsguy

    Getting Error 3035 System resource exceeded.

    Its something else happening, because at some point, even a delete query causes the system resources to be exceeded. I can close the data base, reopen it, after compacting, and get the same error on a simple query, even a delete query. So I am sure that the database is corrupted somewhere, and...
  13. sportsguy

    Getting Error 3035 System resource exceeded.

    I seemed to have solved the issue, too many group by columns, so i eliminated enough columns to have the append query run. . . sportsguy
  14. sportsguy

    Getting Error 3035 System resource exceeded.

    So, I have tried running the query as a select query, works just fine. When i convert the query to an append query, and try to append it to the empty table in design view, the system resources exceed error message shows up in design view. The query will run without grouping and summing, meaning...
  15. sportsguy

    Getting Error 3035 System resource exceeded.

    Micron, LOL! no, i am not a noob! long long time access user who prefers sql server, but am working at a very old style, slow moving, company with a monopoly status legally, and i just need 6 more months for 401K vesting and 2-3 more years for retirement, and its like banking my head everyday...
  16. sportsguy

    Getting Error 3035 System resource exceeded.

    isladogs, actually, I will implement that strategy. . . I overthought the process, based on normal practice of having the form open for data review, but you make a great suggestion which can be implemented very easily, and still works for what i *need* to do. . . Thanks again, and I would like...
  17. sportsguy

    Getting Error 3035 System resource exceeded.

    and I know which query is blowing up the database, I just don't know how to fix it at the moment or why
  18. sportsguy

    Getting Error 3035 System resource exceeded.

    Gladly show me where in the registry where to increase records locks, etc, with cloud based office 365 . . . I have looked, and can't find the entry. See the attached graphic on the reply to DOCMAN. . . or which location i create the entry. I realize everyone is trying to help, I am just...
  19. sportsguy

    Getting Error 3035 System resource exceeded.

    Gemma, its the duplicate records which must be summed / totaled no matter what, because they system report has issues, and they are working on it. so thanks, but not really answering the question why does this work manually just fine, and not with VBA. . . sportsguy
  20. sportsguy

    Getting Error 3035 System resource exceeded.

    Docman, yes, I have a cloud version of Access 16, the corporate savior Office 365 (16) :p I can't find the registry entry after looking in all the places which were referenced in the links, so that is one of my issues, see the attachment for registry entries The other is yes, I checked the BE...
Top Bottom