Search results

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...

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...

Using the CAST function solves the issue. . .

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...

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

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...

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...

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

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...

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...

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...

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

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...

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

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...

FE size = 16 megs, BE size = 150 megs after loading 80K records, 13megs after loading 20K records don't think that is the issue. . . sportsguy

good afternoon readers! I have manual queries which run just fine, but in the following sub, the second append query blows up and give the error 3035 System resource exceeded. :banghead: so I am asking for the experts' help. The data is copied from excel and pasted into a form in table...

June7, um, I am asking if there is any VBA to move the tables to the custom groups. I know how to use the groups manually, which was the original question in the first post. So, do you know how to move tables to groups with VBA? Thanks! sportsguy

sorry, within Access, in the custom view, you can create categories, I called them folders. I want to move a table from unassigned to a category. Thanks! sportsguy

Is there any VBA which has been written to move tables into custom folders? I have some VBA which deletes and reattaches tables which makes people saving the front end and back ends to their local drives from the network a single click. I use it when moving tables from front end dev to back...