Re: Access front-end to SQL back-end
- From: JPD <nospam@xxxxxxxxxxxxxxxx>
- Date: Thu, 19 Jul 2007 11:14:26 +0100
Hi,
What you need to do is migrate your database from whatever RDBMS you are using to SQL Server. That means transferring the structure of your database as well as the data. I don't know what RDBMS you are using so I can't give you detailed instruction on how to do it. Essentially you need to put your existing RDBMS out of service in favor of SQL Server. So you can't link the exsiting "tables into SQL Server". You have to transfer them completely.
A number tools exist for transferring data to SQL Server including bcp, and DTS/SSIS.
Jonathan
mssbass wrote:
I'm new to SQL Server 2000. I decided to purchase this server because.
my old company (UPS) used the server to help expedite queries and
manage on-line reporting. So, now it's up to me to utilize and
understand the new server. I have been using MS Access as my front-
end for several ad-hoc databases, so I'd like to keep utilizing this
method. I want to test my first database using the SQL Server.
I've got everything set up. The IT department has installed the
server software on my computer. Within my Access database, I link in
tables from a database called "Progress" using a Merant driver.
Queries, forms, macros and modules are all pulling from these "linked"
tables. Do I need to link these tables into the SQL Server? How do I
transistion this database over to SQL? I guess I'm confused about the
relationship of how all of this should work.
Right now it looks like this:
PROGRESS ..... linked....... MS Access ....... reporting/results
Where does SQL fit in?
- Prev by Date: Re: Default protocols ..
- Next by Date: Cannot connect to SQL Server
- Previous by thread: sql 2005 connection string question
- Next by thread: Cannot connect to SQL Server
- Index(es):
Relevant Pages
|
Loading
