Search results

No. Front end DB on shared network drive.

Yes. The first thing that the autoexec macro does is: "If [CurrentProject].[IsTrusted]=False" Then MessageBox 'Tell user macros are probably disabled' RunMenuCommand "CloseDatabase". If autoexec passes this test, then the security VBA function is executed.

Figured it out. I added an 'Autoexec' macro ahead of the security function. The Autoexec macro checks If [CurrentProject].[IsTrusted]=False. If it is, which will be the case if macros are not enabled, the database is immediately closed without running the security function.

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

I don't see EFFECTIVE PERMISSIONS within Security. I have Permissions for System, Allow, Deny. Everything under Allow is checked. Within Advanced, under Permission entries, everything under Access is Full Control. This is for the test folder and test database.ldb that I created. I'm pretty...

Thanks, I've contacted the network people and they are searching to see if any changes were made to environment. But, as I stated, these ldb files are 0 bytes and are easily deleted. Also, I created a new database in a new folder and the problem still occurs.

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

Thanks to all of you who helped. This is the best forum!!!

A bit kludgy but I could create say 10 empty tables, same design as production table, on the archive database. I think the archive db can hold about 10 years worth of records. I'll name these tables Archive2021, Archive202, etc. On the production db, I'll set up a select/append query that...

Got it. Thanks. This is without VBA, right?

Yes, the production database contains tables that are linked to tables in the archive database.

"the database should know which records go into which archive" - please explain. If a record has field value 202101 (Jan 2021), what name would the archive table have to have? I can rename the archive tables to whatever I want.

Thanks to all.

1.8 GB 4.5 mil records that go back several years.

Thanks for all the suggestions. No one is going to pay to redesign the database. It's been in use for years and serving its purpose. So, can I please get an answer to my original question. Can I form a query that creates a table name from user input and use that table name to update a table...

Access DB max size 2GB!!!

I'd like to give the user an easy way to archive records. Records are added in bulk on a monthly basis to a production database. One of the fields in the record is 'Year_Month' (format yyyymm). When the user wants to archive last year's records, the query is executed. It asks the user for the...

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

This works: 'S:\Clients\Test\Production Database\Reports Database (Rel 11-08-20).accdb' This does not: 'S:\Clients\Test\Production Database\Reports Database (Rel. 11-08-20).accdb' Removing the period after 'Rel' fixes the Invalid Bracketing error. We could change the names of all of the...

Thanks. Found the problem. The database name has an embedded period (.) as in dbname Rel. 10-1-10.accdb Any workaround other than renaming all the databases?