Search results

Hello all, I've got a question regarding indexing and database size. Does anyone know if the database size will differ if the table design includes indexed fields and the table is then loaded with data vs. the table design does not include indexed fields, is loaded and then indices are added...

Hello all, We're trying to build a new Access database with .dat data that is downloaded from a remote site. The problem is that there is too much data and the 2GB limit size on the database is being exceeded. Can I please get some recommendations on what to do? The data coming in cannot be...

I have a very large text file (644MB) that I need to import into a table. At some point in the process, I get an 'Out of Memory' condition. I'm using the '.Readline' command, placing each line read into an array, which is the used to as import data. The process works for text files that are...

Hello. We're using Access 365. I have an 'autoexec' function that, as soon as the database is opened, checks the user name against a user/password table in the database for security purposes. I just found a hole. If the user does not have macros enabled, the autoexex function errors/stops...

Recently, these files (ldb and laccdb) are not closing automatically when the user closes the database. These files are 0 bytes in length so there is no information in them about which computer has the database open. Also, there is no problem in deleting these files. I've eliminated...

Hello. Is there a way to solicit user input and use that input to create a table name in a query? For example, when the query asks for the parameter, the user enters for parameter 'year', "2021". The Access query then builds a table name as "Table " + year, resulting in a table name 'Table...

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

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

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.

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

I have an application that has a frontend Access database that contains some forms, and a backend Access database that contains tables which the forms update. In the backend, there is a 'user' table that lists user-ids and their security level, either 'admin' or 'user'. The frontend database...

I want to restrict users to only a form view when opening a database. There are several forms that the user may use. I can't figure out the VBA I should use to allow the user to choose a form name from the 'Select_Form' form and then open the form they selected. I've tried 'After Update'...

Is it possible to group sums based on the 3rd character within a value? For example, let's say I have a table T1 with fields F1 and F2 with values as this: F1, F2 2A1C, 30 2A2C, 15 2A1D, 20 2A1E, 10 2A2D, 5 Can you create a query that sums by the 3rd character in a field so that the...

Here's my problem and I need some help, please. Two tables, T1 and T2. Each has three fields, SID, PID and QTY. See my example below with various field values in SID and PID. T1: SID, PID, QTY s1,ps1,0 s1,p2,0 s2,p1,0 s2,p2,0 T2: SID, PID, QTY s1,p1,3 s1,p1,5 s1,p2,3 s1,p2,6 s2,p1,1...

I have a query that correctly 'Unions' unique values for two fields from 6 tables. How can I insert those two unique fields into another table? This is what I've tried which gives me an error (action query cannot be used as row source): SELECT F1, F2 into myTb FROM (SELECT F1, F2 FROM T1...

I have multiple table with same design: e.g., tab1: PID, SID, QTY tab2: PID, SID, QTY I have another table with design: grpTab: PID, SID, QTY1, QTY2, QTY3 How can I update: grpTab.QTY1 FROM tab1.QTY where tab1.PID = PID and tab1.SID = SID grpTab.QTY2 FROM tab2.QTY where tab2.PID =...

I have three identically designed tables. I do not want to combine rows with a Union or Union All. What is the query that would give me the distinct pairings of field1 and field2 for all three tables? Thanks for your help.

I'm new to 'union' queries and need some help, please, with creating queries that span tables. I have six tables. The first four, call them 'Sales_Master', have identical structure with these fields: Sales-ID, Product_ID, Quantity, and MMYYYY. Each of these tables represents a month's worth...

Hello again. Looking for great advice that I always get on this forum. I'm working on a new application that tracks sales. Let's say the application has these characteristics: There are 800,000 salespersons each with unique ID (I). The number of product groups being sold...

Ran into a problem and need some help. I know it can be done but am having trouble finding VBA code that changes the path to an input file for a Saved Import Spec. I'm not familiar with XML but I believe there's a way to modify it with VBA. Many thanks for any help.