SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Access Upsizing Wizard Problems


Access Upsizing Wizard Problems

Author
Message
Kyle Schlapkohl
Kyle Schlapkohl
Mr or Mrs. 500
Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)

Group: General Forum Members
Points: 523 Visits: 66

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 drop down bars. Now these bars come prefilled and when you try and change them, the machine just beeps at you. I was wondering if anybody had ever seen this problem and what they did to fix it.

-Kyle


Perry Harts
Perry Harts
Old Hand
Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)

Group: General Forum Members
Points: 349 Visits: 10058

When refering to "drop down bars" are you talking about Combo Boxes? If so do you have same problem with Text Boxes?


Kyle Schlapkohl
Kyle Schlapkohl
Mr or Mrs. 500
Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)

Group: General Forum Members
Points: 523 Visits: 66

Sorry, I am having problems with the comboboxes, and with the text boxes. I am thinking there may be a connection problem with the server.


WILLIAM MITCHELL
WILLIAM MITCHELL
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3804 Visits: 3083

In the original Access table design, were those problem combo-box fields created as "lookup" fields? That is to say, if you open the Access table in datasheet view, do you see drop-down lists for those fields? That might be the source of the problem. The upsizing wizard might be using the display field datatype instead of the underlying field datatype, or vice-versa.

Another quick way to check would be to compare the datatype for one of those fields in Access to the converted SQL Server datatype. If they don't match, that's a problem.

If that is the case, you might have to remove the lookups from the Access fields in the table, then modify your forms to re-establish the lookup features.

One more thing to keep in mind is that an Access autonumber field contains a value as soon as you begin creating a new record, but in SQL Server an identity column doesn't have a value until after the record is saved.

Hope that helps.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search