I've never tried this but, what if Access (2003) is not installed on the
server, in the classic front end back end setup? I know sometimes Jet
can process requests on the server, returning less rows. And I know Jet
is often or maybe even always already installed on server OS'. But,
anyone have formal experience with this? Can the install of Access on
the server be skipped? 5 1376
wheel wrote: I've never tried this but, what if Access (2003) is not installed on the server, in the classic front end back end setup? I know sometimes Jet can process requests on the server, returning less rows.
No it cannot. The server in the case of a jet back end is a "file server"
only, essentially a remote hard drive. All processing is local on the
client. There is no need to have Access, MDAC, or anything else on the
server and it would make no difference if you did.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
In article <cn************ *******@newssvr 14.news.prodigy .com>, ri*********@hot mail.com says... wheel wrote: I've never tried this but, what if Access (2003) is not installed on the server, in the classic front end back end setup? I know sometimes Jet can process requests on the server, returning less rows.
No it cannot. The server in the case of a jet back end is a "file server" only, essentially a remote hard drive. All processing is local on the client. There is no need to have Access, MDAC, or anything else on the server and it would make no difference if you did.
OK. But I swear I've read many times something to the effect of
"contrary to many peoples beliefs, jet does not always retrieve all
records from a table when running a query, these are the conditions
under which it will be sure to pull them all...top 100 etc etc". Maybe
I'm crossing my wires and that sort of 'fact' applies to Access/Jet as a
front end to linked (ODBC) SQL Server backend tables?
I'll read around more on this, I know it's been hashed about for a
decade at least. But of course I'd still be interested in what you have
to say on the subject. Thanks
wheel <wh***@wheel.no t> wrote in
news:MP******** *************** *@newsgroups.co mcast.net: In article <cn************ *******@newssvr 14.news.prodigy .com>, ri*********@hot mail.com says... wheel wrote: > I've never tried this but, what if Access (2003) is not > installed on the server, in the classic front end back end > setup? I know sometimes Jet can process requests on the
server, > returning less rows. No it cannot. The server in the case of a jet back end is a "file server" only, essentially a remote hard drive. All processing is local on the client. There is no need to have Access, MDAC, or anything else on the server and it would make
no difference if you did. OK. But I swear I've read many times something to the effect of "contrary to many peoples beliefs, jet does not always retrieve all records from a table when running a query, these are the conditions under which it will be sure to pull them all...top 100 etc etc". Maybe I'm crossing my wires and that sort of 'fact' applies to Access/Jet as a front end to linked (ODBC) SQL Server backend tables?
I'll read around more on this, I know it's been hashed about for
a decade at least. But of course I'd still be interested in what
you have to say on the subject. Thanks
What you've read is, in fact, true.
But all the selecting happesn on the workstation.
An MDB file is a collection of data pages, discreet chunks of data,
and each page is indexed at a certain level. The header of an MDB
file gives certain information about what's in the file. Your
workstation checks that header, then follows the path through the
least number of data pages to find the information it needs.
So, Jet does *not* need to retrieve the whole MDB file, but that's
not because of anything happening on the server, but because of the
way the MDB file is structured, which allows the workstation to
request only the needed data pages from the file system. --
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
In article <Xn************ *************** *******@216.196 .97.142>, dX********@bway .net.invalid says... wheel <wh***@wheel.no t> wrote in news:MP******** *************** *@newsgroups.co mcast.net:
In article <cn************ *******@newssvr 14.news.prodigy .com>, ri*********@hot mail.com says... wheel wrote: > I've never tried this but, what if Access (2003) is not > installed on the server, in the classic front end back end > setup? I know sometimes Jet can process requests on the server, > returning less rows.
No it cannot. The server in the case of a jet back end is a "file server" only, essentially a remote hard drive. All processing is local on the client. There is no need to have Access, MDAC, or anything else on the server and it would make no difference if you did. OK. But I swear I've read many times something to the effect of "contrary to many peoples beliefs, jet does not always retrieve all records from a table when running a query, these are the conditions under which it will be sure to pull them all...top 100 etc etc". Maybe I'm crossing my wires and that sort of 'fact' applies to Access/Jet as a front end to linked (ODBC) SQL Server backend tables?
I'll read around more on this, I know it's been hashed about for a decade at least. But of course I'd still be interested in what you have to say on the subject. Thanks
What you've read is, in fact, true.
But all the selecting happesn on the workstation.
An MDB file is a collection of data pages, discreet chunks of data, and each page is indexed at a certain level. The header of an MDB file gives certain information about what's in the file. Your workstation checks that header, then follows the path through the least number of data pages to find the information it needs.
So, Jet does *not* need to retrieve the whole MDB file, but that's not because of anything happening on the server, but because of the way the MDB file is structured, which allows the workstation to request only the needed data pages from the file system. -- David W. Fenton http://www.bway.net/~dfenton
OK, thank to both of you for shedding some light on this. So, you're
saying that Jet on the client can request what is essentially only part
of the mdb file on the server? The "pages" that host the records that
are needed? In this scenario I can see why it wouldn't matter if the
backend data file was on a separate server or the same hdd as the front
end file. Interesting and very strange sounding! Wonder if this has
anything to do with mdbs getting corrupted if a client pc is turned off
while it's using a mbd on the server...no wonder.
"wheel" <wh***@wheel.no t> wrote Wonder if this has anything to do with mdbs getting corrupted if a client pc is turned off while it's using a mbd on the server...no wonder.
It is, in fact, one of the most frequetly encountered provable causes of
corruption. Power outages and flaky network implementations can cause
similar breaks in communications, too.
There are internal pointers, etc. that are set for I/O operations, and
UN-set after the operation completes. If you break connection and contact so
the DB is permanently, apparently still in an operation that was terminated,
it is one of the forms of corruption.
Larry Linson
Microsoft Access MVP This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: CAN'T SEE THE SERVER FROM VS SERVER EXPL |
last post by:
Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
|
by: John |
last post by:
Hi
What future does access have after the release of vs 2005/sql 2005? MS
doesn't seem to have done anything major with access lately and presumably
hoping that everyone migrates to vs/sql.
Any comments?
Thanks
|
by: sammy |
last post by:
ok... so i restarted my server and i get a
"Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser
to retry your request.
Administrator Note: An error message detailing the cause of this specific
request failure can be found in the application event log of the web server.
Please review this log entry to discover what...
|
by: Gomathi |
last post by:
I am getting a 'SQL Server does not exist or access denied. ' error when
trying to access a SQL Server Database from my local machine. I have the
code on the web server and it is working fine.
My connection string is fine and I am able to log into SQL Server via
Enterprise manager ok.
The code falls over at this line - cmd.Connection.Open()
I have just re-installed .net 1.1 and installed IIS on my local machine. Are
|
by: Dave |
last post by:
I've been running a mobile app for ten months with no problem on three
different servers. When I installed the new netframework 2.0 It stopped
working on two servers that the new framework was installed on. The program
still works on the one the framework was not installed on. I receive the
error,
"SQL Server does not exist or access denied"
cn.Open();
| |
by: B1ackwater |
last post by:
We've fooled around with Access a bit, but only using the
single-user store-bought version. It seems to be a good
database - versatile and infinitely programmable - and
can apparently be used as a front end to SQL server if
we ever needed to go that route.
But - is there a client/server version of Access ? Looking
on the CDW site there is a bewildering variety of packages
and licences and such, but we can't figure out just which
do...
|
by: jbonifacejr |
last post by:
This is my first day here, so please be patient. I do not know how to
search very well so the search I tried to get the answer showed me
topics from the year 2000 and they really don't cover what I want.
I am trying to open MSAccess from ASP..I guess I would use
server.createobject("Access.Application")
OK, but where do i go from there to run a report and have it print to
the default printer?
|
by: NissanSE98 |
last post by:
Hello,
I'm building an asp.net application that will get contact information from an Access Database that is linked to microsoft exchange or outlook.
I go to link tables in Access and choose outlook() and am able to link to the contacts data base. However, when I run my application locally, I get the error: No MAPI clients installed on this machine. Install a MAPI client such as Outlook. Well, Outlook is installed on the local machine but...
|
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: 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: 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: 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: 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: 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: 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...
| |