Database Heavily Increasing In Size Over Short Space Of Time
Dec 5, 2007
Hi all
I have a database I built for my employers that is accessed by up to as many as 50 users at one time. It is a relational database. I did a compact and repair this morning which changed the BE from 215MB to 45MB. I went to lunch and came back and the database is now 58MB. Does anyone have any ideas as to why it has increased by 13MB within an hour? There is no way this is caused by geniune data records.
Thanks
Gareth :eek:
View Replies
ADVERTISEMENT
Aug 22, 2006
Hi,
I have created two databases to try and speed up some data manipulation. One database is acting a a 'sniffer' and runs make table, delete, append and normal view queries. the append and make table queries will either write to the other database (the receiving database) or to itself. I have therefore managed to reduce a run time for these queries from 10 minutes for all queries, to less than 1 minute (as previously all in one database using forms).
The problem is these databses contain only about 10 tables to which I am adding data (non of them contain more than 5000 records at the moment) and I also have approx 50 ODBC linked tables (about 30 MB worth so I can retrieve data i want to write to the tables).
The databse has run through my 10 queries about 50 times (each time pasting new info to my receiving tables - still no more than 5000 records) however both database have increaed from a few MB to over 900MB - Is there any way I can stop this from happening as this seems to be a rediculous increase in size - i am also having huge problems compacting the databases.
thanks
View 1 Replies
View Related
May 10, 2006
Hi,
I got a question related to a database with a frontend and backend.
It seems that every time I make a minor adjustment to the frontend its size increases.
i.e. My frontend was about 2 MB. I made an extra report which I later removed. I quit access and look at my frontend database, the size is now allmost 6 mb!
How is this possible?
View 7 Replies
View Related
Dec 9, 2004
Hello again,
I think my subject heading explains it. How would you add or subtract two short time formatted values and produce a short time value? Also, how would you change a short time value into number minutes. (i.e. 5:30 into 330) Thanks!
G
View 1 Replies
View Related
Jun 21, 2013
I want to be able to set text boxes so that if one enters a date and a time it displays in the format "dd/mm/yyyy hh:mm", but if one just enters a date is displays in the format "dd/mm/yyyy". Is this possible?
Stipulating "dd/mm/yyyy hh:mm" means that when you just enter a date it adds "0" values for the time e.g. entering "21/6/13" gives "21/06/2013 00:00".
General Date allows for an optional time, but it means that when you do enter a time it gives you seconds as well "dd/mm/yyyy hh:mm:ss" - and I don't want that.
View 7 Replies
View Related
Jul 24, 2013
Access stops me from increasing the size of a key field
Table tTrades
. Key field: idTrade: auto-number
. Field: Code: Text 10 characters
Table tData
. Key field: Code: Text 10 characters
I get an error message when I try to change either of these Code fields from size 10 to 16 characters
Error message - you cannot change the data type of field size. It is part of one or more relationships. Te change the data type of this field, first delete its relationships in the relationships window.
I deleted all relationships in the relationships window. But I still get the same error message.
If I click on relationship window > "All realtionships", Access reproduces all my relationships in the relationship window. Somehow it knows them. I deleted them all again and saved. But I still get the same error message.
I have a form ftTrades which generates automatically when I click on table tTrade and create a form.
I deleted this form ftTrades. But I still get the same error message.
How I can increase the size of this field.
View 3 Replies
View Related
May 23, 2006
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.
The link works fine but the time formats are different.
On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format
However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM#
Weirdly though, when you just open the table, the times are in the correct shorttime format.
Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?
Any ideas?
This screen shot may help:
View 2 Replies
View Related
May 23, 2006
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.
The link works fine but the time formats are different.
On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format
However on PC 2, opening the same database via the network, the time format is still short time but the format is in AM/PM or medium time.
Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?
Any ideas?
View 1 Replies
View Related
Dec 11, 2014
I have a datasheet on a form that is unable to show all records in the size allowed. Consequently it has a vertical scroll bar. However, the scroll bar allows scrolling to the bottom whereby there is white space almost the same size as the data records. The horizontal scroll bar does much the same.
Is it possible to just show the records and only the width of the data in them.? No extra records exist in the table to cause this.
View 2 Replies
View Related
May 1, 2013
I have an Access Database of around 8MB. However, after a day's use, this file size increases to around 110MB. If I run a Compact and Repair, the file returns to it's usual size. The first time I noticed this, the file had reached a size of 2GB which is a bit alarming. The file does get used but only appending around 50 records a day and making some amendments. What could be causing this increase?
View 3 Replies
View Related
Jan 5, 2008
I'm trying to refine another of my time entries. To enter a Short time (eg 10:35), I have to type in the four digits AND the semi-colon in the middle.
I would like to be able to enter only the four digits with Access making it into the correct format.
I have achieved a similar effect in Excel using code like
TimeVal = Left(Value, 2) & ":" & Right(Value, 2)
I tried writing something similar in the Before_Update Event, but it was rejected!! Any ideas? - Thanks, Andrew.
View 5 Replies
View Related
Feb 26, 2006
This must have been answered before, but I can't find it by searching so sorry for the dumb question.
I input a time in hours and minutes in a field with a Short Time format. I would like then to convert this to seconds in a field with a number format so that I can total the seconds and then add them to the results of a calculated DateDiff control to get the grand total of time spent on a project.
Any help would be gratefully received.
Cheers
Rob
View 2 Replies
View Related
Apr 2, 2008
I am trying to add hours entered in a short time format. For example 08:15 or 02:55. I also would like it to give a total number of hours beyond 23:00. Here is a table with a Name Column and Hours Column
Name Hours
BETTER,HEATHER 8:00
BETTER,HEATHER 8:00
BETTER,HEATHER 5:41
BETTER,HEATHER 2:35
BETTER,HEATHER 1:15
WILLIAMS,R 2:30
WILLIAMS,R 0:45
WILLIAMS,R 11:20
WILLIAMS,R 8:25
WILLIAMS,R 8:15
WILLIAMS,R 10:20
How do I
A) write a query to add up the hours. I believe Heather would total 25:31 Hours.
B) Show this same total in a report? In my report I had a Name Footer which showed "=Sum([hours])". Will this work once the query is right or will I use the "=Sum([totaltime])"?
Also, is it possible for you to respond in a SQL statement so that I can copy? Thanks.
View 6 Replies
View Related
Jun 22, 2014
i have a problem i have field contains (minutes as number) like 5750 i want to convert thes minutes to short time hh :nn to be 95:50
View 3 Replies
View Related
Feb 12, 2014
How can I convert a number format into a short time format?
View 3 Replies
View Related
May 14, 2013
I have a totals query that displays the sum of what products we ship each day. A process in the system automatically assigns the date/time to a ShippingDate field when an item is marked as despatched.
The totals query allows users to view what products are shipped between a period specified by the user.
The problem I am getting is that when the user inputs dates into fields [txtStart] and [txtEnd], the query fires up but will not display any records as a start time 00:00:00 and end time 23:59:59 was not input.
I don't want users to have to do this but cannot think of a way around it. My criteria code in the query for the shipping dates is
Code:
Between [Forms]![Switchboard]![txtStart] And [Forms]![Switchboard]![txtEnd]
Can I append the start / end time onto the code above somehow or is there another method I can utilise that is probably so glaringly obvious I have missed.
Usually a query allows me manipulate a field property sheet but in this case there is nothing obvious to select like format.
View 2 Replies
View Related
Mar 8, 2006
I've set up a query to calculate the difference between 2 time fields. I set the property to short time.
The thing is - when I run the query in a Select query, the times in the column which contains the difference, appear correctly : ie hh:mm, but when I run the same query in as a make table query, the time difference field (although I have set the property to short time) appear something like this:
0.664464564646
Can somebody please tell me how to make it that the time difference results field in my make table query appears as hh:mm??
Thanks in advance - nelld
View 1 Replies
View Related
Aug 14, 2014
I have two fields that are in short time format, and are saving the information to the table in short time format.
I then have a field that I have set to auto-fill under the chosen circumstances, with a text roughly as follows
Code:
Dim Story As String
Dim IDepTime
DimADepTime
IDepTime = [InstructedDeparture]
ADepTime = [ActualDeparture]
Story = "This person was instructed to leave at " & IDepTime & " but did not do so, instead departing at " & ADepTime & "which caused us a problem"
me.txtnarrative.value = Story
End Sub
This all works, however the times being displayed are in hh:mm:ss format, when I only want hh:mm format - how do I tell it the format I want?
View 1 Replies
View Related
Aug 29, 2005
Will keeping your field size shorter result in a smaller MDB file?
Or does Access only use as much space as there is real data in its fields.
Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.
Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...?
Thanks............
..dc
View 3 Replies
View Related
Aug 22, 2005
I have some project run on MS-Access as front-end with database linked to MS-SQL Server. I have some column of table contain Date-Time data that store data as General Date format (ie 01/01/2005 08:00:00). I create some form for my staff to key in a data of lab test that they will be key in only time with out date value. On form, I show this value as time only too. But I want to use this data with Date value for some calculate as backgroud process.
So...
In case of new data, Database will be store my data as CurrentDate with Time that my staff key in.
In case of data update, Database will be store my data as ExistDate with Time that my staff may update.
What should I do for solve my problem?
View 1 Replies
View Related
Aug 22, 2005
I have some project run on MS-Access as front-end with database linked to MS-SQL Server. I have some column of table contain Date-Time data that store data as General Date format (ie 01/01/2005 08:00:00). I create some form for my staff to key in a data of lab test that they will be key in only time with out date value. On form, I show this value as time only too. But I want to use this data with Date value for some calculate as backgroud process.
So...
In case of new data, Database will be store my data as CurrentDate with Time that my staff key in.
In case of data update, Database will be store my data as ExistDate with Time that my staff may update.
What should I do for solve my problem?
View 2 Replies
View Related
Nov 5, 2014
I have the following code that creates a long string that works most of the time but sometimes gets cut short. I can't understand why it does this. When it cuts the string short it cuts it short in the same place. Everything gets in the string up to/or about the following code '</Practice Name>'This string is needed to upload info to a server.
Code:
dim msg as string
msg = "<?xml version=""1.0"" encoding=""utf-8""?>" & vbCrLf & _
"<soap:Envelope xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" xmlns:soap=""http://schemas.xmlsoap.org/soap/envelope/"">" & vbCrLf & _
" <soap:Body>" & vbCrLf & _
" <UpdateDataForScreens xmlns=""http://mdtoolboxrx.com/"">" & vbCrLf & _
" <PatientObj>" & vbCrLf & _
[code]....
View 10 Replies
View Related
Jul 31, 2013
I have a database which is split so that several people can have a 'front end' to the database to access one common back end. This works fine on a network but I thought I could load the backend up to my webspace and then with the links manager point to it, but it doesn't work. I get an error report of 'not a valid file name.'
The website is [URL] .... and the backend database name is Probus_data_A.accdb and so I entered [URL] .... as the address in link manager.
View 1 Replies
View Related
Sep 7, 2011
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
View 3 Replies
View Related
Jun 15, 2005
Hello friends,
I had converted a Access 97 database to Access XP. The original size of database was about 38 MB.Last week I worked with some queries of different types.Now the size is about 135 MB.How should I reduce the size of database again.I really also dont know whether it happened because of queries... :(
View 5 Replies
View Related
Oct 17, 2005
Hey all,
I am not very gud in access, so I need your help. I am facing a strange problem..... I have created a database which consists of four tables....out of which two tables have relationships. When I make my database and create all the tables as described...its initial size is 320 KB around. When I put data in it, its size increases accordingly....I noticed a strange thing that when I entered some data in my Database it reached around 5MB, but when I deleted all the records from all the tables, the database size didn't decrease. It actually remained of the same size 5MB.......
Why so??? Don't you think that the database size should be decreased when I delete my records from all the tables. Is there any option which I need to select to decrease the database directly??? Well just FYI, I am using JAVA as front end .......
Regards,
Vikas Bhandari
View 2 Replies
View Related
