Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC Question

Status
Not open for further replies.

markphsd

Programmer
Jun 24, 2002
758
US
Hi,

I'm considering moving my database from access to sql server.

I have several databases that the FE/GUI links to. Some are local based and some are on a server.

When I move to SQL server, can I keep this same structure, and use multiple odbc files to connect all of the databases? Or is there a better method.

I think I would prefer to keep separate databases for information. Rather then write procedures to upgrade the database, sometimes it's easier to just distribute a new one.

-Mark

Mark P.
Providing Low Cost Powerful Point of Sale Solutions.
 
Yes you can keep the same structure. But, when you create your links to the tables, create a File DSN rather than a System or User DSN. That way you don't have to set up the DSN on each of your users' machines.
 
If you would like to take smaller steps to transitioning over to SQL Server and try some things out you could create a second Access db that holds all of the data and create linked tables. That would show you how the it would work as a separated FE/BE model.

My 2 cents,
Richard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top