I am the only one working on the database, too early for anyone else :). The Database did not have a user name or password assigned to it. Is there a default password that Access assigns?
----- Original Message -----
From: Philip Arnold
To: CF-Talk
Sent: Monday, March 22, 2004 8:21 AM
Subject: RE: Access database - Access Problem
> From: Mickael
>
> I am trying to read an access database that is in a shared
> folder on our network. When I try to set up a DSN I get this
> error
>
> Connection verification failed for data source: Elms
> []java.sql.SQLException: [Macromedia][SequeLink JDBC
> Driver][SequeLink Server]Required user name is missing. The
> root cause was that: java.sql.SQLException:
> [Macromedia][SequeLink JDBC Driver][SequeLink Server]Required
> user name is missing.
Check a couple of things:
1) Nobody has it in design mode on a table you're trying to use - that
causes MAJOR problems in Access
2) The username and password are in the DSN settings and your CFQUERY
Access is awfully picky about being used as a server database, mainly
because it's not designed to be used for that - it's a desktop
application and likes doing that...
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
