Access to SQL

[seanog2001]

Hi,

I am trying to link tables in my access database to an Sql Server (microsoft sql server 2005) does anyone know how i would go about this? or where i could find info on how to link the tables?

Basically i want to have my access database tables stored on the sql server

 

[DCrake]

You actually need to create your table in SQL and link the tables using ODBC()
David

 

[Pauldohert]

Search for upsizing.

 

[seanog2001]

You actually need to create your table in SQL and link the tables using ODBC()
David

If your tables are currently in Access you need to open up SQL and import them in SQL. Then switch back to Access and use the link table manager to link them using ODBC() types. Point to the sql server database and select the tables. You may also need to create a DNS connection first so that you can set up a secure connection.

David

How do i import tables in sql cant seem to find the function anywhere?

 

[DCrake]

You need to have a SQL client installed on your machine first. Open up SQL and the Enterprise Manager, then create a new sql database and use the import wizard to import the Access tables into it.