E-business2start.com - Marcel Vreuls
oost at e-business2start.com
Fri Dec 16 14:19:31 CST 2005
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