User Profile

Collapse

Profile Sidebar

Collapse
rharding
rharding
Last Activity: Jan 11 '07, 04:53 PM
Joined: Jan 4 '07
Location: Houston
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rharding
    replied to 3035 - System resource exceeded in Windows 2000
    in Access
    I have been able to solve my problem by using TransferText to import the csv file to a new Access table. I then use the Upsizing Wizard to create the SQL table. Now Access can communicate with SQL using terminology (Data Types) that Access understands.

    In general the only problem with this happens to be with certain data types that Access creates which are different than the data types the SQL data dictionary is calling for. For example,...
    See more | Go to post

      Leave a comment:

    • rharding
      started a topic System resource exceeded (SQL / Access Application)
      in SQL Server

      System resource exceeded (SQL / Access Application)

      Access Application Problem with Linked Table

      I am having a problem loading data into a SQL table using an Access TransferText command. The above link is to a discussion dealing with the problem. I would appreciate any help.
      See more | Go to post
      • rharding
        replied to 3035 - System resource exceeded in Windows 2000
        in Access
        Can you tell me how to post a link to this thread?...
        See more | Go to post

          Leave a comment:

        • rharding
          replied to 3035 - System resource exceeded in Windows 2000
          in Access
          I tried your second suggestion and the entire csv file gets imported. It is only when I attempt to use the linked SQL table that I have a problem. I think the problem has something to do with the data types as specified on the SQL table and the data types as specified in the import specification.

          The SQL data dictionary (from the vendor) specifies some fields as varchar (770 and 3000), some fields as tinyint (1), and some fields as...
          See more | Go to post

            Leave a comment:

          • rharding
            replied to 3035 - System resource exceeded in Windows 2000
            in Access
            I limited my import to 300 rows, 10,000 rows, and 20,000 rows with successful results. At 25,000 rows it failed with the 3035 error message. Memory usage on the PC was not affected, nor was anything else I looked at.

            Does anyone have a suggestion?...
            See more | Go to post

              Leave a comment:

            • rharding
              started a topic 3035 - System resource exceeded in Windows 2000
              in Access

              3035 - System resource exceeded in Windows 2000

              I am getting a "3035 - System resource exceeded" error message when running a DoCmd.TransferT ext to load a .csv file into a SQL linked table using Access 2003 on Windows 2000. The .csv file contains 34804 rows and is 30 columns wide (19,086 KB).

              I have changed the registry setting of MaxLocksPerFile to 1,500,000 but this does not help. I have seen another discussion in thescripts concerning this but the questioner appears...
              See more | Go to post
              • rharding
                started a topic SQL's "bigint" data type and linked table in Access
                in Access

                SQL's "bigint" data type and linked table in Access

                I have a SQL database which contains a table (TblA) with a field (Fld1) defined as "bigint". When the SQL table is linked to Access the design view of the linked table shows this field as a data type of "Text".

                I have another linked table (TblB) with a field (Fld2) defined as "int". I need to join TblA to TblB using Fld1 and Fld2 as the join. This of course does not work. There is a data type mismatch...
                See more | Go to post
                • rharding
                  replied to MDB Space Usage Growth
                  in Access
                  Thank you for the link to the compaction code.

                  Remember I have a front-end MDB (MDB1) and a data MDB (MDB2). Now my question is:

                  I know you can start Access standalone and compact MDB2 and you can open MDB2 in Access and compact it in place. However, can MDB1, which deletes and reloads the tables and therefore has the tables from MDB2 linked (attached) to it, run the compaction code against MDB2? Another way of asking...
                  See more | Go to post

                    Leave a comment:

                  • rharding
                    replied to MDB Space Usage Growth
                    in Access
                    Additional information.

                    This is a reporting database. Aside from my once a day delete/reload of the tables, very little table updating is done by users.
                    See more | Go to post

                      Leave a comment:

                    • rharding
                      replied to MDB Space Usage Growth
                      in Access
                      While I understand that Access is ignoring the MDB space that was used by the tables that were deleted, I am not certain that fully explains the quick growth in space usage. The data that I am loading does not increase in size significantly over time. I would therefore expect a fully compacted MDB of 380MB to about double in size after a delete and reload processing run. What I am seeing is an immediate jump to the 2GB limit.

                      I will...
                      See more | Go to post

                        Leave a comment:

                      • rharding
                        started a topic MDB Space Usage Growth
                        in Access

                        MDB Space Usage Growth

                        I have a process which runs automatically once a day looping through a set of table names deleting all the data from the table (DoCmd.RunSQL "DELETE * FROM " & MyQry!Name) and then importing data from CSV files (DoCmd.Transfer Text acImportDelim,. ..) back into the table. Some of the tables are extremely large.

                        The VBA code and the data are on separate MDBs. I am using Access 2002-2003 file format.

                        When the...
                        See more | Go to post
                        No activity results to display
                        Show More
                        Working...