Search results

Hello again. I'm trying to use VBA to run SQL that will run a 'Make Table' query and create a table in another database. Unfortunately, both the database path and database name if the target database contain spaces. This is giving me a headache trying to come up with a syntax that will not...

Thanks again to everyone. I settled on splitting the query into two. The first creates a table that sums a field and filters records. That reduces the search records by 90%. It needs to run once a week. The second, which is run often selects records based on 'month'. No more resource problems.

Thank you all for contributing. ebs17, do you mean your query should create a temporary table which a second query would reference, or should your query be a subquery within a query? Sorry, but I'm new to this and could you please give example SQL.

Thank you very much.

May I ask another question related to this please? About query efficiency, let's say smallTab has 10,000 records, mediumTab has 100,000 records and bigTab has 1,000,000 records. smallTab has field 'zip' mediumTab has fields 'zip' and 'id' bigTab has field 'id' I want to select records where...

Thanks.

I need and will appreciate any help with this. I'm sure I'll have to clarify but here's a start to explaining my problem. Running MS Office 365. When running this query, we get 'System Resources Exceeded' error message from MS Access. Table T1 has 11,000 records, T2 has 43,000 records, and...

Thank you.

Thanks. The error about resources exceeded was happening around the same time the other messages were occurring. That message could have been caused by an overly complicated macro that called several queries. The macro was changed and I don't think it happened again. We're just not sure...

Thanks. Can you please give more information? What patch created the problem? What did you roll back to? I've been checking online but there's so many variations of possible fixes, all the way to converting the Access DB to SQL Server database.

Is anyone having problems with running Access (16 or Office 365) on a server running Windows Server 2019? Problems may include "Unrecognizable database format" , "I/O Error", "System Resources Exceeded" messages. Thanks for responses.

Yes, I do a Remote Desktop Connection to a server that's been upgraded to Windows Server 2019 Standard with RAID 5 disks. I do not have this problem when the databases are on my local machine. Also, a user that is local to the server does not have the problem. Thanks.

Hello again. I routinely run database update on a remote server, RDP'ing into it. After a recent server upgrade, I am now getting the subject error whenever I run a 'Saved Imports' spec. Both databases are on my remote desktop. Sometimes the spec runs successfully but it is very...

When I first posted this topic, I had encountered what I thought was a hole in security when I used Autoexec (RunCode) to verify user-id and password. The hole occurs when the user has not enabled macros or when they move the database to an un-trusted location. In either of those cases, the...

So I moved the verify user code to a load event for a hidden form. After a lot of testing and adjusting everything seems to work the way I want except for one kludge. For an 'Admin' person wanting to open the FE, ribbon menus and shortcuts are initially disabled. That's because the unload...

So, does 'IsTrusted' mean that 'Macros are enabled'; i.e., that a 'run code' macro will run? If 'macros are disabled' but the database is in a trusted location, does that also mean that the macro will run? Thanks.

theDBguy. I need help with that. What would the macro look like? I tried to do some error handling but got hung up with a named error handler macro not being in the Autoexec group. Thanks.

Thanks isladogs. Your suggestion in Post 6 is now what I'm trying to do.

From what I'm seeing, if the macro is a 'run code' macro, and if either 'macros are disabled' in the Trust Center Settings, or if 'macros are disabled' and the database is not in a trusted location, then the macro errors with '2001'. I have VBA code locked from viewing with a password.

Thanks to everybody for your inputs. To further explain what I want: The database is split into FE and BE. The BE contains a table that lists user-ids and their respective user-level. If the user is 'Admin' level, then opening either FE or BE should give them full ribbon menus and design...