I have a database with a lot of chemical data. My ASP page allows the user to search out all data from a specific location during a specific time period. It then creates a normal html table with the results.
The problem is when I have a large time period and a lot of parameters. For example: data from location 1, 1959 to 2005 returns a HTTP 500 error. When using "on error resume" only the code and data from the last three years are printed (all html tags etc missing from the beginning of the page).
When I choose the period 1959-2002 it works, and also if I use 1970-2005 (which shows that it's not corrupt data in the 2003 year).
My question is: is there a size limit for a recordset? If so, how do I solve this? If not, what could be my problem? Size limit of html pages?
I have some databases that I am importing data into but the records are so large (over 4 to 6 million) that they are making the file reached the 2 gig maximum.
1) I have the imput tables broken down in to thirds of a month (i.e. Day 1 to Day 10, Day 11 to Day 20, Day 21 to Day 31) so what I was thinking is that there might be a way to just like three different databases together or four and have one be the master puller of the other three?
2) Currently, I have reports and queries that pull from one large table. So how would I set up the query reports etc. to pull from all three databases into one reports or query. Or is this not possible.
If you think of a better way to arrange or work around this problem then I am surely open to suggestions.
I know that Access probably permits around 20 or so users to simultaneously access the database before it start to become unfriendly. However, I have a database that would require 200 or so users grabbing around 1,000 rows of data via an Excel ADO connection to the backend tables.
So they would never need to physically go inside the Access database its self, but instead it would garb data by opening an ADO connection to the database > Grabbing the data > Closing the database connection.
Is this okay to do with around 200 users simultaneously querying the database tables via an Excel ADO connection?
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
I'm still in design phase but I'm going to have more than 30 tables. I know I'm going to have a pretty good number of forms, queries and reports. Should I start preparing for the worst in case this db gets too big? What kind of techiques can I use to make sure that it still runs quickly enough?
I will like to know if access can store a lot of data. I am using a database that was written in access and the database has been in use since like 2004. How long can we still use this database. It is becoming slow and having one or two error messages.
I have a large db. I need something to monitor the size of it. For example the db is saved on a server and used throughout the day. What I need is something to email me an alert when the db reaches 900mbs. Then I can compact and repair the database back down.
I do purge it annually though. Currently it is about 750 mbs.
I am working on something and have to link I think a few thousand tables from a "store bought" database here at work. Is there a limit in regards to access? I know they are just linking but I didnt know if Access gets nutty after a while...
Anyone encounter functionality breakdown due to size or complexity?
Hi, i am wondering how to reduce the size of access. i have included pictures within forms which obviously made the database bigger (it is currently around 12mb). However i have tried to delete the pictures to reduce the size, this method did not work at all. The database remains the same size. does anyone have any suggestions on how to solve this problem i am having?
Hey guys, Was wondering, what is the recommended maximum size for Access databases? I've heard that for very large databases that oracle is preferred. Would Access be appropriate for something on the scope of 5000 records of roughly 6 text and 2 number fields? Do people ever notice performance effects on databases of that size?
Also are there any ways to help reduce the size of the database? Do you recommend change the default field sizes where appropriate and would this have a noticeable effect on a database of this size? Any other suggestions to help keep the database manageable, and functioning?
I'm basically trying to figure out if there's much to worry about here, before I start importing my data. Thanks.
Hi, I have been given an Access database to maintain and it has some performance issues. I have been looking through this forums for recommendatons regardng size etc but didn't really find anything.
It is all in one file (might consider splitting it..) and it has about 350 forms, 300 database queries, 130 database tables and 200 Macros!! Filesize something around 200 MB.
In one of the forms there is a drop down that when changed refreshes two other dropdowns. I have chyecked the queris used and they are really fast but it still takes at least 6-7 seconds for the 2 dropdowns to reload! I don't know if it is due to the way it is done, the VB code calls a macro that calls a query. Personally I wouldn't have done it like that but there has been about 2 years since I did anything complicated with access..
Or is it the size/complexity of it that makes it slow? Does anyone have experince of a similar system?
I have been posting a lot recently and have greatly appreciated the help. I have just been looking at the size of a ms access project, this is a front end for another database so contains no data (runs as an mde for most). I have made a few modifications using access 2007 including at one point having it in the new file format, this was to fix a bug I was getting that caused a particular crash. I found converting it to 2007 and back cleared the problem.
Anyway the main things I added were an active directory query to enable certain buttons for a limited number of users. Including the VBA reference to do this. I also added a new report that when run in access 2007 (even in 2003 format) allows the new reportview so I can have an onclick event within the report for the user to gather more information which it wouldn't be appropriate to have on the main report.
This has balooned the size from 5mb to 50mb even after a compact and repair. Any suggestions as to possible causes could it really be adding vba references causing that much of an increase. I should say i'm not particularly worried it's ok for it to be that size I just wonder why such a massive difference.
I just got done migrating the tables in my database to a SQL server, I went in and deleted the extra table that was created with the migration manager so all the data in my database is on a SQL Server, For some reason the size of the database is still the same. Why is that?
I even when in and deleted the tables query and forms but the size is still the same, if there some setting that im missing?
I had a massive Access file of almost a GB in size. and I deleted all records off the tables hoping it would shrink and my purpose was to have the tables alone in their structures. However despite deleting all records, the database file size seems to stay the same. anybody knows why this is so? I don't think we can "commit" changes to databases done in access as it is done in other databases. anybody knows why this is so?
I would like to open the MS Access Window in a certain position and size.
Somehow similar to open a form when using: - to set the position and size:
Private Sub Form_Load() Form.Move Left:=11500, Top:=6500, Width:=7000, Height:=6000 End Sub
I would like to open the MS Access Window within the screen area at a certain location, and having a certain size. Is there any option in the Access Menu, or I can write some code, and where has to be written, so when I double click on the *.mdb file, the MS Access Window will open where I want and the size I want.
Is it possible (using the menu or VBA code) to find out the size of the objects in an Access database file?For example if the .accdb file is 300Mb, is there any way of comparing the size of the numerous tables/forms/reports/queries etc, that make up the database?(I know that if I created a new access file and imported the objects from the working database that could give an indication but that would be quite a repetitive process).
when I open a pdf through access weather it is by hyperlink or attachment it always opens the full size of my monitor, if I open a pdf outside access then they open ok , how do I set the size that access opens the pdf the size I want.