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

Compacting Access Hangs Expand / Collapse
Author
Message
Posted Friday, January 6, 2012 12:21 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:00 PM
Points: 4,175, Visits: 4,257
I'm trying to append some data to SQL Server from two tables in an Access Database and as soon as I enable VBA it's starts to compact but it just hangs.

Any ideas?


For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1231669
Posted Friday, January 6, 2012 12:30 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:57 AM
Points: 1,886, Visits: 18,507
can you please provide more info

Access version...03/07.10
mdb/adp/mde etc
assuming you are "pushing" data to SQL?
how are you connecting to SQL?
the VBA code you are using
any start up parameters in Access?


__________________________________________________________________
you can lead a user to data....but you cannot make them think !
__________________________________________________________________
Post #1231675
Posted Friday, January 6, 2012 1:14 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:00 PM
Points: 4,175, Visits: 4,257
Thanks but I was able to create a new Access Database, import the Access Table and append the Data into SQL Server.



For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1231709
Posted Thursday, January 19, 2012 9:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 300, Visits: 810
exactly my suggestion for whenever Access seems to not be working well anymore. Access tends to be corruptible. Best you can do is copy your objects out of the corrupted shell into a nice new shiny db.
Post #1238851
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse