Converting backend to SQL

[Trevor Williams]

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

[Tony Toews]

"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

[Trevor Williams]

> 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

[Tony Toews]

"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