Single User Mode
Oct 14, 2014I trying to set my access database as a single user mode.(If i using the Mdb , other user cant use the same mdb by showing some warning msg and close ).
View Replies
ADVERTISEMENT
Probability Of MDB Corruption In Single-user Mode
Aug 28, 2005Greetings everyone :)
I hope this hasn't been addressed too many times before, I searched for 'corruption' but there were so many results that I could only parse the first few pages.
Anyway, I'm developing a C# app for personal use and I was planning on using some MS Access functionality, namely saving and loading data from MDB files. Unfortunately, I've heard a lot of scary stuff regarding Access's tendency to corrupt MDB files. This is really bad news, as I really can't afford to lose any data - information is fed into the application daily, even hourly, and the data isn't stored anywhere else.
I could - and will - add some code to back up MDB files on every access, but I'm still curious. Given the circumstances listed below, how likely is Access to corrupt a MDB from time to time ?
- I am the sole user of the database. It is never, ever, accessed by more than one user at the same time. There is no networking involved whatsoever.
- The database contains only tables and maybe some forms. There are no constraints, stored queries, or any advanced features like that. The forms are never actually used by the program, they're just there to help in editing the database 'manually' should the need arise.
- The tables contain only basic data, i.e. INTs, VARCHARs and DATETIMEs. No memos, images or any such stuff.
- The database engine / system will not crash in the middle of a writing operation, or if it does, there will be a certified backup available.
- There are only two possible operations that the program can perform on the database: either a bulk read on each table, or a complete replacement of all of the records in all tables. There are no selective insertions or deletions.
What I want to avoid most is a 'silent' corruption, i.e. Access reports having saved the table successfully, but it has actually corrupted some records. It's not a problem to keep a backup for the duration of a writing operation (to cover the case in which the engine crashes during writing), but if I need to keep it for anything longer than that, the situation becomes rather cumbersome.
Well, thanks in advance for any replies :)
Performance Penalty Of Supporting End-user Debugging/verbose Mode?
Dec 8, 2007For those who work with *nix programs, you can specify -v to get program to tell you more about what it is doing while it's processing which can be useful for end users trying to figure out possible causes for failures/errors/unexpected results. We both already know that there *will* be a performance hit if we were to leave debugging code, so that's not the question. The question is how much performance hit will a VBA module suffer if it has to check whether it should be verbose or not. Suppose we have a complex set of procedures where several routines will be called or maybe several events may occur, so logically, every routine would need to check whether the user has asked for verbosity or not. So,Private Verbose As BooleanPrivate Sub1Do AIf Verbose Then Msgbox "A worked!"End IfDo BIf Verbose Then Msgbox "B worked!"End IfEnd SubPrivate Sub2Do CIf Verbose Then MsgBox "C worked!"End IfEnd SubThat's a lot of If statements, and assuming every routine was executed, that means the VBA had to test for condition Verbose three times for single iteration.Is there any way to reduce the number of checks and hopefully have a final product that performs just as fast with verbose mode off than one without such mode at all?
View 3 Replies View RelatedForms :: Subform Shows In Design Mode But Not In Form Mode?
Sep 22, 2014I have several subform tabs and one that I have updated no longer shows up when I run the form on Form mode. The tab is there but no content or details of the subform
View 3 Replies View RelatedSingle-user To Multi-users
Jan 7, 2004Hi,
I have a database originally was created for 1 person to use. Now, this database has to be shared by various people in the company over a network. Some are only allowed to view reports while others are allowed to make changes to it. How can I convert this database to a multi-users one, and maintaining its data integrity? I can possibly restrict 1 person to use the database at any one time. I know it's not going to be easy, but with the help of you guys I am sure it can be done.
Single User Exlusive Table Access Problem Example
Jul 5, 2006ok
there is one table..
job
there are two forms
1. main menu
2. add job
on the main menu i used the button wizard to create a button to open the add job form.
this is where the problem lies..
i also have one query called tdayandtomorrowjobs. this query displays jobs from the job table where the date is today or tomorrow.
i wanted to display the results of this query on the mainmenu form, so i placed a listbox on the mainmenu and set the recordsource of the listbox as the tdayandtomorrowjobs query.
now on my main menu, the results from the query display, but i cant add a job (the add job form button doesnt work..) because the database thinks the job table is already open in the listbox..
how can i solve this problem.. please see the attached database.. it is very straightforward. and contains only the above mentioned elements.
please please someone help me resolve this simple issue. http://bb.1asphost.com/antonyx6/forumdb.mdb
Modules & VBA :: Storing A Single Record In A Single Dimension Array?
Sep 8, 2014Any Single line of code available?
View 2 Replies View RelatedModules & VBA :: Sending A Single Email To A Single Record In A Query
May 15, 2014I am trying to create a form with a button attached to each record that would allow the user to click the button and it would automatically open outlook and fill in the TO:, SUBJECT: and BODY: fields. Here is the code that I currently have:
Code:
Private Sub Command33_Click()
Dim strEmail As String
Dim strMsg As String
Dim oLook As Object
Dim oMail As Object
Set oLook = CreateObject("Outlook.Application")
Set oMail = oLook.CreateItem(0)
[code]...
There are two issues I keep running into:
1. This code opens outlook and populates all of the fields but pastes the email incorrectly. Instead of pasting just the email (email@email.com) it pastes the html tags as well (email@email.com#mailto:email@email.com#) which means that the user would have to delete everything between the #'s in order to send the email every time.
2. I currently have the email BODY pulling from a table but this obviously limits what I can do. I would like to simply encode the BODY within the VBA code. The setup I am looking for is:
one paragraph
a blank line
a hyperlink to a website
a blank line
another paragraph
Max Value For A Single Date/multiple Time/single Tag ID Combination
Oct 18, 2007Hi, thanks in advance for any help you can offer. I've got a table that has
Date
Time
Tag ID
Power Level
throughout the day a computer listens to several tags (transmitters) and records the power level of the signal generated by the tag each 3 seconds. What I'd like to do is build a query that gives the Date, Time and Maximum Power level reading for each tag ID. I only want 1 record per tag per day
I've tried using "group by" and max in the query but this gives me all the times throughout the day.
anyway, thanks again for looking
cheers, Shaun
Safe Mode
Nov 30, 2006Hello all,
Has anybody ever encountered this before. I can't seem to get rid of it.
When logging in to my Acc 2003 db I get a message along the lines of...
"Access failed to start correctly last time. Starting access in safe mode will help isolate a startup problem. Do you want to open in Safe Mode?"
When selecting No, it allows me in as normal.
This happens everytime I log in now. Even when choosing Yes then exiting the db.
Anybody know where to start looking for the solution?
Thanks
Kempes
Mean Mode Help Required
Nov 14, 2007Hi,
I found a couple of short threads on the forum discussing the above. None of them go sufficiently far enough into detal to help me solve my (relatively simple) problem.
My boss has asked me to produce both mean and mode calculations for the number of pallets we ship to our branches on the 30+ routes that we service.
So far I have managed to implement mean but mode seems to have me stumped.
I'm aware there actually isn't a mode function in Access as such but like mode, is there a way to calculate the most frequent occurrence of a number over a time period?
My query is already producing Min, Max, Sum (and now mean) results for the pallets we ship, can someone offer me help on this?
All the code that I have retrieved so far seems to be based on something similar to this:
select top 1 with ties your_column
from your_table
group by your_column
order by count(*) desc
I have very little to no idea about how to implement this into my query. Any help would be appreciated.
Thanks In Advance.
sausagefingers
Average, Mean, And Mode
Aug 24, 2007Hi guys,
I know I can average data in Access, but is there a way to do mean and mode? As always, thanks all...
Caliboi
Sub Works Only In Step Mode
May 12, 2005It's been a while since I've been on the boards. Good to see lots of the same folks are still here. :D
I've got an interesting problem. I have a sub that calls another sub. Pretty simple there. The problem is that when sub A calls sub B, sub B does not appear to run. This is all sub B does:If Not IsNull(Me.txtNumber) Then
Me.txtNumber = Me.txtNumber + 1
End If
The weird thing is, sub B runs just fine if I run the sub B in step mode. If I set a break point and use F8 to step through the code line-by-line, it runs just fine. If I take out the breakpoint, the code no longer works.
Anybody have any ideas? I'm running Access XP Sp2 on Windows XP SP1. Thanks.
Msg Box On Close Only If In Edit Mode
Sep 7, 2006I have a form that is locked unless they click the command button to edit records. I want a msg box that when they click the close button it pops up with something like save edits? Just as an extra precaution. But I only want the message box to pop up if the form is in edit mode. Is this possible? And I would like to be able to have them click ok or cancel in the message box
Here is the code for the close button:
Private Sub Close_Click()
On Error GoTo Err_Close_Click
DoCmd.Close
Exit_Close_Click:
Exit Sub
Err_Close_Click:
MsgBox Err.Description
Resume Exit_Close_Click
End Sub
Thanks
Tracy
Openning A Form In Add Mode
Oct 6, 2006Hi All,
This is such a newbie question I realise, but I have a form (frmFOBEntry) with a combobox (cboMarketCode) which returns a list from tblMarketCode.
New records are added to tblMarketCode using a form frmMarketCode
When I look through the combobox on the first form if the MarketCode I want is not there I want to be able to click a button which will open frmMarketCode in add mode.
Have looked through the forum and found all manner of flash ways to open on to certain records and the like, but nothing that simply opens the form so you can add a new record.
Also, if I add a record will the combobox update automatically?
Many thanks
Toggling Design Mode On / Off
Sep 1, 2015I have an old db. I would like to see the forms and tables so I can select them and make changes. I know there is a way to access those items on startup but I have forgotten how. When I bring up the db I see a form and I can get into VB for that form but I cannot see any embedded table, forms reports, etc.
View 3 Replies View RelatedDatabase Opens In Exclusive Mode Over LAN
Nov 14, 2005I have a database which seems to open many copies when it is accessed over the internet (via ASP) but If I open it on my compter over my LAN then it seems to open 'exclusive' and those on the Internet get the error message that 'file is already in use'.
Is there a way of opening the database over the LAN and allowing the Internet to see it?
Linked Table In Non-exlusive Mode
Oct 12, 2006We have a networked database (using ACCESS 2003) containing:
two tables: 1 mdb table (Table A), and 1 linked table to an Excel worksheet.
the excel worksheet is set to be SHARED
FormA : uses Table A, and the linked table is used in a subform
SITUATION : Everything is Ok, if only 1 user opens FormA.
If a second user tries to use FormA, an error occurrs that the linked table is already being used and is in exclusive mode. The form will open but the Subform opens empty.
QUESTION : What needs to be done in order for the linked table to open in 'Non-exclusive' mode?
I'm a newbie to ACCESS, so any help will be greately appreciated.
Joel
Default Add Mode On Current Form
Apr 19, 2005I've created a form with Record Navigator which allows a user to create a new record. When the form is opened how do I immediately put the user into add mode by default?
Thanks
Maximized Form Changes To Restore Mode
Sep 12, 2005:confused:
I have a db app that has all forms maximized continually (I have set the vba code to do so on Open, Close and GotFocus events). From my app Home Page form the user can browse to other forms in the db. When another form is opened the window automaically maximizes. However, when the user navigates back to the Home Page it goes in restore mode. I haven't told it to do this anywhere. I have also tried saving the form stretched out to fit the full screen, so that if it goes into restore mode it at least still fills the screen, but it still reverts to a restored window (about half the screen). It doesn't matter what configuration I use in the AutoResize, AutoCenter properties either.
I have been developing custom db apps in Access for over 8 years. However, this seems to be a stupid (albeit simple) problem that is annoying me. I currently use Access 2003 and this issue is new (or so I believe since I never ran into the problem in previous versions).
Any ideas?
Thanks...
Form Mode In Switchboard Question
Dec 1, 2005Have a question on the switchboard choices I've always wondered about. Why are there only "Add" and "Edit" modes to open a form from the switchboard? I see many, many times when you want to allow a form to be opened in "readonly" mode to page through records but not allow edits or additions. Why does Access NOT have "Readonly" as an option?
View 2 Replies View RelatedLaunching A Form In Datasheet Mode
Jun 10, 2006I have a form designed in DS mode. If I open it directly (double click on it on the Panel), it works fine
When opening it programmatically (from a button in another form) it shows just ONE record, in spite of having room enough for several records.
May I get some help to check what am I doing wrong?
thanks
How Do I Change Data In Property Mode
Nov 11, 2004I have created a form in access 2000. I now want to change the table that this form uses. Normally I would just click the properties tab and then select data, a list of all tables would come up and I would choose the correct table. For some reason I cannot access the data tab. The other four tabs are all availabe, but not the data tab. It is like the data is locked or something. I have clicked on properties on my desktop icon and it is not locked. Please help.
Photoone
Link Two Forms Together On One Field In Add Mode
Jan 17, 2006Hello!
I Have a
project form
test form
sample form
for 1 project there are n tests and for 1 test there are n samples.
The project form is alone and has a button to open the related tests in the test form. The test form incorporates the sample form as a subform.
What works:
For entries already in the database when I click the related tests button on the project form it opens the test form filtered in the correct manner.
For the test form the sample form displays and increments correctly.
What doesn't work:
When I open the project form in add mode I fill in the data and when it is done I click the related tests button and the linked/child field isn't there! No data, I can't get it to work...
Can you suggest something?
PS I cannot find anywhere in the Data properties the Linked field properties... neither child nor parent?
Queries :: How To Calculate Mode Value In Query
Feb 5, 2015Is there a way to calculate the mode value in a query?
In a summary query, I need to return the value that shows up the greatest number of times in a certain column of a table. Is there a function built in to Access or an easy way to perform this, or do I have to make my own function to handle this?
Forms :: Allow Edits In Design Mode
Jan 9, 2015I have a form which was locked down (ie Allow additions, allow edit and allow deletions were all set to no) on the Form property. I want to change this to allow edits so in design mode I changed the Allow Edits property to Yes.
I then went to Form view and was able to update fields on the form. When I exited the form it asked me if I wanted to save the changes so I clicked yes.
On going back into the form I can no longer update the fields I could before. Going into design mode I can see that Allow edits on the form property is set to no again.
What is happening here. There is nothing in the on load or other events to set this to no, besides this shouldn't change the form property should it?
I know I can get around it my setting the property in the form itself but why is the property getting reset in the first place.
Access 2010.