Prevent Access Splash screen from appearing

tools>startup

unselect the splash screen form from the startup box

actually it is the Display Form/Page box

This depends on what version you are using - if applicable capricorn1's method should work

can you stop the Splash screen from opening if you hold the Shift while opening the db?

if not use this utility

http://www.jamiessoftware.tk/propeditor/pe_jump.html

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

I would prefer not to use a separate file (my users might delete it). Is there any other way?

In case the answer is no, how do I go about creating a 1x1 bit map file?

I would prefer not to use a separate file (my users might delete it).   DELETE what?

My users might (accidentally or inadvertantly) delete the bmp file.

Milewskp,

can you pleas answer this q

can you stop the Splash screen from opening if you hold the Shift while opening the db?

Hi cap,
The answer is no, because the databases I distribute to my users have the bypass key disabled.

Milewskp,

you q
<Is there a way to prevent the standard Access splash screen from appearing wher you open a database?>

even if you have the  bypass key disabled, it can still be enabled.

is the question intended for the user?

Cap,
<even if you have the  bypass key disabled, it can still be enabled.>
I beleive in my case that it can't. You see, I run code in Autoexec that checks if the bypass key is enabled, adn if it is then it is disbled and the database automatcially closes.

well, good then.

so what is the intention of this q.?

Why do u want to stop this?

If u wanted to have a splash screen, u could just create your own via a startup form. Add a picture control which your own image (if embedded then there is no danger of being deleted)

simple way is to create a modal borderless form, which has a timer e.g. Me.TimerInterval = 3000   'secs
then when the timer func kicks in Form_Timer, u can open your mainform and close this splash screen

MS has a example if u want to try that  http://support.microsoft.com/kb/101374

and this is replacing about bmp http://databases.about.com/od/tutorials/l/aasplash.htm
I dont know if it will work if the file's attributes is readonly and hidden

When I create my own splash screen, the Access Splash screen flicks on for a brief instance before my splash screen.

Ok, u want a splash screen. You dont want to display the standard MS Access splash screen, u have the option to replace that but you are worried that the users may delete it

I just tried and tested this. I took the instructions from the last link I gave (databases.about.com)

I have a DB called and in                                               C:\EE\TestDB.MDB
I took a picture and saved it as a bitmap and called it      C:\EE\TestDB.BMP

I set the file attributes (right click, properties) of the bitmap to be READ ONLY and HIDDEN

I then started by DB and that image of mine appeared!!!
If your users do not have admin privileges, u could set the permissions so that they cannot delete (more work though and probably not worth it - if u see a image that u didnt setup then u know the users are messing around)

If u still wanted to keep your own splash screen from the form that u created, u can use the same image. There may be a flicker but at least the image is the same

Thanks rocki,
I'm sure that will work, what I'm sure you'll agree it wouldn't be worth the trouble. I was hoping for a simple way of turning off the standard Access splash screen from within Access.

I was involved in another post and this link was posted https://www.experts-exchange.com/questions/21999672/Splash-Screen-startup.html
Im wondering whether this might be of use - hide the main access window might get rid of splash screen
U can always disable it again
Might not look the part though

Hi rocki,
I had a look at that post. Yes, hiding the application until my splash screen loads might just do it. I'll give it a try and let you know. Thanks!

Hi rocki,
I tried that post. Yes, it works, but it's not very clean: when you open the databse file, you see the application window, then the Access splash screen, then they close down and you see my splash screen. What I was hoping for is that you woudl only see my splash screen.

Cap,
You suggested <unselect the splash screen form from the Display Form/Page box>. Where do I find this box and what version of Access is this for?

Milewskp,
that is not the one you are after.
that is only for the startup form.

It seems the best way to accomplish what I'm after is Raynard7's suggestion: create a 1x1-pixel BMP file. I tried this and it works great. The downside is that the solution is not neatly contained within the database file: you have to create a separate file and I was worried that my users may inadvertantly delete this file.

However I've since found a way to protect support files such as this (and the database file itself) by using Windows security: I put the database file and its support files in a protected folder. Only I can see and access the contents of the folder directly. Users access the database file via a special shortcut that I give them. Details can be found in Garry Robinson's book: Real World MS Access Database Protection and Security.

So full  points to Raynard7 for providing the best answer.