473,836 Members | 1,486 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Is It possible to set Access Startup Options using VBA?

twinnyfo
3,653 Recognized Expert Moderator Specialist
I am using MS Access 2007.

I have a database that I do all my editing and programming in and have certain Access options (under the Current Database tab) set one way during the editing. However, when I compile the database into the .accde file, I reopen the database and set certain options, such as the initial display form and navigation pane options. I keep these enabled during programming for ease of use, but disable them whem compiled to prevent others from possibly using them (or at least making it more difficult).

Is it possible to use VBA to set these options to automate this process after the compile? I already have code re-mapping all my linked tables and modifying/deleting unused Switchboard items.

Does anyone have any experience with this?Thanks!
Dec 7 '11
13 14674
ADezii
8,834 Recognized Expert Expert
Nice adaptation, NeoPa.
Dec 8 '11 #11
NeoPa
32,584 Recognized Expert Moderator MVP
Thank you ADezii. My aim was not as limited as simply answering this thread (although that was certainly the starting point). I saw this was something that could be more generally helpful (to me as well as others) with just a little more meat on the bones. I expect this module to be available for my use in all future projects.
Dec 8 '11 #12
NeoPa
32,584 Recognized Expert Moderator MVP
I'm so glad I found this again. It made creating just such a module again so much easier :-D
Nov 3 '13 #13
NeoPa
32,584 Recognized Expert Moderator MVP
A hijack question has now been moved to a new thread called Set Application Title using VBA.

Please do not post new questions in existing threads.
Apr 13 '19 #14

Sign in to post your reply or Sign up for a free account.

Similar topics

13
15181
by: Sateesh | last post by:
Hi, Is it possible to access Lotus notes using Python? Can anyone provide me some pointers? Thanks Sateesh
2
3190
by: TechBoy | last post by:
Hello. Re: Access 2002-SP3 I have some options turned off under "Tools/Startup" area on my workstation. When I deploy my app to 5 users (who will all have a full blown version of Access 2002 on their PC's) I would like to disable some startup options programatically at runtime via VBA. I am looking for VBA code to turn off these options at application startup and turn them back on for the user when they shutdown my app:
3
1782
by: stueyh | last post by:
When attempting to connect to an Access 2000 DB using ADO.Net from within ASP.Net running under an impersonated local user account receiving the following error. ERROR Disk or network error. ERROR Driver's SQLSetConnectAttr failed ERROR Disk or network error Oracle ODBC connection works fine under the same user so assuming this is something to do with either Access specific registry permissions, or NTFS
4
1938
by: silverburgh.meryl | last post by:
I am currently access this newsgroup thru Google group web interface. Is it possible to access this newsgroup using Thunderbird? Thank you.
3
1628
by: Gerrit Snel | last post by:
We have a question but we're in doubt if it's even possible or not. The question is as follows: Is it possible to access a form using a string literal, and if so yes? We want to use something like this (don't mind the syntax as it obviously doesn't work): Form("Form1") frm = ("Form1")GetForm("Form1");
1
2683
by: Andy | last post by:
Hi, I was wondering if someone could advise on if the following is possible. I have one website that is available to the public using Forms authentication and the Membership class, it creates/stores user information in a SQL Server 2005 db. I have another website that will administer the first website, allowing admins to look at all of the users in the db and see specific info from the database.The admin site is more secure than the...
2
4555
by: pratcp | last post by:
I have a remote server (a shared hosting webserver) where I have few users ftp some flat files. I need to access these files using a windows app/windows service written using c# and run it on a nightly basis. How do I access the remote server in a c# windows service or console app? The reason I need remote access is that I cannot have any type of schedule jobs running on a shared hosting webserver. I was contemplating on using SSIS sql...
2
1607
by: DebbyS | last post by:
Hi there, I am currently in the situation where I have a database secured with startup options and passwords, but need to edit the startup options from time to time.(These have been hidden). There is an article on MSDN about creating a form within a database to control these options - can anyone help.The Property Editor does not work as I have user accounts and groups and I cannot afford to go without them. I am not going to buy the entire...
4
44119
JodiPhillips
by: JodiPhillips | last post by:
MS Access2000 Hi everyone, I've searched the forums for an answer to this question and nothing jumps out at me. When a database is opened I want to automatically run code (at start-up) that compares the path of the opened database to a specific path (where the original database is located). This is for security reasons - I need to know if the original database has been copied without authorisation. Due to network issues I cannot use...
8
3551
by: Bhuwan Bhaskar | last post by:
Hi, Can we access database (SQL) using AJAX ? Thanks, Bhuwan
0
10834
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10541
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10584
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10248
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9367
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5817
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4446
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4006
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3108
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.