473,320 Members | 2,111 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,320 software developers and data experts.

Help Needed With Corruption Problem

WJA
I have a database that has a "settings" form that is always open and
hidden unless an "Admin" user chooses to view it. The form is bound to
a "settings" table that has one record and several fields related to
the settings on the form. I use the info on the "settings" form to set
the way that other forms behave when they are opened.

The database has a handful of users and the "settings" table is being
corrupted on a regular basis. I have narrowed the problem down to one
user but so far the IT department is unable to pinpoint a problem with
their PC or network connection.

My question is: is it bad practice to have a bound form open at all
times and am I asking for trouble by doing this?

Any help is appreciated.

Nov 13 '05 #1
3 1173
MLH
Is there any way at all you could read your table values during the
autoexec sequence, assign them to global variables then close the
form? Because if you could, then you could perform a test that may
lead you to the answer to your question.

Next question: Is the data in the table STATIC? Or, while the bound
form is open, are users writing new values to the table?

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx
On 14 Sep 2005 14:15:47 -0700, "WJA" <WJ****@hotmail.com> wrote:
I have a database that has a "settings" form that is always open and
hidden unless an "Admin" user chooses to view it. The form is bound to
a "settings" table that has one record and several fields related to
the settings on the form. I use the info on the "settings" form to set
the way that other forms behave when they are opened.

The database has a handful of users and the "settings" table is being
corrupted on a regular basis. I have narrowed the problem down to one
user but so far the IT department is unable to pinpoint a problem with
their PC or network connection.

My question is: is it bad practice to have a bound form open at all
times and am I asking for trouble by doing this?

Any help is appreciated.


Nov 13 '05 #2
Why not write user preferences to the registry. You could use the table
to supply the initial default values, but it's simple to save user options
with the SaveSetting and retrieve them with the GetSetting calls.

Note: gcstr_Client is a global variable with my app name.

SaveSetting gcstr_Client, "Attributes", "AccessLogin", pstrSUser
SaveSetting gcstr_Client, "Attributes", "AccessLevel", bytBLevel
SaveSetting gcstr_Client, "Attributes", "Tip of Day", lngX
SaveSetting gcstr_AppName, "Options", "Startup Form", Me.fraStartupForm

lngX = GetSetting(gcstr_Client, "Attributes", "Tip of Day", -1)
Me.chkLinkLocal = GetSetting(gcstr_AppName, "Last Values", "Link Local", -1)
lngStartup = GetSetting(gcstr_AppName, "Options", "Startup Form", 1)

As for having the bound form open, I'm not aware of a problem with that.
In fact, keeping a table open in Access 2000 speeds up access, as the user
maintains a foot-hold on the ldb file.

However, if every user has it open and is making changes to the table, that
might cause a problem.
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast/

"WJA" <WJ****@hotmail.com> wrote
I have a database that has a "settings" form that is always open and
hidden unless an "Admin" user chooses to view it. The form is bound to
a "settings" table that has one record and several fields related to
the settings on the form. I use the info on the "settings" form to set
the way that other forms behave when they are opened.

The database has a handful of users and the "settings" table is being
corrupted on a regular basis. I have narrowed the problem down to one
user but so far the IT department is unable to pinpoint a problem with
their PC or network connection.

My question is: is it bad practice to have a bound form open at all
times and am I asking for trouble by doing this?

Any help is appreciated.

Nov 13 '05 #3
WJA
Thanks for the feedback. The data in the table is static. It has one
record comprised of 8 fields and the data is very rarely if ever
changed. I thought that having it open all the time would make it a
target for corruption if there is a suspect network connection etc.
None of the main data tables are getting corrupted (fortunately) just
this small "settings" table.

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Richard Gabriel | last post by:
Hi everyone, Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about twice per week (with about 500 queries per second average). I have even...
4
by: Morgan Leppink | last post by:
Hey all - We are running SQL 2000 with ALL available service packs, etc. applied. We just built a brand new database server, which has dual 2Ghz XEONs, 2GB memory, and the following disk...
13
by: PamelaDV | last post by:
I have a database split for back end and front end and my back end (my data) has been corrupting like crazy lately. Today we have compacted and repaired like 4 times within an hour. The database...
10
by: Arno R | last post by:
Hi all Yesterday I found a strange corruption-issue that I can't solve yet or actually point my finger at. I converted an A97 app to A2k. I have done this often enough so I didn't expect trouble...
21
by: Dan | last post by:
Hi, just ran into my first instance of a backend Access97 database not compacting. I'm getting the "MSACCESS.EXE has generated errors.." message on compact. I've narrowed it down to the largest...
2
by: Jennifer B. | last post by:
Hi Every Body: I hope this is to the right post. I apologize if I am incorrect. Could anyone please answer one or any of the following questions for Access 2003: - Maximum size of an...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
6
by: Jax | last post by:
I have Visual Studio 2002 Standard Edition. It has been working fine up to a point and now i'm at that point. Due to the limitations of the edition i am not using any of my own .dll's and instead...
23
by: Dave G | last post by:
Since upgrading one of my clients from A97/W2000 to A2003/XP they have suffered no end of data corruption problems, mainly involving one of the main tables. The corruption can result in one...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.