SELECT ... FROM ... IN 'location' problem 1

[acent]

I have been searching for some time on the Access forums but haven't quite seen a probllem lik this.

I have a report in a sales database that has the following on open script:

sqlst = "SELECT ... " _
   & "FROM ... IN '\\networkpath\po_be.mdb' " _
   & "WHERE ...;"
Me.RecordSource = sqlst

I just split my po database and put a password on po_be.mdb. Now when I try and run this report, I get a runtime 3031 invalid password error.

Is there a way to define the password? I don't want to like the tables to the sales database for security reasons.

Thanks,

Andrwe


"God is a comedian playing to an audience too afraid to laugh."
-- Francois Marie Arouet (Voltaire)

 

[Golom]

Something like this?

sqlst = "SELECT ... " _
   & "FROM [;database=\\networkpath\po_be.mdb;PWD="Password"].TableName " & _
   & "WHERE ...;"

 

[acent]

Thanks for the reply. Unfortunately that yeilded the same error message.

Anderw

"God is a comedian playing to an audience too afraid to laugh."
-- Francois Marie Arouet (Voltaire)

 

[Golom]

Sorry. Remove the quotes

sqlst = "SELECT ... " _
   & "FROM [;database=\\networkpath\po_be.mdb;PWD=Password].TableName " & _
   & "WHERE ...;"

 

[acent]

Thank You!!! that worked wonders!

"God is a comedian playing to an audience too afraid to laugh."
-- Francois Marie Arouet (Voltaire)