>
> 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]

