Will copying the database file while it is still in use, cause corruption in the original file?I've read numerous places that you shouldnt copy the file while it is being opened by another user because you dont know what sort of state the db is in.How to interpret that sentence? Is the consern here that the copy may be corrupt, or that copying the db file corrupts the "active" db file?
I have a script that copies the file each 15 minutes. I also take regular backups manually simply by CTRL+C ->CTRL+V
I then check the "new file", and do a compact and repair. If nothing seems to be wrong, I save it in my backupfolder. Is this actually a problem?
But now, I read that simply copying a db file may cause corruption..Split db, backend about 10mb, 15 concurrent users, all users are writing to the db, all users have their own frontend.All users are on citrix terminal server.
Hey, can someone help me out here, I want to make my database so it is read-only for all other people who use it, besides me, as I'm the only one who really is making changes to it. Would there be a way to do this, perhaps in a multi-user environment?
Also does Access have a tool to automatically backup the database at regular intervals, such as the end of a day. I thought it had that feature but couldn't find it in help.
I'm posting this in the general area as it will eventually save nearly everyone a headache of mass proportions.
Any regular reader of these forums has heard myself and many others talk about the importance of backing up your data on a regular schedule. I've described my method in a little detail, and others have also explained their methods. However, almost without fail, there will be a post in here at least once a week about someone's DB becoming corrupted, lost, deleted, or otherwise FUBARed.
It used to be a pain in the butt to remember to back things up, to track CDs, etc. Lately, however, it's becoming increasingly more affordable to simply buy an external hard drive and schedule it to back up once a day, once every other day, or whatever.
I personally bought a 320GB external drive for $99 at a local giant electronics store, and it backs up my entire 300GB drive once a week at 3:00am every Sunday. Mine takes about 90 minutes to complete, but your mileage may vary depending on the size of your drive, what you decide to backup, etc.
I'm just passing along the information that it has become amazingly cheap to backup everything for very cheap, and you don't even have to think about it. It's just there as a just in case when you need it. There's nothing more frustrating than realizing that everything you've worked on for the past month is suddenly gone, be it to DB corruption, hard drive failure, etc. However, that is completely beat out by the feeling that it's backed up securely.
I don't have any vested interest in this stuff. Rather, there isn't much else for $99 that affords that piece of mind. Keep it in mind the next time you're proud of all the work you've done. It would suck to lose it, wouldn't it? ;)
Is there a way to automatically backup a database? Or is copying the mdb file the only way? Also..has anyone written any VB code that might do this when the database closes?
Is it possible to place a button on a form which will create a backup of the entire file? I add records to a db on a daily basis, and would like to make the process of creating a backup a little easier.
Hi :rolleyes: I would like when I click a button for the system to automatically create a copy of the whole database and place it into a separate folder. How would I do this??? :confused:
I am wondering if there is a way to recombine a database once it has been split?
More specifically, I am going to split a database on our server so that different individuals can access it at the same time. I am wondering if there is a way to allow for a backup to be done such that if the server crashed, which I am afraid it might, we could recover our database without difficulties.
Is there a way to make a working backup of a split database if you change the directories that the different files are stored in?
I am desperate for some help. I have been asked to establish a database for our office use and I have done the best that I can without any 'education' or 'instruction' on access, but now I am just absolutely stuck.
I have made forms, and tables, and a switchboard but I think I am having major 'relationship' issues and thats why my forms are not 'cooperating' with me.
My questions I think are so specific to the database that I just created, or tried to anyway, that I really can't ask a question in 'general'. I could send someone my database and let ya look at it and then perhaps you could assist, if anyone is interested.
Thank you so much, like I said I am very much inexperienced in this and am desperate.
I need to be pointed in the right direction if you don't mind. I understand underlying database structures pretty well, but I am not sure how to create a form in Access so the user can enter new data. I am tring to create a form based off of the classes table first and then go from there. I was hoping to be able to allow the end user the ability to enter all information from one form.
I have attached the relationship structure that I have setup but I am not sure where I need to go next. Should I create queries and then insert the queries to my form?
I got an MS Access 2003 db which I think has an general option disbabled or so dnno, here's the case:
When I create a query, and choose to close the query (just be clicking the "X" button at the top), Access doesn't ask me to save the query or not.. it directly displays the box to fill in the name of the query
When I execute an action query, Access just executes it when I click "!" button, without asking me if I want to "deleting, updating, adding xx records"
I've been searching ages to find an option to enable but I can't seem to find anything
im trying to upload a document with screen shots on the forums. Its 336kb, how do i make that smaller so ican upload since the limit is 100kb, if i take a screenshot and put them into 1 docuemnt per screen shot it still 115kb.
i'm getting annoyed by Access 2003 (and 97 for that matter!) just corrupting records in a table and then i have to scrabble around, kicking people out the database, compact & repairing, maybe installing the back up copy and in one case, doing a make table query from the data table that excluded the corrupted record
:(
are there any general things i can do to avoid these things, or am i just going to have to roll with them?
Hi, I'm very new to Access DB developing, but I'm learning loads, thanks to this site.
What I'm trying to do, and it's driving me crazy, is the following: I have a Table that has to fields (Total Daily Weight) and (Total Yearly Weight) and I have a field that calculates the percentage of yearly weight based on the total daily weight. Now I know you're not supposed to store calculated values, so my question is..How do report on this calculated value?
A little more backround on the database: The Database tracks waste for companies. They supply me with a total for the year, I weigh the total for the day, and then calculate to % and report on it for them....The problem comes when I go to print a report...I don't get the calculated % of yearly waste.. I keep reading on here that it should be done in a query? Can someone please guide me what I should do? I can put a copy of the DB up if it helps. Any help would be appreciated.
Alright I have two tables, one is a user table, the other is one that holds the users roles. A user can have multiple different roles (up to 9). If you do a regular join on the tables you will get one that shows all the user information repeated each time for the number of roles they have. What I would like to do is design a form or something where the user can specify which role (1-9) they are interested in and the system will display all the users with that role. So for example show me the users that only have role 1 and no other role. I did this manually for one role by the following 1) Joining the two tables. 2) Setting a count to see which users have more then 1 role. 3) Eliminate any users the had more then 1 role. 4) Specify which role I want to display.
So is their some type of front end I can create where the user can specify what role they want to filter for with and without the exclusive roles?
I am under pressure from the client to import data for individuals into the database despite not having their preassigned unique identity number available for every individual. This ID number is the primary key for the table in which individuals' records are stored.
solution that will allow me to import the individuals with a temporarily assigned ID number but that allows that field to be updated with the correct ID number once it becomes available?
i would like to log every action any member does on my database.i will have a log in screen(passworded) and i would like to record every button clicked. the only thing is i would like to include other things in the record aswell. like record changes. is there a neat little trick to do this or is it just going to be very labour intensive.
Is it possible to have a form in access which is always visible - say on the left of the screen - then if a button is pressed alternate forms appear on the left?I realise I could create one tabbed form with a menu on the left and sub-forms on the right but I wondered if there was another way which is "smart" looking?
I have a program abc.mdb and abc.mde, I made some changes to the codes in abc.mdb and now I have been trying to convert the access file from abc.mdb to abc.mde so that the users are able to use the updated file. However, whenever I make MDE file. It doesnt work but creates another file called db1.mdb instead.
Hi I am in the process of designing a new database using Access 2003 for my company. I have very little knowledge of access and what knowledge I do have is self taught!
The database is to hold medical records about patients that we see (we run a small medical centre)
The information that we put on it will include the patients personal details (name address etc..) and also details about treatments given to them.
Could anyone give me some advice on what type of database sounds best for this type of information. At the moment the database will only be used in the medical centre but will be accessed by more than one person at a time (not sure if that is relevant !
I really would appriciate some advice as some of you guys have helped me before and i value your opinions.
I'm building a simple database for my church but I'm uncertain how to inter-relate/connect the tables in order to pull some data into a report.
In one table I have the primary parish member, his or her spouse, with their birthdays, anniversary date and other information (e.g., address, phone numbers, e-mail, etc.).
In another table I have their children, birthdates and other information.
How do I create one report with the names and birthdays from both tables?
I have tried to figure out what the difference in functionality would be between 1 and 2. In the latter I have just created a series of relations between the last two tables (but that structure could be used throughout the whole DB instead of hanging it together with one relation between tables as is the case for the rest of the DB in this picture).
So there can be three different situations with this table structure: - linking all tables together via multiple relations - linking all tables together via a single relation - a combination of both, such as in the images.
Why would someone choose one versus the other? "Which is better in what situation?"
I've been fiddling about for a while now, but in a structure such as this it doesn't seem to make a difference. Or maybe there are differences in use/design, but on a level that I have not explored yet.
Could anyone explain this to me a bit? I have multiple books, all of which handle basic relations but I have not yet seen an explanation for this question. I think understanding the whole relationship topic is critical to be able to see other pieces of the puzzle fall into place later on. And as of yet, this is really fuzzy to me.
Hello, I have two fields: Ordered and Delivered formatted as general date. I want to know the difference in hh:nn. I tried to build an expression, but it is coming up blank. The fields are named Ordered and Delv_Date. I am looking to have the Time_Calc field calculate once the Delv_Date is entered. Can someone please help me??? I have minimal knowledge in VB.
Any help will be appreciated. Thank you in advance.