Can't Figure this thing out!!! HELP!!!

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

hello everyone!

I have a very very odd issue and I cannot figure it out... Any clues
would be greatly appreciated...

I have an old Access database (Access 97) that its first screen is a
login screen using a form. There is a table where all usernames and
passwords are stored but for some odd reason, the database will not
accept any usernames and passwords unless the computer is on the
network and has access rights to a certain server.

I cannot find anywhere in the code/queries/table any references to that
server... If I disconnect the computer from the network, I get: Compile
error: Can't find project or library

I cannot bring up the project screen but I've checked everything else I
can think of... Any suggestions???

Thank you so much!
 
Off the top of my head you could check SourceTableName
and also check your ODBC setting in control panel
as well as any mapped drives.

HTH - John
 
Tom said:
hello everyone!

I have a very very odd issue and I cannot figure it out... Any clues
would be greatly appreciated...

I have an old Access database (Access 97) that its first screen is a
login screen using a form. There is a table where all usernames and
passwords are stored but for some odd reason, the database will not
accept any usernames and passwords unless the computer is on the
network and has access rights to a certain server.

I cannot find anywhere in the code/queries/table any references to
that server... If I disconnect the computer from the network, I get:
Compile error: Can't find project or library

I cannot bring up the project screen but I've checked everything else
I can think of... Any suggestions???

Thank you so much!
Click to expand...

With that error. I'm thinking maybe there's a reference set to a module,
library, or utility database on the server you mention. Open any code
module, then click Tools -> References... and see what references are
set.
 
Back
Top