Using Upsizing Wizard in MS Access 2003 to link tables with MS SQL Server 2005

MS Access is still in use as Database for some its useful features. Few days earlier, I have a situation like I need to develop Reports from Access Database but, truly speaking, I am afraid of writing quires in MS Access, may be, for its limitations. First of all, I think of exporting this database to SQL Server but better alternative is Link Manager or Upsizing Wizard.



1) Click on Upsizing Wizard.



2) Check Create new database.



3) Check Use Trusted Connection. However, if your SQL Database is on other Computer in Network use Login ID and Password to connect Database Server.



4) Move table or tables from Left to Right Pane you want to export.



5) Click Next.



6) Check Link SQL Server tables to existing application and Click Next.



7) Click Finish.



8) You can remove local copy of tables.


Now, MS Access application will work as it was working before linking with MS SQL Server and data will be stored, modified or deleted in SQL Server as well. You can enjoy full-fledged liberty of SQL Server to format data.

Thanks
A Rahim Khan

Advertisements
    • K. M. Zahid Mahmud
    • February 27th, 2010

    Thanks Rahim. It was very nice work. Now I have a very strong work.
    Thanks again.

  1. You are always Welcome Siplu bhai

    • Ajayi Gbolahan
    • October 12th, 2011

    Thanks Rahim, i appreciate your work. i already have a database running on access 2000, but it becomes very slow to access on network. can upsing it to sql sever inprove its speed, can it run on sql server 7 effectively, and how can i handle the user access password on the access database. thank you.

    Ajayi Gbolahan (gmtajayi@yahoo.com)

  2. It’s remarkable for me to have a web site, which is useful in support of my know-how. thanks admin

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: