Congratulations on getting it to work. But it does seem like you took the long way around.
In our application, we are using SS2005 on the server, I also installed SSE2005 on my laptop for development. On
each client computer that needed to access the database, we created an ODBC connection using SQL Server driver with Windows authentication.
Then we linked the A2K FE to SQL Server. SQL Server prefixes dbo_ to each of the tables that was upsized; when we relinked the FE to SS, we used the original table names (without the dbo).
All this is using DAO, not ADO. In our case, DAO seems to be faster, rather than opening a connection to SS through ADO.
I log on to my computer, open the A2K FE and start to work. No problems. We are thinking about converting to gigabit network cards to increase transfer speed - after we justify the money.
Just my 2 cents......