Viewing data after upsizing to SQL 7.0 from Access

[PatAnn]

I am new to SQL Server and hope I have any easy question.

After upsizing an Access database to Sql Server 7.0, I am unable to view the tables using the Enterprise Manager or access the data from VB programs that were working under the Access database. I am connecting to SQL server thru VB but no data is returned when I request a recordset, however I am able to add new records to the table.

I used the upsize instead of DTS because I could not figure out how migrate all the indices with the tables using DTS. Recreating all the indices would be very time consuming since there are 67 tables in the database and at least 2 indices associated with each table and some tables have 6 or 7.

I welcome any and all suggestions. Thanks in advance.

PatH

 

[AshleyRickards]

One thing you might need to do is add your login to db_owner or the SA role if your the primary developer or a SQL Dba does not exist. If there is aDBA then have him or her grant you the necassary rights.
When you upsize your index's are not migrated. You will need to recreate them. Use BOL(Books Online) to understand SQL index's.

HTH Ashley L Rickards
SQL DBA

 

[PatAnn]

Thanks for the suggestion.

I have been reading SQLBOL, and it has been helpful.

My son, who also programs, suggest I pick a small table with just one index to work with until I get it figured out. That has been my project this afternoon. So far I have not had any success, but I will keep trying and let you know how it goes.