Upsizing to SQL 2000


D

Dan

I tryed to Upsize Access 2000 project to SQL 2000 DB with
Access front-end and it always fails. How can I upsize it?
 
Ad

Advertisements

T

Tony Toews

Dan said:
I tryed to Upsize Access 2000 project to SQL 2000 DB with
Access front-end and it always fails. How can I upsize it?
Do a search at the Knowledge Base at support.microsoft.com using the
keywords "upsizing" to review the various white papers on upsizing
Access to SQL Server as well as to ensure you have any updates
required.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft
Access Tips page at my website.

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
 
V

Van T. Dinh

I am confused!

Access 2K Project is only a Front-End that uses MS-SQL
Back-End. Why would you want to Upsize the Access 2K
Project (Front-End) to SQL 2000 DB?

Perhaps, you like to clarify what you are trying to do???

HTH
Van T. Dinh
MVP (Access)
 
D

Dan

-----Original Message-----
I am confused!

Access 2K Project is only a Front-End that uses MS-SQL
Back-End. Why would you want to Upsize the Access 2K
Project (Front-End) to SQL 2000 DB?

Perhaps, you like to clarify what you are trying to do???

HTH
Van T. Dinh
MVP (Access)
What I have is Access 2000 front-end and DB and I want to
get Access 2000 front-end that will work with SQL 2000 DB
which should be created from Access 2000 DB. I hope this
makes it understandible now.
 
Ad

Advertisements

V

Van T. Dinh

Aha ... The problem is that you use the term "Project" in the original post.
An Access Data Project (ADP) is different from an Access Database: an ADP
already uses an MS-SQL Server database as the back-end in the Client-Server
arrangement.

In you case, you have an Access Database as the Front-End and another one as
the Back-End.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upsizing to SQL 2
Upsizing to SQL 1
upsizing to sql 5
Upsizing Access 2000-SQL Server2005 6
Upsizing ACC 97 to SQL 2000 1
upsize to sql server 6
Help with SQL Upsize 0
Upsizing 2k3 mdb to SQL Server 2000 2

Top