My client uses an Access front end currently. He would like to link these tables to SQL Server because of the maintainability and recovery. I have used the upsizing wizard to do this and it linked the tables to a created database in SQL Server. However, there is a problem now with the Access front end. The front end used forms that had combobox bars. Now these bars come prefilled and when you try and change them, the machine just beeps at you. The same thing happens when I try to change the text boxes. I was wondering if anybody had ever seen this problem and what they did to fix it.
-Kyle
It depends on what all issues you are experiencing, if you use code to link the tables, etc.
The issue most likely is that the linked tables probably have different names then they had when they were Jet tables. The references to the controls are probably no longer valid. You would want to post your question on one of the Access forums for instructions on how to change your code.
-Sue
|||You are saying problem in accessing the front end, any error or warning during this behaviour?
As suggested you might check under MS Access related forums too.
No comments:
Post a Comment