frontend / backend access question - Microsoft Access / VBA

Similar topics

by: w | last post by:

Hello all!!! For a year and a half now, we have been developing different Access 2000 applications. Most of them are access frontend and access backends. Some of them have SQL server 2000 as a backend. There is one application, which consists of a frontend and 3 backend mdb's. Different companies (80) are using the application: 1. Companies with just one pc and one user. 2. Companies with a Cytrix environment.

Microsoft SQL Server

1738

Performance Issues - Access 2000 Frontend SQL Server 2000 Backend

by: Michael | last post by:

Hi, Simple question: A customer has an application using Access 2000 frontend and SQL Server 2000 backend. Data connection is over ODBC. There are almost 250 concurrent users and is growing. Have they squeezed everything out of Access? Should the move to a VB.Net frontend taken place ages ago? Cheers Mike

Microsoft SQL Server

2805

Different version of Access for frontend and backend.

by: Squirrel | last post by:

I've developed an Access 2002 database which will be deployed with the backend on a server and frontend on the users' PCs. I've now been advised that new employees will be given laptops with Access 2003 installed and that the server software will not be updated. Also some of the users are using Access 2000 and some Access 2002. My question is - will this work? There is a lack of IT support in this department - they've contracted with...

Microsoft Access / VBA

2097

Frontend on Windows PC/backend on a Mac?

by: Squirrel | last post by:

I posted a question a couple of days ago about running different versions of Access for the frontend versus the backend databases. Got some good advice but now I've received this information: "We are currently running AppleShare IP 6.3 and this allows machines running Windows to connect via IP." So the first choice of server is a Mac. The client is willing to buy a Windows machine if necessary but would like to use an existing server...

Microsoft Access / VBA

2191

Problems Caused By Several Users Using A Single Frontend

by: Wayne Aprato | last post by:

I have several Access 97 databases which are split into front end and back end running off a server. The front end mde is shared by 2 or 3 - absolute maximum of 6 concurrent users. This scenario has been working flawlessly for about 2 years. I am now at a point where these databases need to be converted to Access 2003. I think I read somewhere on this forum that the newer versions of Access are not as tolerant to multiple users...

Microsoft Access / VBA

2091

Find and Export backend from Frontend

by: DD | last post by:

Hi I have a split database, that is packaged and used in a runtime enviroment. I want to make it easier for the user, a button on the frontend "Export Backend" They can click on the button then search for the backend and then save the backend to a CD or Floppy.

Microsoft Access / VBA

5621

SQL Backend/Access Frontend

by: PC Datasheet | last post by:

I have zero experience with using a SQL database for a backend and Access for a frontend. I have some questions: 1. Does an SQL database have tables? 2. How does Access connect to the data in an SQL database? Linking, importing, or ??? 3. Earlier today there was a thread regarding DAO and ADO. In the thread it was said that ADO is very useful when the backend is a SQL database. Could someone explain that?

Microsoft Access / VBA

2189

Modify Backend db from the Frontend

by: philelpko | last post by:

Good Morning all, Lost once again which is becoming a common occurance atm. My database has successfully been broken into a frontend and a backend db. A problem has now arisen as it has become apparant that db managers need to add additional field names to a table. I cant find anyway that access will allow you to create additional fields to already existing tables in the backend from the frontend. In a nutshell, is it possible to...

Microsoft Access / VBA

4027

Access Frontend and SQL Backend Database Question

by: Lynx101 | last post by:

Background: I have recently started to look at converting an access backend into an SQL backend. Question: By default, when using a query in access does the SQL server only send the records requested from the query OR does SQL still send everything and the filtering is done by Access? If the latter, how to I get SQL to do the hard work and not access?

Microsoft Access / VBA

8382

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

8717

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

8498

The easy way to turn off automatic updates for Windows 10/11

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

Windows Server

7311

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6162

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

4150

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

4300

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1930

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

1600

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