473,326 Members | 2,173 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

closed database

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.However they revert to limited set before database is
accessible.

Thanks for any advice

Bazza
Nov 13 '05 #1
1 1986
"barry hampson" <ba***********@ntlworld.com> wrote in message news:<AY*****************@newsfe1-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.However 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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
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"...
1
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...
1
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...
6
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
0
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...
3
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...
20
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...
10
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...
1
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...
4
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://...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
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...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.