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.
4  2532 
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.
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.
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
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
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Allen Browne |
last post by:
If you are looking for opinon on what's useful in Access 2007, there's a new
article at:
http://allenbrowne.com/Access2007.html
Covers what's good (useful features), what's mixed (good and bad),...
|
by: Michael |
last post by:
I work with a highly programmed Access
database (some 15,000 lines of VBA code, much of it automating data
entry on forms -- and believe me, it's very tight code). In Access
97,
2000, 2002, and...
|
by: odrap |
last post by:
I have a database written in MS Access 2.O that i'm intend to convert to MS ACCESS 2007.
The database is a multiuser application which consist of a application database as the frontend and a Data...
|
by: lupo666 |
last post by:
Hi everybody, this time I have three problems driving me nuts :-(((
(1)
I have a report with 20 or so Yes/No "squares". Is there a way to
either hide/show the "square" or change the yes/no...
|
by: amrit1123 |
last post by:
I m working on ms access 2007. and i want to create a table which have a field of datatype attachment through query u .like this (create table tablename (name varchar);). so, how to create a table...
|
by: Milan Mehta |
last post by:
I have my application running in Access 2007. Can I use port my database to MySQL and retail Access 2007 as front End ? As this will save lot of my efforts but still get the stability of MySQL.
...
|
by: prakashwadhwani |
last post by:
Hi !! I'm about to develop a new project for a client.
Should I go about it in Access 2003 or 2007 ? Purchasing it either
for me or for my client is not a major consideration here ... what I'd...
|
by: Icarus |
last post by:
I have a Access 2000 database that I am opening with Access 2007.
When I open the datbase in Access 2000 or Access 2003, the database
runs as expected.
In Access 2007 my main form opens, a...
|
by: jzalar |
last post by:
I recently installed office 2007 just to make my life more difficult. I started to use the Email Forms for data collection last week. Started up my computer yesterday and I could no longer use the...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
