Senin, 05 Agustus 2013

[MS_AccessPros] Using Access as frontend to Firebird or SQL Server Backend

 

Hi all,

I was just wondering about any limitations to using Access as a frontend to Firebird or SQL Server (express maybe) backend.
I think the boss wants me to learn VB or C# or Delphi but I was hoping that Access would still be suitable.
Database is about 2.6 GB, in Firebird currently, growing at about 600MB/Year.
On a Windows 2003 Server.
There would be about 70 or 80 users.
It will be a Production/Inventory/Sales program so a lot of users on 12hrs a day.
I was thinking of just using pass through queries and stored procedure calls so processing would be done by the server.
Am I right in saying that as long as every user has their own copy on their workstation then there wouldn't be a limit really to using Access as frontend?

Thanks,
Stu

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar