Search results

  1. A

    Access 2007 to sql 2005

    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...
  2. A

    Declare Sql server location in access vba code

    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...
  3. A

    Access 2007 to sql 2005

    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...
Back
Top Bottom