one database/ 2 main switchboards - Microsoft Access / VBA

allison

I know that switchboards aren't loved in here, but I have a question
about them. I have one database that runs in two locations. Can I make
two main switchboards (one for each location) that goes to the same
database? I am extremely new at this, so please be gentle in your
explanation. Thanks for your time.

Jan 10 '07 #1

Subscribe Post Reply

1671

Arno R

AFAIK you can only have one switchboard in a database.
You could make a switchboard, and rename the form and table, and create another one indeed.

Then you could distribute the app with the proper switchboardform and table activated.
Or you could do some renaming at startup with your switchboardform and table maybe...

I am one of those that don't like switchboards.
I guess I would use just a startupform and switch code and options in a mainform as desired.

Arno R

"allison" <du**********@gmail.comschreef in bericht news:11**********************@i56g2000hsf.googlegr oups.com...

>I know that switchboards aren't loved in here, but I have a question
about them. I have one database that runs in two locations. Can I make
two main switchboards (one for each location) that goes to the same
database? I am extremely new at this, so please be gentle in your
explanation. Thanks for your time.

Jan 10 '07 #2

Similar topics

How much art to put into database?

by: Andante.in.Blue | last post by:

A recent change in the user interface of one of the tech forums I frequent prompted furious debates in the areas of functionality versus look'n'feel of professional applications. This has made me...

Microsoft Access / VBA

Problem with command buttons on switchboards and forms.

by: Chris Bolus | last post by:

I'm a teacher using MS Access on an RMConnect 2.4 network. On some workstations both I and my students sometimes get an error message when attempting to insert a command button on a form which...

Microsoft Access / VBA

Database question - Database Open, Close Design

by: Macca | last post by:

Hi, I have an windows forms application that accesses a SQL database I have a few questions as to connecting to the database. This application will run 24 hours a day. It is a monitoring...

C# / C Sharp

About combining data in different mysql database

by: hansyin | last post by:

HI, I got a problem about restoring data in mysql: I have 2 or more PCs installed with mysql database, with same or almost same table structure, but with different data. Can I combine those data...

MySQL Database

Database design question

by: MP | last post by:

Greets, context: vb6/ado/.mdb/jet 4.0 (no access)/sql beginning learner, first database, planning stages (I think the underlying question here is whether to normalize or not to normalize this...

Microsoft Access / VBA

My Database won't convert to 97!

by: John Ortt | last post by:

Hi everyone. I have a database which I have developed in Access 2000 which is working nicely. The problem is that my customer only has Access 97. I tried to convert the database but the main...

Microsoft Access / VBA

Visual Studio 2005 and Access database mystery

by: surfrat_ | last post by:

Hi, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: The Microsoft...

.NET Framework

Big Desktop Database Application - Architecture Help needed

by: abhijitbkulkarni | last post by:

Hello, I am designing a .NET database application that uses 3 tier architecture. Starting initially, this application will be desktop application but I will convert it into a website later but...

.NET Framework

Trying to build a database driven website

by: pereges | last post by:

Hello, I'm trying to build a database driven website for a library management system. The database is stored on a remote server which all of my team mates can access. I've installed MySQL, PHP and...

PHP

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

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

Content Management Systems

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

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

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

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$) { } ...

Javascript

Navigating the Data Structures and Algorithms (DSA)

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

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

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

Computer Hardware