Search results

Hello I had the conversion using SSMA tool and had no issues and its very easy to operate on You can export your tables or choose which tables to be exported Thanks

Thanks Bob I was able to rename the tables from access front end. You rock thanks

Hello I am trying to manipulate things in access vba This is what i have 2 text files and sql link table ( odbc connected ) when i am trying to run the function its throwing me an error "operation is not supported for this type of object" Do i have to add the connection strings and...

Hello I have recently migrated my access database to SQL server 2005 as back end database Earlier, the database was connected using Set db = CurrentDb Set dbDst = DBEngine(0).OpenDatabase(GetDataFullPath()) were getdatafullpath = network location declared in vba constants. Now my...

Thanks for the reply, its really Helpful If i rename the tables in access front end then will i have any issues updating or adding or deleting any records from front end app ? Thank you

Thanks for the reply I did the migration using SSMA tool and was good but few errors in relationships and tables. But the problem i have rite now is all the tables are added with dbo_table1 etc and my front end application just have table1 and when i try to rename the tables in sql its...

Thanks once again for your help and this is very helpful to a newbie like me. So shall i make use of ODBC ?? Do i have to be make any changes apart from linking tables and queries ? Do we have any other techinques or tools which i can use for migrating tables and relationships from access...

Thanks for your response. what i can do here is to copy all the queries from the backend and paste the same queries in the front end access app and then i would create SQL link tables to the front end access application. But what i am wondering what else need to be taken care of apart from...

Thanks for the quick response I am wondering if i link the sql tables to database 2 ( existing acess back End) then how about database 1 ( existing front end application) so there will be 3 databases 1. access front end app 2. access back end app 3. sql link to access back end I am...

Thanks for the prompt reply Actually i am newbie to this migration and have no knowledge what so ever going forward. I will create the primary keys in access before upsizing but i have little question about migration The queries in access database are not getting migrated so what is the...

Hello Friends, I am using two database's of access as front end and back end Front end is used as application and back end is used for data storage. I have a problem with access back end database due to the size constraint and i need to make this back end as SQL database I have to migrate...