Ask Experts Questions for FREE Help !
Ask
    jenkinsdjj's Avatar
    jenkinsdjj Posts: 3, Reputation: 1
    New Member
    		  
    #1

    Jul 27, 2005, 05:53 AM
    Undating an Access Database to SQLServer2000
    Where can I get info on updating an Access2000 database to SQLServer2000

    Thanks in anticipation
    NeedKarma's Avatar
    NeedKarma Posts: 10,635, Reputation: 1706
    Uber Member
    		  
    #2

    Jul 27, 2005, 05:56 AM
    http://www.google.com/search?hl=en&l...atabase+to+sql
    jenkinsdjj's Avatar
    jenkinsdjj Posts: 3, Reputation: 1
    New Member
    		  
    #3

    Jul 27, 2005, 07:31 AM
    Updating Access to SQLServer200
    Thanks for the very prompt reply.

    Most Grateful

    David Jenkins
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #4

    Jul 27, 2005, 09:57 AM
    Quote Originally Posted by jenkinsdjj
    Where can I get info on updating an Access2000 database to SQLServer2000

    Thanks in anticipation
    There are two things to consider when doing this. You can upload your data to SQL Server using the same table and field names, then relink the tables to the SQL Server database. This is a simple process and you can use your Access app with no changes.

    However this doesn't take full advantage of the capabilities of SQL Server. Also A2K doesn't have as many tools as later versions for dealing with SQL Server. Microsoft does provide a migration utilit and plenty of migration advice on their web site.
    jenkinsdjj's Avatar
    jenkinsdjj Posts: 3, Reputation: 1
    New Member
    		  
    #5

    Jul 27, 2005, 10:22 PM
    Updating Access to SQLServer2000
    Thanks for the replies. I have now successfully updated the database.

    You have been a great help.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Using access create database [ 3 Answers ]

To all. I'm need you all help, how to using Microsoft access create a database. Sample like I want record all the stock in my database and how to using Html interface link to the database. :(

(vb + access)error  the Microsoft jet database eng [ 0 Answers ]

Hi , I hope you can help me please I wrote a clocking program that people use to clock in,in the morning The program is written in visual basic 6 with an ado control that is connecting to an access 2000 database and using a Microsoft jet 4.0 ole db provider. My ado control settings are as...

ASP Form for update database in Sqlserver2000 [ 1 Answers ]

Hello About how can I make update in database that was based in SQL server2000 Details: I made web pages in ASP, and I want to make update in database from the ASP Page I made the code but it gave me a message that "operation is not allowed when the object is closed" Bellow you can see the...

View more questions Search