469,636 Members | 1,555 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,636 developers. It's quick & easy.

Access 2007 : Data Stability on Network

I am new to Access. I have developed an application in Access 2007. I have kept all the tables in a MDB file and all the forms in a seperate accdb file. All the tables of MDF file is link in the accdb file.

As long as I was working in the local computer, everything worked fine. But when I put the backend MDB file in the server, and front end ACCDB file in the client computer, quite frequently the database (MDB) file is getting corrupt.

Has anybody faced such problem of database instability in Access 2007 ? If that is so, what is the way out ?

TIA
Milan.
Feb 18 '08 #1
4 2373
Megalog
378 Expert 256MB
Just curious, why are you working across formats? Why not keep both the front and back end to ACCDB, or MDB only? As long as you dont have other different front-ends using the same MDB back-end file, upgrade it to an ACCDB and see if that fixes your problem. Keep a good back-up the old MDB until you iron out any bugs.
Feb 18 '08 #2
I am new to Access. I have one question to ask to this community of Access 2007 users.

I tried to put my Access 2007 (front-end) and Access 2003 (back end) application on the server. I keep back-end on Server and front end on all client computer.I am quite frequently facing database corruption problem. Is that Access 2007 issue or it is something wrong with my setup ? My server uses Windows 2003 Server.

Secondly there has been tremendous downfall in speed of the data. Is that also something to expect from Access 2007 ?

Your input will go a long way in help me take the decision.

TIA
Milan.
Feb 18 '08 #3
Scott Price
1,384 Expert 1GB
Milan,

This is basically a duplicate posting to this thread. Please refrain from duplicate postings in the future. I have combined the two threads instead of deleting the duplicate, because in this case, you have provided more information.

MODERATOR
Feb 18 '08 #4
Scott Price
1,384 Expert 1GB
It sounds like you have two separate issues: Corruption of the backend, and Loss of Speed.

Corruption: please have a look through Preventing Corruption, Recovering from Corruption, Converting to Access 2007 all by Allen Browne.

As for the speed issue, how are you linking the two parts of your database? Speed can be affected by a great many things, but usually is a problem with running un-optimized queries/code.

Regards,
Scott
Feb 18 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

49 posts views Thread by Allen Browne | last post: by
4 posts views Thread by lupo666 | last post: by
9 posts views Thread by prakashwadhwani | last post: by
7 posts views Thread by Icarus | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.