Troubles Access/SQL Database on Network

Dowwy

I have an Access database on a Windows Server 2003 share. This
database contains linked tables that actually reside on a SQL Server.
There are a couple of things that I've noticed recently:

1) Some users cannot open the database if another person is already in
it, but some can. The people who cannot open it do not receive any
type of messages...it just doesn't open.

2) Everyone who opens the database (after the first person) receives a
message stating that it is opening Read-Only

I can deal with the second issue, but not the first. I know I've seen
posts on this group stating that you shouldn't share the front end, but
does that still hold true if there are no tables? What are the
disadvantages of sharing the front end, and why would my people not be
able to open it?

Thanks!

Ryan

Dec 21 '06 #1

Subscribe Reply

1299

Larry Linson

"Dowwy" <ry**********@g mail.comwrote

I can deal with the second issue, but not the first. I know I've seen
posts on this group stating that you shouldn't share the front end, but
does that still hold true if there are no tables? What are the
disadvantages of sharing the front end, and why would my people not be
able to open it?

Apparently, for one reason or another, the first user is getting "exclusive
use" -- perhaps due to modifying a database object. Or, that could be the
way the shortcut is set up, if you're using one.

That cannot happen, so doesn't require diagnosis and correction, if each
user has his/her own copy of the front end.

What else doesn't happen is the significantly increased risk (not certainty)
of corruption of the front end.

What else doesn't happen is that every use of a database object doesn't
retrieve it across the network and add to network load/traffic.

It is not a matter of advantages-disadvantages; it is a matter of your being
very lucky if you aren't experiencing corruption problems with multiple
people logged into the same MDB.

Larry Linson
Microsoft Access MVP

Dec 21 '06 #2

Similar topics

6034

Network Computers Suddenly Can't Access Database?

by: MHenry | last post by:

Hi, We were going merrily along for 6 years using this database to record all client checks that came into our office, including information about what the checks were for. Suddenly, network computers cannot access the database. The message is...

Microsoft Access / VBA

12348

Limit of users in Ms-Access?

by: Hannu | last post by:

Hi. In the ldb file you can see the users of the mdb-file. If you open the mdb-file your machine and username will be written in the lbd- file. Allthough you close the mdb-file your name won't disappear from the ldb-file, before every user has closed the mdb-file. I have heard that there will be problems if the amount of users will be over 10 in mdb-files. Is that true? Hannu

Microsoft Access / VBA

5907

Access + VB6 recordset troubles

by: Ray Holtz | last post by:

I have a database in Access 2003 (Access2000 file format). There are two tables that are being used: Employees and Items. It is linked by the Employee field so that one employee can have many items. I have a VB6 application that is tied into this database using an ADODB.Connection and uses two ADODB.Recordsets: rsEmployees and rsItems. I can pull data from the DB into the app with both recordsets. But I can only change data in rsItems...

Microsoft Access / VBA

2732

Troubles Querying Database in Application_Start

by: Ober | last post by:

I'm having trouble with my security model, Application_Start, and accessing my database. My ASP.NET app is only going to be running in an intranet environment (not on the public Internet). The production environment will have installed everything locally (i.e., IIS, SQL Server, .NET Framework, etc., all on a Win2k Server).

ASP.NET

4403

Ms Access 2003

by: Mell via AccessMonster.com | last post by:

Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server database, just native jet database mdb created on Access 2003 (default 2000)...

Microsoft Access / VBA

4884

How to corrupt a MS Access database file in a 'normal' way?

by: shineofleo | last post by:

Here is the situation: I wrote a VB programm, which stores all the information in a single Access database file using jet engine. It worked well, however one of my customs reported that there was some problems with this programm. I checked, the log files showed that the database was corrupted. The customer told me that there no 'illegal' operation such as pull out the plug, or kill the programm via task manager... So is there any...

Microsoft Access / VBA

2665

Records corrupt in Access 2000+ but not Access 97

by: Owen Jenkins | last post by:

Following on from an earlier post... I can reliably corrupt a record by doing the following ... Open two separate but identical front ends on one PC each linking to the same back end. Edit a records in one front end and leave it unsaved. Edit the same record in the other front end and save the change. Save the change in the first front end - this pops up the Write Conflict message to which I click Save.

Microsoft Access / VBA

2551

Online Connection between Access and SQL Server

by: Michael | last post by:

Hello, I am trying to develop a database solution for an organisation in Indonesia. This organization has a number of offices and users throughout the country. They all need to maintain their own data, but I also need to create a central database, to store all of the data, and share data between the individual users. The problem is that the internet connections are not reliable, so a online solution isn't possible. I am planning to...

Microsoft SQL Server

13242

Preventing Access from crashing, when it looses connection to the database

by: mark_aok | last post by:

Hi all, I have a split database. Both the forms, and the tables are stored on a shared network drive (this is Access 2003). The users use the forms, and the tables on the network drive, there are no local copies. When connection to this drive is lost, Access CRASHES. It does it every single time. Does anyone know if there is a way to check if

Microsoft Access / VBA

8395

What is ONU?

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...

General

8310

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8826

Problem With Comparison Operator <=> in G++

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...

C / C++

8732

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

6166

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

2726

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1955

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1615

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General