Milewskp
asked on
Prevent Access Splash screen from appearing
Is there a way to prevent the standard Access splash screen from appearing wher you open a database?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
if not use this utility
http://www.jamiessoftware.tk/propeditor/pe_jump.html
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
ASKER
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?
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?
ASKER
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?
can you pleas answer this q
can you stop the Splash screen from opening if you hold the Shift while opening the db?
ASKER
Hi cap,
The answer is no, because the databases I distribute to my users have the bypass key disabled.
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?
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?
ASKER
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.
<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.?
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
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
ASKER
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
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
ASKER
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'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
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
ASKER
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!
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!
ASKER
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.
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.
ASKER
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?
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.
that is not the one you are after.
that is only for the startup form.
ASKER
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.
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.
unselect the splash screen form from the startup box