Hi all.
I have run into something I would like to call a problem.
First, I am very fresh on updating Access to SQL, I and I am just starting study the case.
I am using Access 2010. The app are based on the new "web - lookalike" menu system.
I am using MS SQL Server Express 2008 R2.
When using the External Data -> Move Data -> Sql Server, everything works fine. One error in one of the queries. When fixed everything was "moved" without any error.
Created a DNS connection, and conected to the new sql database.
Here I stumbled into problem one.
When selecting what table to link in sql server, I found not only tables, but several (not all...) queries. I selected them too... Is this right?
Problem 2 - and this is the big one:
When opening the new front en app, I was getting a error message stating some like "some of my code in the event On Open, in the main form create an error while comunicating with OLE Server or the Active-X control"
Then the main form stays closed.
When manually trying to open the form, all the "buttons" on top and al the subbuttons on the right are not visible.
Then, in the main form, I removed the code in the On Open and On Current events. Then I run a move to sql-server.
Now the new app opens without any error, but again - the main form have no navigation buttons or any subform.
i understand there are lots of new issues for me when I start to look into Upsizing. But a litle hint on where to start would be realy nice..
Can I even use the new "menu system" or should I go back to traditional form navigations?
Regards.
I have run into something I would like to call a problem.
First, I am very fresh on updating Access to SQL, I and I am just starting study the case.
I am using Access 2010. The app are based on the new "web - lookalike" menu system.
I am using MS SQL Server Express 2008 R2.
When using the External Data -> Move Data -> Sql Server, everything works fine. One error in one of the queries. When fixed everything was "moved" without any error.
Created a DNS connection, and conected to the new sql database.
Here I stumbled into problem one.
When selecting what table to link in sql server, I found not only tables, but several (not all...) queries. I selected them too... Is this right?
Problem 2 - and this is the big one:
When opening the new front en app, I was getting a error message stating some like "some of my code in the event On Open, in the main form create an error while comunicating with OLE Server or the Active-X control"
Then the main form stays closed.
When manually trying to open the form, all the "buttons" on top and al the subbuttons on the right are not visible.
Then, in the main form, I removed the code in the On Open and On Current events. Then I run a move to sql-server.
Now the new app opens without any error, but again - the main form have no navigation buttons or any subform.
i understand there are lots of new issues for me when I start to look into Upsizing. But a litle hint on where to start would be realy nice..
Can I even use the new "menu system" or should I go back to traditional form navigations?
Regards.
