Hi! Please help:
We have an Access application, using linked SQL server tables, on
network. After moving to a new server, the access file is always
crashed, sometimes the system table (Msysmodules2) exclusively opened
by another user (but the default open mode is Share), sometimes the
file is not recognized as Access file. Every time when that happened,
I have to copy the file from my C drive to the network to solve the
problem, but half day later, that happened again. The network people
don't think this is a server problem. What that could be?
Thanks!
Saiyou
2  1730 
One possibility is a faulty network card on the new server.
Access is more sensitive than other applications, so it can fail when other
applications seem to work fine.
Ask your network people to put a "sniffer" on the server's network card.
HTH
- Turtle
"Saiyou Anh" <wa***@alexian.net> wrote in message
news:a5**************************@posting.google.c om... Hi! Please help:
We have an Access application, using linked SQL server tables, on
network. After moving to a new server, the access file is always
crashed, sometimes the system table (Msysmodules2) exclusively opened
by another user (but the default open mode is Share), sometimes the
file is not recognized as Access file. Every time when that happened,
I have to copy the file from my C drive to the network to solve the
problem, but half day later, that happened again. The network people
don't think this is a server problem. What that could be?
Thanks!
Saiyou
"Saiyou Anh" <wa***@alexian.net> wrote in message
news:a5**************************@posting.google.c om... Hi! Please help:
We have an Access application, using linked SQL server tables, on
network. After moving to a new server, the access file is always
crashed, sometimes the system table (Msysmodules2) exclusively opened
by another user (but the default open mode is Share), sometimes the
file is not recognized as Access file. Every time when that happened,
I have to copy the file from my C drive to the network to solve the
problem, but half day later, that happened again. The network people
don't think this is a server problem. What that could be?
Thanks!
Saiyou
Is the Access file the Front-end? If so each user should have a private
copy.
Also, is the new sever a Windows server? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mad Hot dog |
last post by:
Hello group!
I use MS Visual C++ 6.0, ADO, MS SQL Server 2000.
When I attempt to open my database I meet with a following problem:
when I try to get a bookmark of the current record in a...
|
by: PM |
last post by:
Has anyone found a way to open a file exclusively where it
will fail if the file is already open, i have tried the
following
_FileStream = new FileStream(@"C:\Data.txt",
FileMode.Open,...
|
by: wandali |
last post by:
When I want to edit a MS Database, I have to run the following command:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"\\Server\Directory\File.mdb" /wrkgrp...
|
by: kevinrost |
last post by:
I share a database on the network with another user. When she has it
open I am unable to make design changes to tables, forms and reports or
create new ones. This being most of my work, it makes it...
|
by: caradhras |
last post by:
I've been troubleshooting for a friend's charity. She wants their
database accessible from both their PCs (I'll call them A & B), which
are on a local network, both running A2K on Windows 98.
I...
|
by: ACE FAN |
last post by:
Hi,
I;m a newbie trying to get through some examples in VS2003. I'm trying
to open a small Access database using ADO.NET in an ASP.NET app usinig
an oleDBConnection. I get the following error...
|
by: Tom Wild |
last post by:
Hi
I am trying to connect to an Access database from a WebPage in VB.Net but
when I try to open the connection I get the following error:
The Microsoft Jet database engine cannot open the file...
|
by: Tom Wild |
last post by:
Hi
I am trying to create a webform that connects to an Access database.
If I use the connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Gizmo\Gizmo.mdb"
Then the application...
|
by: stonward |
last post by:
Hi Folks,
This one is from work!
Running Access 07, usually our default saving format is 2003 - not our fault.
I want to publish a database to our SharePoint system, but the database must be...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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...
| | |
