Eric Barro
ebarro at verizon.net
Fri Apr 27 15:51:59 CDT 2007
Using SQL Management Studio you connect to your SQL Express database where you want the tables to live and then right click the database name and select Tasks->Import Data from the drop down menu. After you select the data source (Microsoft Access) and the file location for the source and the SQL database for the destination, it will create the tables for you. You might have to check indexes and copy and paste your queries (views in SQL). -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Friday, April 27, 2007 1:33 PM To: 'Access Developers discussion and problem solving' Cc: dba-vb at databaseadvisors.com Subject: Re: [AccessD] Dot Net, where to start? In playing around with the VB Express I discovered that you can reference an Access FE in a dataset. Doing that allows you to see not only all linked tables, but also all of the queries in the FE. Theoretically this will allow me to build, save and use queries there where I am comfortable until such time as you guys teach me how to build queries inside of VB.Net One thing I am still struggling to figure out is how to move a table from an MDB to SQL Server Express. I have one specific table which is causing heartaches in Access. It uses memo fields and there are LOTS of "locking issues" when users are trying to edit / add these memos. This is a key table, where the user adds dated notes about the claim, so users are in there viewing old notes and adding new notes about phone conversations and other stuff. Microsoft's party line is that these locking issues are often caused by the way memos are stored in pages on the disk and how JET locks these pages during edits. Thus I believe (hope, pray) that if I move that table out to SQL Server the locking issues will go away since SQL Server handles such things entirely differently. A related benefit is that the BE will slim down considerably. These memos constitute well over 250 megabytes of data in a (consolidated) 700 mbyte BE. I could of course simply build the table by hand but I would really like to "just move it", data and all. John W. Colby Colby Consulting www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.6.1/777 - Release Date: 4/26/2007 3:23 PM