VBA to stop Access asking to Save!

[Neilster]

Hi Guys

When I copy Access into a new PC location it always asks to be 'saved' when you first open it up which is a pain because if you don't then it opens the DB but locks all editing.

Is there a way of disabling this????

Many thanks.

 

[CJ_London]

nope - it is a security feature. Best option is to ensure the new location has already been set as a trusted location for access before the code runs. (and you can only do this from access or run some code in another app to update the registry)

You get the same issue with excel and word if they have macros

note that trusted locations are specific to the application - so a location trusted in excel is not trusted be default in access or word.

You can get your users to accept a whole swathe of folders as trusted e.g. their user profile to include desktop and documents but it is not recommended

 

[sneuberg]

I don't get that on my system. I get a security warning and prompt to enable content (see attached screen shot). Is this what you mean? If that's what you want to avoid you can make the folders you are copying to trusted locations. Click on FILE, Options, Trust Center, Trusted Locations and then Add new location. Note the check box "Subfolders of this location are also trusted". You probably want to check that.

If that not what you are talking about what operating system are you using?

 

[Neilster]

Hi guys,

Thanks for getting back with your response. It seems if you install it to documents then yes it just ask to enable. When you save it to program files it asks to be enables & saved which when you do and save it the same place as you've installed it, you can't save it because a user is already using an open version of what your trying to save.??????

Like you say CJ it's a securety thing???

 

[CJ_London]

you can't save it because a user is already using an open version of what your trying to save.??????

That applies to any file so not access specific

I'm beginning to suspect you do not have access set up correctly. You should have a front end (FE) and a backend (BE).

The BE just contains tables (or indeed may be SQL server or another db system other than the one provided by Access). The FE contains all forms, reports, queries and code plus links to the BE tables.

In a multi user environment, the BE should be located on the network somewhere where all users have read/write access

Each user should have their own copy of the FE and located on the local machine