Sudden Appearance of errors 3048 and 3704

Question

Sudden Appearance of errors 3048 and 3704

John Waldruff 11

I am running an Access application under Windows 11. Everything has been working fine as late as last week. This week, when I attempt to execute some VBA code, I get error 3048 ("Cannot open any more databases" from the command "set db= CurrentDB") and then when I attempt to exit, 3704 (You attempted to open a database that is already opened by user on machine). Furthermore, when it finally exits, the Access app is still loaded as you can see in Task Manager. I have to manually "End Task" to get it to close out. The same app and database set work fine on my Windows 10 machine. I fear Microsoft did something to the registry to foul things up. In attempt to get back to normal I have reloaded Office, manually downloaded latest Windows update, and downloaded all optional updates (with associated re-boots). Any ideas?

cf 51 Reputation points

2022-02-03T10:29:07.66+00:00

I just want to comment here and say that we seem to be experiencing the same issue. It has only been happening since today. Using the same Access file, there were no issues previously.
Chris Davis 1 Reputation point

2022-02-05T06:28:21.427+00:00

Same here.
ToCo Admin 1 Reputation point

2022-02-10T03:06:13.323+00:00

same here
Isabella Garcia 1 Reputation point

2022-08-25T04:37:18.503+00:00

Runtime errors 3048 and 3704 occur when Microsoft Access fails or crashes. Let’s talk about Error 3048, This occurs due to virus infection, it can be credited as a symptom for runtime error. While Error 3704 occurs when you attempted to open a database that is already opened by user '2' on machine '1'. So, these may be possible reasons for the sudden appearance of runtime errors 3704 and 3048.

Repair Methods:

Close/Update and Re-install the conflicting programs

You need to observe if the error message occurs each time you stop a process. Once you get to identify which program is causing the error, you may go ahead and check your database if still occurring the error then go for the next troubleshooting step.

Update the Virus Protection Program in your system

Update the virus program and run a thorough scan of the computer or run a Windows update so you can get the latest virus definition and fix.

Run Disk-Cleanup

Open your explorer window and right-click to your main directory, click Properties and then click Disk Cleanup.

Download and Install the latest windows update

If still the error persists then you can try the compact and repair database utility.

https://support.microsoft.com/en-us/office/compact-and-repair-a-database-6ee60f16-aed0-40ac-bf22-85fa9f4005b2

Best Regards,

Isabella

3 answers

Your answer

cf 51 Reputation points

2022-02-03T10:29:07.66+00:00

I just want to comment here and say that we seem to be experiencing the same issue. It has only been happening since today. Using the same Access file, there were no issues previously.
Chris Davis 1 Reputation point

2022-02-05T06:28:21.427+00:00

Same here.
ToCo Admin 1 Reputation point

2022-02-10T03:06:13.323+00:00

same here
Isabella Garcia 1 Reputation point

2022-08-25T04:37:18.503+00:00

Runtime errors 3048 and 3704 occur when Microsoft Access fails or crashes. Let’s talk about Error 3048, This occurs due to virus infection, it can be credited as a symptom for runtime error. While Error 3704 occurs when you attempted to open a database that is already opened by user '2' on machine '1'. So, these may be possible reasons for the sudden appearance of runtime errors 3704 and 3048.

Repair Methods:

Close/Update and Re-install the conflicting programs

You need to observe if the error message occurs each time you stop a process. Once you get to identify which program is causing the error, you may go ahead and check your database if still occurring the error then go for the next troubleshooting step.

Update the Virus Protection Program in your system

Update the virus program and run a thorough scan of the computer or run a Windows update so you can get the latest virus definition and fix.

Run Disk-Cleanup

Open your explorer window and right-click to your main directory, click Properties and then click Disk Cleanup.

Download and Install the latest windows update

If still the error persists then you can try the compact and repair database utility.

https://support.microsoft.com/en-us/office/compact-and-repair-a-database-6ee60f16-aed0-40ac-bf22-85fa9f4005b2

Best Regards,

Isabella

Answer 1

Karl Donaubauer 2,061 MVP

Hi,

It is an update bug in the latest build of M365. See my reply in a similar thread of the TechCommunity forum.

Servus
Karl

Access News
Access DevCon

Answer 2

The answer is very very simple:

You have a lot of code in your database, so it is quite a job to compact the database
You have checked the box 'compact on close' in 'options/current database'
if so: uncheck the box, and only compact manually

solved. Please confirm if this also did the trick for you. Took me a lot of trials and errors to finally find the most logic solution: you close the database, and immediately access tries to compect it, while it is still open, somehow they changed the "compact" procedure to before the complete closure of the database.

It only started appearing somewhere in 2023 for me.

Answer 3

Tanay Prasad 2,250

Hi,

There can be several factors for this issue. Here are a few suggestions from my side-

Try Compacting and Repairing your access database.
Temporarily disable any antivirus that might be interfering with MS Access.
Make sure that your machine has sufficient resources like RAM, available to run Access and other applications.

If these methods do not work out for you, go through this blog on how to fix error 3048 in ms access.

Best Regards.

Tanay Prasad 2,250 Reputation points

2023-06-27T06:16:24.53+00:00

Ignore comment.

Share via

Sudden Appearance of errors 3048 and 3704

3 answers

Your answer