Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Access Upsizing Wizard Problems Expand / Collapse
Author
Message
Posted Monday, July 02, 2007 10:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 09, 2008 10:58 AM
Points: 111, 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

Post #378311
Posted Thursday, July 05, 2007 8:48 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, December 18, 2010 3:42 PM
Points: 103, Visits: 10,058

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

Post #379263
Posted Monday, July 09, 2007 10:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 09, 2008 10:58 AM
Points: 111, 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.

Post #380027
Posted Thursday, July 12, 2007 9:03 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 12:35 PM
Points: 1,496, Visits: 2,634

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.

Post #381144
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse