Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

change access database to SQL

0 views
Skip to first unread message

f123 via AccessMonster.com

unread,
Dec 11, 2009, 2:18:38 PM12/11/09
to
is there any way to change a database done on access to SQL??

--
Message posted via http://www.accessmonster.com

Jeff Boyce

unread,
Dec 11, 2009, 2:43:43 PM12/11/09
to
Define "change"...

I've migrated tables of data from Access to SQL-Server ... and then modified
the Access application to deal with the data in the new location.

What do you mean?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"f123 via AccessMonster.com" <u50920@uwe> wrote in message
news:a0710f108f948@uwe...

f123 via AccessMonster.com

unread,
Dec 12, 2009, 2:14:45 AM12/12/09
to
i just finish one project on access database, by lunching this one on the
ntwork we are facing a lot of problems
the advice i got is to use do the program as SQL not as an access

so am sking if there is any way i can just change all the forms to be as SQL

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200912/1

Douglas J. Steele

unread,
Dec 12, 2009, 1:22:26 PM12/12/09
to
Assuming that by "SQL", you mean SQL Server, be aware that SQL Server is
strictly a database: it has no user interface.

You can put your data in tables in SQL Server, but you still need to build a
user interface to that data, and Access is perfect for that.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"f123 via AccessMonster.com" <u50920@uwe> wrote in message

news:a0774fb96d915@uwe...

Jeff Boyce

unread,
Dec 14, 2009, 11:16:20 AM12/14/09
to
You mention "problems", but not described them.

If you'd like folks here to offer ideas, please provide more information...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"f123 via AccessMonster.com" <u50920@uwe> wrote in message

news:a0774fb96d915@uwe...

0 new messages