Access and SQL Server Books - Microsoft Access / VBA

amazo

Dear all,

I am planning to move my Access databases to SQL Server and still
using Access as Front-End.

I did a search on Amazon.com to buy a book but the list is so huge
that I can't distinguish what would be better.

I would appreciate your wise about.

Regards.

Angel.

Nov 13 '05 #1

Subscribe Post Reply

1366

Van T. Dinh

1. Microsoft Access Developer's Guide to SQL Server by Mary Chipman & Andy
Baron published by SAMS.

2. Professional SQL Server Developments with Access by Rick Dobson published
by WROX.

--
HTH
Van T. Dinh
MVP (Access)

"amazo" <am***@pobladores.com> wrote in message
news:4c**************************@posting.google.c om...

Dear all,

I am planning to move my Access databases to SQL Server and still
using Access as Front-End.

I did a search on Amazon.com to buy a book but the list is so huge
that I can't distinguish what would be better.

I would appreciate your wise about.

Regards.

Angel.

Nov 13 '05 #2

Tony Toews

"Van T. Dinh" <Va***********@discussions.microsoft.com> wrote:

1. Microsoft Access Developer's Guide to SQL Server by Mary Chipman & Andy
Baron published by SAMS.

2. Professional SQL Server Developments with Access by Rick Dobson published
by WROX.

Agreed.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 13 '05 #3

Tony Toews

am***@pobladores.com (amazo) wrote:

I am planning to move my Access databases to SQL Server and still
using Access as Front-End.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft Access Tips page at
http://www.granite.ab.ca/access/sqlserverupsizing.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 13 '05 #4

John Winterbottom

"amazo" <am***@pobladores.com> wrote in message
news:4c**************************@posting.google.c om...

Dear all,

I am planning to move my Access databases to SQL Server and still
using Access as Front-End.

I did a search on Amazon.com to buy a book but the list is so huge
that I can't distinguish what would be better.

For the Access side of things look at the Access Developers Handbook Vol II.
For the SQL Server side of things there are two; Inside Microsoft SQL Server
2000 by Kalen Delaney for SQL Server internals, and The Guru's Guide to
Transact-SQL
by Ken Henderson for T-SQL programming.

Nov 13 '05 #5

amazo

Thank you very much and also to Tony Toews.

Regards.

Angel.

"Van T. Dinh" <Va***********@discussions.microsoft.com> wrote in message news:<#1**************@TK2MSFTNGP11.phx.gbl>...

1. Microsoft Access Developer's Guide to SQL Server by Mary Chipman & Andy
Baron published by SAMS.

2. Professional SQL Server Developments with Access by Rick Dobson published
by WROX.

--
HTH
Van T. Dinh
MVP (Access)

"amazo" <am***@pobladores.com> wrote in message
news:4c**************************@posting.google.c om...
Dear all,

I am planning to move my Access databases to SQL Server and still
using Access as Front-End.

I did a search on Amazon.com to buy a book but the list is so huge
that I can't distinguish what would be better.

I would appreciate your wise about.

Regards.

Angel.

Nov 13 '05 #6

Similar topics

ASP link back to Access database

by: TrvlOrm | last post by:

I am having great difficulty in these asp scripts, using VBscript and JavaScript. I have 4 files that all need to be linked together. The first file "Books.html" - needs to search for a Book...

Javascript

Future of access?

by: John | last post by:

Hi What future does access have after the release of vs 2005/sql 2005? MS doesn't seem to have done anything major with access lately and presumably hoping that everyone migrates to vs/sql. ...

Microsoft Access / VBA

SQL Server 2K Linked Access 97 Server not working

by: David Kirkman | last post by:

An Access 97 linked server in SQL Server 2K has recently stopped working. In Enterprise Manager, the following error message appears when attempting to view the list of tables in the linked server:...

Microsoft SQL Server

What is Your Strategy for Upgrade an Access db to SQL Server 2000?

by: NickName | last post by:

This question probably has been asked many a time. And yet I feel it is still relevant for one thing a search on this NG does not produce a desirable answer. It is kind of disappointing that MS...

Microsoft SQL Server

Replace Access with a .NET front end and SQL Backend solution.

by: Anns via SQLMonster.com | last post by:

My company currently has about 20-25 Ms Access Database that they want to replace the FE with .net and the BE on SQL. This will be done using Visual Studio 2005. Once the FE is converted to...

Microsoft SQL Server

MS Access Reports and VB.NET Program

by: JoeW | last post by:

I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report,...

Visual Basic .NET

Using DTS to migrate Access ot SQL Server

by: Wes Groleau | last post by:

When I try to import from Access, the DTS wizard only allows me to import tables and queries. OK, I'm not surprised the "macros" and reports don't come over. But it executes each query, and...

Microsoft SQL Server

Pass through query from MS Access

by: gumby | last post by:

I would like to call this stored procedure, but I am unable to pass parameters to the @Start and @End. Is thier a way to pass parameters to a pass through query from MS Access? SELECT ...

Microsoft SQL Server

Access 2000 and SQL Server 2005

by: JA | last post by:

Is it possible to connect to Sql Server 2005 using an Access 2000 adp? I keep trying, but it doesn't want to accept my id, even though it is right.

Microsoft SQL Server

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing