closed database - Microsoft Access / VBA

barry hampson

I know you can do it but don't know how. So how do you close the database to
prevent any more development or interference from users.
More to the point if I have passwords that relate to the database - how do
I unlock it to make it available for development and adaptation again.
I was tols that startting the database with shift key pressed gave acces
to toolbars.Howeve r they revert to limited set before database is
accessible.

Thanks for any advice

Bazza

Nov 13 '05 #1

Subscribe Reply

1998

mvivar

"barry hampson" <ba***********@ ntlworld.com> wrote in message news:<AY******* **********@news fe1-gui.ntli.net>.. .

I know you can do it but don't know how. So how do you close the database to
prevent any more development or interference from users.
More to the point if I have passwords that relate to the database - how do
I unlock it to make it available for development and adaptation again.
I was tols that startting the database with shift key pressed gave acces
to toolbars.Howeve r they revert to limited set before database is
accessible.

Thanks for any advice

Bazza

Hi Barry:

First of all I think it is a must to have an mde database for users...
and tables should be anyway outside in other computer as a server...
if you don't want to use the security of access which is a little
complicated but not that terrible you should have your own security
programed. I have a form on the startup with user and password... if
user is me, then I have all the toolbars and privileges, if not they
have their toolbar called usertoolbar...

I also have for every table a creationdate, createuser, modifieduser
and modifieddate fields... creationdate is on default now(),
createuser is same as loged in in the userform which is opened all the
time but not visible... modifieddate is on the before event ()now and
modifieduser the same but taken from the userform again...

tables are hiden... which is like believe in Santa, but you won't do
it as easy to the users to corrupt your tables... they can't make
changes to the usertoolbar... so. They can't avoid the userform...
because on opening event it hides everything but the form... the key
problem... it is resolved by using mde, linked tables and replicate
database...

I hope this helps...

Mariana Vivar

Nov 13 '05 #2

Similar topics

1550

UDB V8 (Fixpak8) - "Database files closed" monitor element

by: UDBDBA | last post by:

Hi: Currently, MAXFILOP cfg parameter is set to maximum value allowed for AIX 64bit: Max DB files open per application (MAXFILOP) = 1950 Still, we see "Database files closed" increasing gradually: Database files closed = 825 DGTT's are used heavily by application and most of the files closed

DB2 Database

5772

hidden form becomes visible if all other forms closed

by: Andrew Wrigley | last post by:

Hi Should a hidden form become visible when all other forms are closed? This is what happens, and to ensure that it is always hidden, I have to set the on got focus event handler of the form to Me.Visible = False to ensure that it is always hidden, no matter what.

Microsoft Access / VBA

1540

When should objects be closed and/or variables cleared?

by: MS | last post by:

When is it appropriate to "close" objects? Example. Which of these objects should be "closed"? Dim Wsp as Workspace Dim Dbf as DataBase Dim Rstb as Recordset Dim Tdf As TableDef Dim Cdb As DataBase

Microsoft Access / VBA

5223

Help: How to detect if the browser is closed?

by: hb | last post by:

Hi, Would you please tell me how to detect if the client's browser is closed? I need such event to trigger a database modification. Thank you hb

ASP.NET

1096

Problems migrating applicacion from Intranet to Internet. Underlying connection was closed.

by: Luis Esteban Valencia | last post by:

I have an application on my intranet It works fine there when I copied the proyect to the server of the Internet it gives me this error. The arquitecture of my servers are. There is one Server for Internet another server for Databases and another server for Intranet. The only one that has public IP is the Internet Server and obviously I cant give public access to the database server. The applicacion access data on the database server....

ASP.NET

1861

Closed DataReader

by: Lubomir | last post by:

Hi, I have a class A with a public method GetReader: public OleDbDataReader GetReader() { SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings); SqlCommand myCommand = new SqlCommand("CMRC_Top10List", myConnection); myCommand.CommandType = CommandType.StoredProcedure;

ASP.NET

7202

There is already an open DataReader associated with this Connection which must be closed first

by: fniles | last post by:

I am using VB.NET 2003, SQL 2000, and SqlDataReader. As I read data from tblA, I want to populate tblB. I use SQLDataReader for both tables. I do not use thread. When I ExecuteReader on tblB, I get the error "There is already an open DataReader associated with this Connection which must be closed first." How can I fix this error ? For each DataReader, do I want to open and close the connection (in this case adoCon) to avoid this error ?...

Visual Basic .NET

6097

There is already an open datareader with this command which must be closed first

by: jimmy | last post by:

Hi again, sorry for posting two questions so close together but im working on a school project which is due in soon and running into some difficulties implementing the database parts. I have the code below which when executed generates the following error message: 'There is already an open datareader with this command which must be closed first' Private Sub MainMenu_Load(ByVal sender As System.Object, ByVal e As

Visual Basic .NET

3182

Error deleting a closed object in Access 2002

by: sphinney | last post by:

All, I'm not sure how to adequately explain my problem in two sentences or less, so at the risk of providing TMI, here's the condensed verion. I have developed an Access 2002 database file that contains a form, multiple queries and multiple reports. The purpose of the form is to allow the user to run various queries against my company's Sybase server and display a report. Since the queries return ADO recordsets from the Sybase server,...

Microsoft Access / VBA

4563

Will the "Underlying connection closed" bug be fixed?

by: Sin Jeong-hun | last post by:

I don't get the message so it's hard to debug that, but some of my clients report that they get "The underlying connection was closed unexpectedly" exception. According to this site (http:// www.dotnetspider.com/resources/2596-e-underlying-connection-was-closed-A-connection.aspx), it's a bug of .NET 2.0, and the author suggests that we use KeepAlive=false until Microsoft fixes it. It seems like almost 5 years have passes since the...

C# / C Sharp

8444

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

8869

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

8551

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

7386

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

6198

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

4198

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

4368

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

2011

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

1775

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