By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 1,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

Converting backend to SQL

P: n/a
I have a split application for which a client requires us to provide the
backend in SQL format.

Both front and backends are currently Access. The frontend can stay as
Access so it is just the backend which needs sorting.

How easy is this going to be?

What steps are involved?

TIA
Trevor
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Trevor Williams" <tr****@NOSPAM.co.uk> wrote:
I have a split application for which a client requires us to provide the
backend in SQL format.

Both front and backends are currently Access. The frontend can stay as
Access so it is just the backend which needs sorting.

How easy is this going to be?


Could be a fair bit of work.

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
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 #2

P: n/a
> 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 http://www.granite.ab.ca/access/sqlserverupsizing.htm

Tony


Do you know if the Access 97 Upsizing tool convert to SQL Server Desktop or
is simply to full versions of SQL?

Is their a cheap option where I can test how to upsize my application
without purchasing SQL?

Can an Access 97 frontend connect to an upsized SQL backend?

Thanks
Nov 13 '05 #3

P: n/a
"Trevor Williams" <tr****@NOSPAM.co.uk> wrote:
Do you know if the Access 97 Upsizing tool convert to SQL Server Desktop or
is simply to full versions of SQL?
FWIW A2000 does a better job of integrating with SQL Server than A97.

The differences between MSDE and SQL Server are maximum allowed size of a database
file at 2 Gb and maximum five processes. This is not the same as five users.
Is their a cheap option where I can test how to upsize my application
without purchasing SQL?
SQL Server Developer Tools - $50US.
Can an Access 97 frontend connect to an upsized SQL backend?


Yes, via ODBC.

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

This discussion thread is closed

Replies have been disabled for this discussion.