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

1933

"Tony" <ri*********@hotmail.com> ha scritto nel messaggio
news:41******@news.comindico.com.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****@massimilianoamendola.it> wrote in message
news:Mw******************@news.edisontel.com...

"Tony" <ri*********@hotmail.com> ha scritto nel messaggio
news:41******@news.comindico.com.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*********@hotmail.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

3681

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

PHP

5992

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

Microsoft Access / VBA

9832

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

16884

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

5431

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

PostgreSQL Database

3298

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

PHP

11345

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

Visual Basic .NET

6904

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

Windows Server

7037

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

C / C++

6735

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

Windows Server

6895

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

4770

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

Microsoft Access / VBA

4476

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

2977

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

1296

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

558

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP