Want linked ODBC table as opposed to linked Access table

[elviajero]

I have an Access front and SQL Server back.

I have a table Switchboard_Items that I keep trying to export to the SQL server. My idea is to get a login to the SQL server as the first thing the user sees before the switchboard form comes up when the .mde is invoked.

Every other one of my tables linked fine; if you go into properties of the tables they are type Linked ODBC.

However although I specify file type as ODBC and not Access when I do the export it continually is type Linked Access after the operation completes. The table does appear on the SQL server after the operation.

I've checked all my ODBC settings in control panel and they appear fine; it is only this table has this issue.

Does anyone have any ideas why, or how I could accomplish the SQL server login as the first thing the user sees when the .mde is invoked another way?

 

[elviajero]

Someone in the SQL Server forum suggested:

>>One way you can do it is in the Form_Load sub of your switchboard form you can go ahead and open a connection(ADO) or workspace (DAO) - whichever protocol you are using. <<

I very much appreciated the response but it was a bit over my head. I know the subroutine he's talking about however I don't know the difference between opening a connection and opening a workspace on SQL server, and I don't know the specific code to insert in the subroutine to accomplish what he suggested.

Any ideas? This problem is really vexing me. No one else replied to the post in the SQL Server forum. At one point I was successful in creating a Switchboard that is linked to the SQL server and it prompted for a SQL login on invoking the .mde. I have been unable to duplicate this.