Hello!
Recently we have been experiencing a problem with our accdb file.
We have a accdb wich is uses by some 10 computers all day. This is connected to a sql server.
We get an error message saying that network connection was lost and all functions in access stops working. The network seems fine on all other areas, so it is just the accdb which loses connection.
We have recently innstalled Office 2007 SP2, but i cannot confirm that the problem started just after we installed SP2.
In windows event log, on programs. We get an event which says "Officelifeboatheang, P1 msaccess.exe P2........"
I am open for all suggestion to what i can check.
Here's a dumbed down sample of what I use in a .bat file, if you need to get up and running quickly with this: - ECHO OFF
-
ECHO Updating Database, please wait...
-
DEL "C:\Data\Database.accde" /q
-
-
copy "O:\Network Path\Database Startup.lnk" "%userprofile%\Desktop" /V /Y
-
copy "O:\Network Path\Database.accde" C:\DATA /V /Y
-
-
START /MAX "C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE /runtime" "C:\Data\Database.accde"
This basically deletes any existing local copies, then copies the latest client along with a shortcut on the desktop. This shortcut points to the networked batch file, so this way everytime they execute it they're getting a new copy of the latest version.
7 2858
Are all your users running the same ACCDB file? If so, you need to distribute separate copies. Running the same front end file could be the problem.
All users use the same. This has never been the problem and i think it shouldnt be a problem because access is made for this type of operation. I also have posted this on Microsoft forum, without any answer..
Any more suggestions? If i have to distribute the .accdb at each clients computer i have a lot of job because it is almost 50 different computers wich occasionally uses this (about 10 at same time)
Sorry, but Megalog is quite correct here. This is just one of many problems created by multiple users sharing a single Access file. And you are incorrect; Access is not made for allowing multiple users to simultaneously use a single file!
The worst problem, and if you haven't experienced it yet, then you've just been lucky, is chronic corruption with repeated loss of data!
You really have to use split your database into a front end/back end configuration, and place a copy of the front end on each user's PC.
Linq ;0)>
Access ISNT made for this type of operation. You seriously need to set up a distribution system. This can be something as simple as a batch file that people run which copies the latest client to their system and then executes it.
There's no software install involved, so it shouldnt be too hard to do this whichever route you take.
But, this isnt a guarantee to fix your network problem. It -is- a guarantee to cut down on potential database corruption (which you might already be having).
Access is the canary in the coalmine.. any network problems and it's going to drop dead.
Tony Toews has an excellent hack for automatically updating multiple front ends. I don't do things on this sort of scale, but people who do swear by the program: http://autofeupdater.com/
Linq ;0)>
Here's a dumbed down sample of what I use in a .bat file, if you need to get up and running quickly with this: - ECHO OFF
-
ECHO Updating Database, please wait...
-
DEL "C:\Data\Database.accde" /q
-
-
copy "O:\Network Path\Database Startup.lnk" "%userprofile%\Desktop" /V /Y
-
copy "O:\Network Path\Database.accde" C:\DATA /V /Y
-
-
START /MAX "C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE /runtime" "C:\Data\Database.accde"
This basically deletes any existing local copies, then copies the latest client along with a shortcut on the desktop. This shortcut points to the networked batch file, so this way everytime they execute it they're getting a new copy of the latest version.
We have been using Access with multiple users for 4 years now. On the most we hade 30-40 simultaniously users. We use .accdb front-end and SQL backend. During the last 4 years we never once have gotten "network connection lost", though we have been experiencsing other issues occasionally.
Either way, this have been going on for 3 weeks, and we now have to find a solution to the problem. I will contact our IT department and have them implement a batch file which runs on windows logon.
This does not solve the problem, it just makes it irrelevant.
We have just resently installed Office 2007 SP2, and i think the problem started after that, though i am not sure.
Thanks for the answers, i used the last one :=)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: D Denholm |
last post by:
I am a Access newbie... Hopefully somebody can help me figure this
out.
I have a database that looks like:
Asset Economic Minimum
----- ----------------
10555 ...
|
by: Patrick Fleury |
last post by:
We have an Access 2002 database and it has started giving us fits.
It works over a network and usually it has several people using it. This
has not been a problem in the past. However, now,...
|
by: Upendra Agnihotram |
last post by:
Hi,
I am having Client-Server Access application. The source db resides on
WinNT Server and some of the client systems are on Windows 2000
Professional. These days i am experiencing frequent...
|
by: adirat |
last post by:
I have read a lot on this subject on newsgroups and other access
related websites on data corruption, but since we are still not able
to isolate the problem – I am posting this detailed explanation...
|
by: bill..AT..piperb.freeserve.co.uk |
last post by:
Access 2000 running on CC3 network. Usually not more than 20 users.
Crashes seem to occur randomly. Is it possible that a laptop going onto
standby or hibernating with db open would cause a crash?...
|
by: NEWSGROUPS |
last post by:
I work for a large organization were my team has developed 2 very
substantial databases in Access 2000. These databases have been working fine
for the last 6 years with minimal issues or problems....
|
by: M.-A. Lemburg |
last post by:
Hello,
we are currently looking into setting up a partner network of
companies interested and able to sell and support our products with a
more regional focus than we can deliver.
The idea is...
|
by: 33223 |
last post by:
Local Area Network (LAN)
Both an EtherNet (wire) network and a wireless network are referred to
as a Local Area Network (LAN). A wireless network does not require
hubs, switchers, or routers to...
|
by: Milan Mehta |
last post by:
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...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
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: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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...
| |