Password Protected Table

[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?

 

[Jerry Whittle]

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.

 

[Troyer]

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.

 

[Jerry Whittle]

How are the tables linked? Is it through an ODBC connection?

 

[Troyer]

Yes it is.

 

[Jerry Whittle]

Is the ODBC connection properly set up. Something like what is one this page:

http://www.sqlstrings.com/MS-Access-connection-strings.htm

 

[Troyer]

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);

 

[Troyer]

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?