change access database to SQL

[f123 via AccessMonster.com]

is there any way to change a database done on access to SQL??

 

[Jeff Boyce]

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]

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

 

[Douglas J. Steele]

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.

 

[Jeff Boyce]

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.