Is it possible to switch a Microsoft Access Forms application to work with the reverse side of SQL?

Question

I was asked to provide an estimate for changing a relatively small application developed using MS Access to use an SQL database.

First, is this possible? I have never worked with Access, so I would like to know. If possible, can you point me to some tutorial websites about this?

Secondly: if possible, is it recommended? Is this a big success? Any specific actions / domains that you can and want to share?

Thanks in advance for your help.

Answer 1

SQL Server upsizing , . 5% 10% . SQL Server upsizing , 25-50 24x7 / .

. SQL Server Microsoft Access

SQL Server, SQL Server (SSMA Access), , .

Answer 2

Microsoft Access SQL Server Microsoft Access, " " (Tools | Database Utilities | Upsizing ).

SQL Server, SQL Server , , ( Queries in Access) .

, , , Access, , VBA , Access.

Answer 3

, Access SQL Server:

http://support.microsoft.com/kb/237980

, , ( ..), . , , . , .

, , . , SQL-. , , .

, .NET, , , .

Answer 4

(). Access , (, SQL Server), Access SQL Server.

, , . , (, 30). , , SQL Server. , , SQL Server , , ( Access).

.

Answer 5

- ... ( )

something like a big step towards sqlserver .... we kind of dodged it by going to the WAN replication service with AccessTables.com and staying with Access ... at least for now ..... Growth was just one problem. .. working with the web interface or terminal services was also part of it ...