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
SSC Veteran
SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)

Group: General Forum Members
Points: 215 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
SSC-Enthusiastic
SSC-Enthusiastic (147 reputation)SSC-Enthusiastic (147 reputation)SSC-Enthusiastic (147 reputation)SSC-Enthusiastic (147 reputation)SSC-Enthusiastic (147 reputation)SSC-Enthusiastic (147 reputation)SSC-Enthusiastic (147 reputation)SSC-Enthusiastic (147 reputation)

Group: General Forum Members
Points: 147 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
SSC Veteran
SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)

Group: General Forum Members
Points: 215 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
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2120 Visits: 3058

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