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 2537 Megalog 378
Recognized Expert Contributor
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), what's
gone (features removed), what's fixed (old issues solved), what's broken
(new bugs), configuration, compatibility, should you buy, and links.
It is opinion, so you may disagree, but hopefully it's an informative
summary.
|
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 2003, no performance problems. However, when I open
the same database in Access 2007, it's as slow as molasses. Data
trickles onto the form instead of an immediate display in Access
2003.
This happens regardless of whether I keep the Access...
|
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 Database as the backend. In my MS Access 2.0 program the code is present to make the link between the data database on the backend and the application database on the frontend. Both computers are part of a local network. I know that MS Access 2007...
|
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 relative textbox,
depending on value?
(2)
|
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 using query which have a field attachments. so please help me which keywords(datatype) i used to create attachment datatype in a table like we use varchar to create character type field.
or
How to create a attachments field in access 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.
TIA
Milan.
|
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
like to know is the stability, speed & ease of use of both the
products.
I believe Access 2007 has a new file format too and that it may be
slower.
|
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 form with multiple tabs and
subforms, the form now takes a "very" long time (more than 10 minutes)
to load.
Has anyone come across this before, and if so were you able to fix it?
|
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 feature. I get the error message " The Microsfot Office Access Outlook add-in is disabled...." I tried everything I could think of to get the Accolk.dll file to load into Outlook but failured. Has anyone seen this or have any idea how to force...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |