Solve : Microsoft 2007 issue?

1.	Solve : Microsoft 2007 issue?
Answer» Hello Firstly apologies if this has been covered elsewhere (I did search) and if I have posted in the wrong place. At work we are using an Oracle database with Access as the front END. We were all using this with Access 2000 with no problem at all but since some of us have moved to Access 2007 the databse has slowed dramatically. It is READ only in Access. The only THING I have discovered that didn't happen before in 2000 is the actual fromend .mdb file grows in size whereas this didn't happen with 2000. Does anyone know of anything that could cause this that we could turn off? Thanks.Also, just for info. The database is opened by many users. Some will be using 2007, some will be using 2000, there could even be 2003 users. Ciuld this cause problems?Quote from: ash72 on September 01, 2008, 09:03:24 AM It is read only in Access. Does that apply to all users? Everyone viewing the database with any version of Access have read-only access? Quote from: ash72 on September 01, 2008, 09:03:24 AM The only thing I have discovered that didn't happen before in 2000 is the actual fromend .mdb file grows in size whereas this didn't happen with 2000. I'm not sure exactly what you mean by "file grows in size". Can you explain further, with details? Quote from: ash72 on September 01, 2008, 09:03:24 AM ... since some of us have moved to Access 2007 the databse has slowed dramatically. Is the database now slower when only Access 2000 users are accessing it? Is the responsive practically the same, regardless of which version of Access is being used to access the database?Thanks for replying. Yes all users are read only regardless. The file size should not really grow much. The oracle DB is written too throughout the day but the front end should not really grow that much and especially not modified. The date modified updates constantly and the file size grows at a constant rate. The access DB is really just a few forms with linked ODBC tables. There are no actual tables exclusively in Access. My understanding is that the file size (ie the .mdb) would only be the size of the Access DB and not include the size of linked tables. (I could be wrong). If this is the case the .mdb should really stay the same size. Access 2000 users do not notice that mush change. It has slowed down of late but nowhere near as much as 2007 users.Is Access 2007, the default file format can be changed from Access 2007 to Access 2000 or Access 2002-2003. I'm just guessing here but I wonder whether changing your default file format, if not already changed, would improve the situation. Thanks, I'll give that a go. Would I need to change this on everyones PC?Yes, all PC's with Access 2007 that access that database.Agrees with soybean. Access 2007 DEFAULTS to .accdb. It only has legacy support for .mdb.

Answer»

Hello

Firstly apologies if this has been covered elsewhere (I did search) and if I have posted in the wrong place.

At work we are using an Oracle database with Access as the front END. We were all using this with Access 2000 with no problem at all but since some of us have moved to Access 2007 the databse has slowed dramatically. It is READ only in Access.

The only THING I have discovered that didn't happen before in 2000 is the actual fromend .mdb file grows in size whereas this didn't happen with 2000. Does anyone know of anything that could cause this that we could turn off?

Thanks.Also, just for info.

The database is opened by many users. Some will be using 2007, some will be using 2000, there could even be 2003 users. Ciuld this cause problems?Quote from: ash72 on September 01, 2008, 09:03:24 AM

It is read only in Access.

Does that apply to all users? Everyone viewing the database with any version of Access have read-only access?

Quote from: ash72 on September 01, 2008, 09:03:24 AM

The only thing I have discovered that didn't happen before in 2000 is the actual fromend .mdb file grows in size whereas this didn't happen with 2000.

I'm not sure exactly what you mean by "file grows in size". Can you explain further, with details?

Quote from: ash72 on September 01, 2008, 09:03:24 AM

... since some of us have moved to Access 2007 the databse has slowed dramatically.

Is the database now slower when only Access 2000 users are accessing it? Is the responsive practically the same, regardless of which version of Access is being used to access the database?Thanks for replying.

Yes all users are read only regardless.

The file size should not really grow much. The oracle DB is written too throughout the day but the front end should not really grow that much and especially not modified. The date modified updates constantly and the file size grows at a constant rate. The access DB is really just a few forms with linked ODBC tables. There are no actual tables exclusively in Access. My understanding is that the file size (ie the .mdb) would only be the size of the Access DB and not include the size of linked tables. (I could be wrong). If this is the case the .mdb should really stay the same size.

Access 2000 users do not notice that mush change. It has slowed down of late but nowhere near as much as 2007 users.Is Access 2007, the default file format can be changed from Access 2007 to Access 2000 or Access 2002-2003. I'm just guessing here but I wonder whether changing your default file format, if not already changed, would improve the situation. Thanks, I'll give that a go. Would I need to change this on everyones PC?Yes, all PC's with Access 2007 that access that database.Agrees with soybean.

Access 2007 DEFAULTS to .accdb. It only has legacy support for .mdb.

Solve : Microsoft 2007 issue?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment