A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Convert Access Linked Tables from AccessBE to SQL



 
 
Thread Tools Display Modes
  #1  
Old August 24th, 2004, 10:21 PM
BC-w2k3s
external usenet poster
 
Posts: n/a
Default Convert Access Linked Tables from AccessBE to SQL

I am having a bit of trouble with figuring out some type of coding or
scripting that will cut the time for converting an Access Database BackEnd to
a SQL BackEnd.

I have a data-MDB that contains about 250 tables. I have converted and
upsized the tables to the SQL2000 Server.
I have approximately 87 module-MDBs that contain a random number(20-100) of
'table' links to the data-MDB. I wish to convert those to SQL-links.

I have already looked into using an AccessDataProject, but discounted that
notion since MDB/E files cannot link to ADPs. Eventually, this entire
application will be converted into a .NET/SQL format. But, that phase will
probably be 6 months down the road. Or more if SQL2005 proves to be viable.

For curiosity's sake, this is an accounting application that was designed by
an untold number of programmers vying for job security. I trimmed off nearly
100 unsued tables. And, so far, the coders apparently maintained the believe
that documentation was bad for the soul. So, I will be converting one module
at a time.

Any help would be very appreciated.

BC - in short - Help me point a linked-table object from Access to SQL2000.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
error with linked tables manager Wendy G Database Design 16 November 2nd, 2004 10:36 PM
Useless Access 2003 tired, angry, sucidial and bored General Discussion 10 July 21st, 2004 11:52 PM
Function isn't available in expressions in query expression Reiner Harmgardt General Discussion 4 July 21st, 2004 09:30 AM
Problem accessing SQL Server in upsizing wizard Edward General Discussion 1 July 5th, 2004 06:00 AM
Access 2000 .adp and SQL 2000 Wayne H. New Users 0 May 3rd, 2004 08:28 PM


All times are GMT +1. The time now is 09:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.