Password - Microsoft Access / VBA

Tony

G'day, With a (Access 2003) database that is split (frontend application and
backend datatables) how can I 'pass' a password from the frontend that
allows access to the datatables which are secured by the tables.

Tony

Nov 13 '05 #1

Subscribe Reply

2037

"Tony" <ri*********@ho tmail.com> ha scritto nel messaggio
news:41******@n ews.comindico.c om.au...

G'day, With a (Access 2003) database that is split (frontend application and backend datatables) how can I 'pass' a password from the frontend that
allows access to the datatables which are secured by the tables.

Tony

How do you connect to it?
MAssimiliano

Nov 13 '05 #2

Tony

Thanks for your reply.

I have the traditional front end and backend data file where the tables are
linked in the traditional way. Put another way it is the conventional
'split' database situation with linked tables.

In this case the data tables have been protected with a password and this
produces an error when the front end is opened. (Cannot remember the exact
error).

I want a user to be able to open the front end, have it make the connection
by hardcoding the password. This offers me the advantage of the data being
accessed only through the forms.

What I cannot do at the moment is 'pass' the password to the data file.
"MA" <ma****@massimi lianoamendola.i t> wrote in message
news:Mw******** **********@news .edisontel.com. ..

"Tony" <ri*********@ho tmail.com> ha scritto nel messaggio
news:41******@n ews.comindico.c om.au...
G'day, With a (Access 2003) database that is split (frontend application

and
backend datatables) how can I 'pass' a password from the frontend that
allows access to the datatables which are secured by the tables.

Tony

How do you connect to it?
MAssimiliano

Nov 13 '05 #3

"Tony" <ri*********@ho tmail.com> ha scritto nel messaggio
news:41******** @news.comindico .com.au...

Thanks for your reply.

I have the traditional front end and backend data file where the tables are linked in the traditional way. Put another way it is the conventional
'split' database situation with linked tables.

In this case the data tables have been protected with a password and this
produces an error when the front end is opened. (Cannot remember the exact error).

I want a user to be able to open the front end, have it make the connection by hardcoding the password. This offers me the advantage of the data being accessed only through the forms.

What I cannot do at the moment is 'pass' the password to the data file.

www.sitocomune.com
sezione tables
Riallegare tabelle. Funziona anche se il Backend e' protetto da password.
di Alessandro Baraldi

ciao
MAssimialino

Nov 13 '05 #4

Similar topics

3709

Checking password with mysql & PASSWORD()

by: John Victor | last post by:

In my mysql database, I've stored all the passwords using the PASSWORD() function. Now I'm running a test and need to compare the password in my php document to that saved in the database. I used the string "Select name From users Where password = PASSWORD('$testPass')" and ran mysql_query() using the string. But nothing was returned. So I decided to run a test and try to change a password from my php page using the string

PHP

6009

How to re-provide password to encrypted linked tables?

by: Jill Elaine | last post by:

I am building an Access 2002 frontend with linked tables to an encrypted Paradox 7 database. When I first create these linked tables, I'm asked for the password to the encrypted Paradox database, and the linked tables are successfully created. I use the data from these linked tables in several forms. All works great until I close the Access frontend and open it again. When I try to use the forms, I get an error message: "Could not...

Microsoft Access / VBA

9883

Changing Password to an account that has to change password at first logon using System.DirectoryServices

by: Fabrizio | last post by:

(Sorry for the crosspost, but I really don't know which is the right newsgroup!) Hi all, I try to change the password to a user that as to change the password at first logon: try {

C# / C Sharp

16926

vb.net set access database password

by: scorpion53061 | last post by:

is it possible to set the database password that you can set in access for a database from a vb.net application?

Visual Basic .NET

5508

Salt in encrypted password in pg_shadow

by: David Garamond | last post by:

I read that the password hash in pg_shadow is salted with username. Is this still the case? If so, since probably 99% of all PostgreSQL has "postgres" as the superuser name, wouldn't it be better to use standard Unix/Apache MD5 hash instead? -- dave ---------------------------(end of broadcast)---------------------------

PostgreSQL Database

3312

Send Forgotten Password

by: Katash | last post by:

Hello, I am new to PHP and am working on a login system for my site, currently supplied passwords are passed to MySQL and stored as md5 hashes, my question is :- seeing as md5 is 1 way only what would be the best way to implement a 'Forgotten Password' system whereby the user supplies an e-mail address and the password is mailed to the user? The process does not require military level security but I would like to keep stored passwords...

PHP

11372

How to mask console password input

by: julianmoors | last post by:

Hey, Currently I'm writing a VB.NET/1.1 app and I need to mask the input for the password field. Does anyone know how to do this in VB? I've seen a C# example, but wouldn't know how to convert it myself. Here's the URL: http://www.codeproject.com/dotnet/ConsolePasswordInput.asp

Visual Basic .NET

8946

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

8776

Changing the language in Windows 10

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

Windows Server

9449

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

8186

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

6735

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

4550

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

4809

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

2724

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

2180

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