Recent content by HelpMe:)

I have fixed the issue! I imported the txt. file to a new table and saved the import Put in a macro to import the saved import and quit the database Then created a .bat file to run the macro and put this in Task scheduler to run once a day at 7am. Linked the Front end to the table in the back...

It is just a Macro button at the moment, attached screenshot.

At the moment the form is opened from a navigation menu and the user can then click the search button and type in what they are looking for e.g an asset number or serial. There are buttons to add a new record and filter by a specific department as well.

Thank you isladogs, that is what i thought but i'm not sure how to set it up.

Hello :) I have built a database with the back end being on SQL Server Express and the front end on Access. The issue i have before deploying is that when we search for a record it seems to take a minute or crashes. Is there a way to resolve this? This is my first SQL database so no doubt...

Yes this seems to be the case although id say 3 of us can be using the form at the same time before it gets the issue

Hi Eshai, the data imports from an SCCM report each morning into an Excel CSV file which is linked to the database.

Hi Micron, Yes each user has a copy of the FE on their desktop and i have checked the settings in all instances are set to the shared options

Hello :) I have a Split AccessDB with various forms and a navigation form which opens each area. The database is shared between 12 people. It works fine when a few people are using it however it seems to have a limit and we then cant get into 1 of the 11 forms. The error is: "The Micorsoft...