473,408 Members | 2,477 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

Database Option Keeps Resetting in Access 2007

When I check the "Check for truncated number fields" to disable it, it works for a while but it eventually resets itself to "True"

I haven't been able to determine just when it gets reset.'

Any ideas?

Regards,
John
Sep 24 '12 #1
3 1431
zmbd
5,501 Expert Mod 4TB
Been searching the knowledge base, nothing like this has been reported.
You can set/get the option states in vba, this might be worth a read http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
Sep 25 '12 #2
Hello,

Thank you for your response. It started me thinking (not always a good idea).

I upgraded from 2003 to 2007 and did not change my database to "accdb" - I kept it as a "mdb".

I saved it as "accdb". Problem solved.

Thanks again.
John
Sep 26 '12 #3
zmbd
5,501 Expert Mod 4TB
Glad that fixed it. We skipped 2007 and the more I read about bugs like this the happier I am... I've several mdb that run just peachy in 2010.... thinking we should skip 2013 and Win8 too!
Sep 26 '12 #4

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

Similar topics

5
by: Ira Solomon | last post by:
Hi: Any quick opinions on Access 2007? Has anyone got this to coexist with Access 2003? Thanks Ira
8
by: jdvon | last post by:
I have downloaded a neat MS Access 2007 template which has some extra functionalities. The "save as" option in MS Access 2007 for saving as 2002 format generates a message saying the file cannot be...
4
by: mrouleau | last post by:
I am sorry if this is the wrong group to ask, if so please point me in the correct direction. My problem is I have an MDB file with user-level security on it (mdw). When i move it over to a...
17
by: Neil | last post by:
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many...
5
by: ISUTri | last post by:
We are currently converting from Access 2003 to Access 2007. I have an Access app that is going to be very difficult to convert. This App is used by people that are out in the field and are a...
0
by: Wayne | last post by:
I've noticed on many different machines that when a database is opened in Access 2007, when the blue Access background screen first appears a thick, broken, blocky diagonal line flashes across the...
1
by: fifothekid | last post by:
Hi everybody, I made a primitive cost control database system using Microsoft Access 2007 as a front-end (don't ask my why did I use Microsoft Access!!!) and SQL Server 2005 Enterprise as a back-end...
7
by: Icarus | last post by:
I have a Access 2000 database that I am opening with Access 2007. When I open the datbase in Access 2000 or Access 2003, the database runs as expected. In Access 2007 my main form opens, a...
1
by: ncsthbell | last post by:
I created a database using full blown access 2007. I have put it out for users to grab and test using Runtime Access 2007. They have entered data and now I need to go back into a table and change a...
0
by: john garvey | last post by:
I have a small web site running on Windows 7 with IIS7 it is written in classic ASP with an ActiveX dll that connects to and extracts/ writes/ deletes data from the database. The database is an accdb...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
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,...
0
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...
0
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...
0
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,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.