January 6, 2012 at 12:21 pm
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/
January 6, 2012 at 12:30 pm
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
and remember....every day is a school day
January 6, 2012 at 1:14 pm
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/
January 19, 2012 at 9:32 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply