Need help linking my SQL backed to frontend

[winterh]

Hi All

I have just converted my access backend database into SQL using the access tool, and it all seems to be in SQL server which is all good, and on the desktop I have a file which seems to be the access/SQL file which is call database.VCS and a logo which looks like a yellow tube.

But the problem I have is linking the frontend to the backend, as I have no idea how to do this, if I us the link tool it want a OBDC and not a VCS.



Please help, as I am sure I have just missed something.

[ssanfu]

Google "connect access to sql server using odbc"

http://bytes.com/topic/sql-server/an...-server-engine
http://www.mssqltips.com/sqlserverti...r-integration/

[winterh]

I am very new to SQL, not bad on Access but on SQL.

I went into the backend of the database and used the wizard to export it into SQL server which seemed to have worked, when I link the frontend do I try and link it to the backend which is VCS or do I connect it to the SQL database.

I need help :-)

[winterh]

Sorry one question, the backend had all the tables in it but none of the Query's do I need to add them into SQL as well