[AccessD] Upsize?

Hi Marcel
In addition to what Gustav (read Legend) has said

I have just written a simple (and I do mean simple) 
import/link routine for SQL that uses
Table names stored...in a table

It loops through all the table names stored in the table
And links or imports the SQL tables

Got the cool assistance from this list just last week from Shamil

Lemme know if you want a copy

Any Me Too's to d.dick at tripledee.com.au

See y'all

Darren

---------------------------------------
NIMBLE
T: 0424 696 433 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Saturday, 17 December 2005 10:14 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Upsize?

Hi Marcel

The really quick method is to use ODBC. Despite all the rumours, it may run very
fast. Of course, it depends on your amount of data.

And the efforts are close to zero: Copy tables, indices and relations to SQL
Server and attach these tables to the frontend using the same names as
previously. Some queries may need to have some options specified like
dbSeeChanges. The only area that requires redesign is code that handles TableDef
objects directly.

Not very sexy, I know, but probably very cost-effective.

/gustav

>>> oost at e-business2start.com 16-12-2005 21:19 >>>

Hi Guys,
Just a question. I have distributed*Access 97, 2000 and 2003 databases as
backend database with about 600 installations. Now i want to port the access db
to sql server (MSDE). I know the access upsize wizard exists but this wizard
does not seem to to it right.
I have a database with about 50 tables which are related with each other and in
many case the relation is made with a query instead of table to table relation.
The upsize wizard does not convert the queries to stored procedures.
Does anyone know a good way to get my access db to sql server with all tables,
relations and queries.
Tnx, marcel

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com