Search results

I recently moved a big application from 2003 and mdb to 2010 and accdb. Now the users are saying that they have memory problems. They used to be able to have three or four forms open in 2003 with no problem. Now it gives a memory error. Is this a known problem? Is there a solution? Robert

So would compact and repair on the FRONT end work when the last front end has closed? Robert

How would I use the Access 2010 setting, 'Compact on close'? We have a back end on a server and many users with front ends on their computers. So would I set 'Compact on close' on the back end? And then it would compact when the last user logged out? Robert

So what does the global setting 'Check for truncated number fields' do? Robert

I have a big application with 100 or more forms. We have just upgraded to Access 2010, programs and data. Now we have many controls, which were fine in 2003, displaying as #####. Is there an option to turn that off? I know I can expand the controls, but sometimes that is very difficult. Robert

Pat: Sure! That is exactly what we have. We have one copy of the back end on a server, and multiple users with front ends on their computers. But we also have a 'master' front end on the server. No one runs that, but everyone gets a copy of it automatically when there are program changes to...

I routinely export queries etc from my development database to the 'live' master database used by users. Every so often I get the error message 'The database Mydatabase.accdb is read only'. Then I can't export anything to it. I don't know why it should suddenly become read only. How do I make...

I have a big application, which we updated to Access 2010 a month ago. It ran fine. Then we also just updated the data from 2003 to 2010. Now we have very slow searches of big tables/queries, and the tech says that 'cpu usage on the server has gone to 100%'. What can be happening? Nothing...

I am updating a system to 2010 format and .accdb. When I copy the program I get an 'Enable Content' message, and some of the menus are not displayed. That is OK, I click on the Enable Content message and all is fine. But today I have the same partial display as when I have the 'Enable...

Bob: I am new to the 2010 menus. Where would I set a reference to Active Data Objects? Robert

I am testing a big application that I am moving from 2003 to 2010 and .accdb. In the VBA of a form, on the line: Dim cn as NEW ADODB.CONNECTION I get the error, 'Compile error: User-defined type not defined'. What do I need to do to make this work? Robert

Pat: I think you are correct. I started with a blank front end database (because the existing one refused to convert) and loaded all of the queries before setting up the links to tables on the back end. Many of the queries then referenced EXPR1 etc. I deleted all of the queries and reloaded...

Bob: Thanks. So there is no setting to just turn the ribbon off and on? Robert

Bob: Thanks! That worked fine. Is there any way that I can remove the ribbon from users' copies of the database? The options along the top, that program users don't need? Robert

I am converting a big application from 2003 .mdb to 2010 .accdb. The forms all display the full size of the screen, and have only an 'X' in the top right corner, not the three buttons to minimize etc. The forms display the correct size in design view. The format settings appear to be correct...

Pat: What sort of changes are there to VBA? How will I know if a change is needed? The form will not display? Robert

I found that many of the queries had lost their field names, and were showing EXPR1, EXPR2 etc, in place of field names. I deleted all of the queries and reloaded them, and now the application now works, though I think there is some tweaking. One obvious change is that all forms fill the entire...

Doc Man: I don't use DAO, does that make any difference? It seems as though nothing works. As soon as I try to display a form, I get an 'Enter parameter value' message. I get that many times, and then Access crashes. Does that indicate that it can't find the underlying queries? Or the...

Pat: Understood. I didn't explain my question very well. What I meant was, I have programs which work perfectly in 2003. After I update my back end and front end to .accdb, should those programs still work perfectly? Or are there significant changes that I need to make when I get to .accdb...

Pat: Yes, I removed the BE links before converting the front end, and then reset the links to the .accdb BE after. I can see all of the linked tables in the front end, and all looks OK. I am mystified as to what may be wrong. Should 2003 programs work OK in .accdb, or are there limitations...