Hi,
I am trying to find out what are the big differences between access
database Jet engine and SQL Server? If I have serveral web
applications (same content different copies) running as different
sites(on IIS), each site using an access as a back-end database, all
sites will be running simultaneously, all the access databases are on
the same machine, on this approach, does each copy of access has its
own Jet engine to handle database transaction or only has one Jet
engine with multiple threads handles multiple copies of access
database. Also, I'd like to know what kind database, and database
engines are used by big sites such as Yahoo, Hotmail, MSN, etc, and
what are the good database structures for the hosting applications
that deal with huge,complex information and large number of users.
Thanks a lot, your time and help are highly appreciated.
1  2205 
On 13 Sep 2004 18:37:35 -0700, pe*******@hotma il.com (Leon) wrote:
I think there is only one instance of Jet running. You can check this
using Task Manager.
More than likely you don't have to worry about Yahoo et al. They take
many orders of magnitude more traffic then yours. One thing for sure:
they are not using an Access back-end :-)
-Tom. Hi,
I am trying to find out what are the big differences between access
database Jet engine and SQL Server? If I have serveral web
applications (same content different copies) running as different
sites(on IIS), each site using an access as a back-end database, all
sites will be running simultaneously, all the access databases are on
the same machine, on this approach, does each copy of access has its
own Jet engine to handle database transaction or only has one Jet
engine with multiple threads handles multiple copies of access
database. Also, I'd like to know what kind database, and database
engines are used by big sites such as Yahoo, Hotmail, MSN, etc, and
what are the good database structures for the hosting applications
that deal with huge,complex information and large number of users.
Thanks a lot, your time and help are highly appreciated. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: John Davis |
last post by:
I don't understand when I do (2), it will throw the error when I run the
ASP. (1) is working fine. Should I use a single quote between the string in
SQL statement in ASP?
(1) strSQL = "SELECT * FROM DATA WHERE id = " & strParm1
(2) strSQL = "SELECT * FROM DATA WHERE id = " & "'" & strParm1 & "'"
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
|
by: Kamyk |
last post by:
Hello all!
I have a tough thing to fix. I have a database which has been corrupted. I
got the following error messages while trying to open it:
The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time
The database is protected by password, so when I want to open I got the
above error message. I cannot import data from this corrupted database into
|
by: chippy |
last post by:
Hi,
I've a VB script that creates a Access object in a word doc.
Here is the full script.
It works for all but the Export. Which always fails with a 3011 error.
If I do the same in Access as a straight Macro or script it works.
Add it as an object and it won't work.
HELP.
|
by: Morten Wennevik |
last post by:
I'm transferring an Excel file from a client computer to a web-page on a
server, then trying to open the file on the server causes this exception
message to occur.
The Microsoft Jet database engine cannot open the file ''. It is already
opened exclusively by another user, or you need permission to view its data.
I open the file using this connection string
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
|
by: Ian Baker |
last post by:
We have developed an Access/Jet database (2000, XP & 2003 versions) that has
been used by clients all around the world for several years and is extremely
robust with 55 tables, 172 hard stored queries (plus about the same in VBA
SQL code), 60 forms and about 18,000 lines of code. The biggest advantage
with Access is that it doesn't cost the client anything for if they don't
have Access already then we provide the Runtime version which makes...
| | |
by: Jean-Marc Blaise |
last post by:
Hi,
I find much regrettable that Database Engine Tuning Advisor be not part of
MS-Express Edition ... A server without such help is not a server.
Besides, you've got the tutorials, but not the tool to play with :-(((
Regards,
JM Blaise
|
by: JACompute |
last post by:
I have an invoicing system that uses a VB6 program to post new invoice entries to a centralized Vendor management system (also in VB6), via a Web server and some ASP code. The system has been in production for some time now, but one pesky little problem keeps surfacing periodically.
System Description:
1. For each new line on an invoice, a specially formatted query line is appended to an Access database along with a blank time/date field....
|
by: Simon |
last post by:
Dear reader,
As far as I know you can work with Access on tree different ways:
· Jet-Engine
· MSDE
|
by: DeelynBaNi |
last post by:
HI all..i have this excel file created during export data from sql server. When i try to import this error occured "external data is not in the correct format' something like that. After i did some research the extended properties need to be change to HTML Import from Excel 8.0. Then the connection is ok. I want to try to import the data from 'Sheet_1' to table in server but another error come up. The Microsoft Jet database engine could not find...
|
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: 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,...
| | |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
