Access to SQL Server

I have almost finished a prototype system that I have developed in Access.
The idea now is to have the db (tables) run in SQL server with access to it
(ie the fe) in MS Access.
How would I go about porting the system to SQL Server or where could I find
out more.
The DB contains various forms and modules as well as some queries and report
s.
I realise this may not be the correct forum, but I am hoping that someone
may be able to assis as I am of desperate need of some help!
Thank you
KMHi KM
I think you can use linked tables in Access.
The tables give u a virtual feeling that SQL Server tables reside on the
Access databse
PLease let me know if u have any questions
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---
"KM" wrote:

> I have almost finished a prototype system that I have developed in Access.
> The idea now is to have the db (tables) run in SQL server with access to i
t
> (ie the fe) in MS Access.
> How would I go about porting the system to SQL Server or where could I fin
d
> out more.
> The DB contains various forms and modules as well as some queries and repo
rts.
> I realise this may not be the correct forum, but I am hoping that someone
> may be able to assis as I am of desperate need of some help!
> Thank you
> KM|||Hi,
I have no transactions set up. I understand they are quite simple to
program, and I assume that it wont matter to the 'transaction' where the
tables are?
cheers
"Chandra" wrote:
> Hi KM
> I think you can use linked tables in Access.
> The tables give u a virtual feeling that SQL Server tables reside on the
> Access databse
> PLease let me know if u have any questions
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://www.SQLResource.com/
> ---
>
> "KM" wrote:
>|||Check out "Microsoft Access Developer's Guide to SQL Server" by Mary Chipman
and Andy Baron (ISBN 0-672-31944-6) available at Amazon for about $10 used!
800 pages of how to get your Access database up and running on SQL Server.
Good Luck!
--
Todd
"KM" wrote:

> I have almost finished a prototype system that I have developed in Access.
> The idea now is to have the db (tables) run in SQL server with access to i
t
> (ie the fe) in MS Access.
> How would I go about porting the system to SQL Server or where could I fin
d
> out more.
> The DB contains various forms and modules as well as some queries and repo
rts.
> I realise this may not be the correct forum, but I am hoping that someone
> may be able to assis as I am of desperate need of some help!
> Thank you
> KM