Password Protected Table

  • Thread starter Thread starter Troyer
  • Start date Start date
T

Troyer

I have a Table that is Password Protected. Can I add the password to a query
or a form so that the table opens without having to enter the password?
 
Access doesn't support password protected tables. Is this a table from
another type of database? Is the whole database password protected? Describe
what happens and when to bring up the password dialog box.
 
It is a table from our POS system. I beleive they wrote their own sequel
database system.
The database is protected with a password and when I try to access the table
it asks me for the same password.

Is there any way to tell Microsoft Access what the password is, so that it
is not required when I run my query.
 
Where do i look for that info? (Sorry a little new at this).

Here is the query i'm trying to run (the query works).

UPDATE dbo_MenuItem RIGHT JOIN PLU ON dbo_MenuItem.UDFNum1=PLU.PLU_Num SET
PLU.Cost_Sale = dbo_MenuItem.Cost, PLU.Retail_Price = dbo_MenuItem.Price,
PLU.Ad_Price = dbo_MenuItem.PrPrice, PLU.ADOn = dbo_MenuItem.PrStartDate,
PLU.ADOff = dbo_MenuItem.PREndDate;

Where dbo_MenuItem is password protected table and PLU is Table being updated.

Here is syntax i found somewhere else that shows how to enter a password
into an insert query. But i tried it here and it didn't work. At least not
the way I tried it.

UPDATE my_table
SET myField = 'myValue'
WHERE anotherField =
(SELECT someField
FROM diffTable IN '' [;DATABASE=C:\Data.mdb;PWD=myPassword]
WHERE criteriaField = 100);
 
Hello?
It's still not working. Can you tell me how to use the UPDATE my_table
syntax with the query i am trying to run?
 
Back
Top