Post reply

Enter data

  • February 10, 2009 at 1:57 am

    #134540

    Hi Everybody!

    How can I enter data being in MS access 2000 project to an SQL server 2000 table? I have tried it, but it does not allow me to do so.

    Thanks a lot

    Yacob

  • February 10, 2009 at 2:02 am

    #941013

    Not exactly getting your need, you want to say there is an issue with the security or you are facing issues with migration of data to sql server.

    Anyways, if it is only migration then you have a tool from microsoft.

    http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx

    Sriram

  • February 10, 2009 at 2:09 am

    #941016

    My point is I could access the table, but only displays the data. I couldnt add new data to that table. It is I think a kind of "Read Onlt table". How can I make the Table in SQL server 2000 read- Write?

  • February 10, 2009 at 2:36 am

    #941028

    How are you trying to add the data into the table. can you pls give some more data abt the issue that you are facing.

    You can setup a linked server/ use import export wizard or use the SSMA tool mentioned. All of these will work only if you have datawriter acess also. maybe you only have read only/datareader access to the sql table.

    Sriram

  • February 10, 2009 at 4:10 am

    #941074

    I have created a project in MS access 2000 which retrieves data from SQL server 2000 database. As an example you can use the " Northwind Traders " database which is supplied by MS office 2000 as a sample access project.

  • February 10, 2009 at 6:12 am

    #941121

    yacobsbht (2/10/2009)

    Hi Everybody!

    How can I enter data being in MS access 2000 project to an SQL server 2000 table? I have tried it, but it does not allow me to do so.

    Thanks a lot

    Yacob

    use the sql server connectionstring and you would be able to perform that task.

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • February 16, 2009 at 12:03 pm

    #944762

    Your problem is probably that the table in SQL 2000 doesn't have a Primary Key. You can edit the table in the Enterprise Manager, but Access won't allow it unless it sees a Primary Key. If there really is some sort of unique set of columns in the table, you can define them as the PK in Access and it will probably work.

    Otherwise you will have to set up a PK in the SQL table and then re-link it in Access.

    Todd Fifield

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply