|
|
 |
|
 |
|
On Fri, 15 May 2009 12:31:26 -0400, "Arvin Meyer MVP" <...@mvps.invalid
If you want portability, SQL-Express is not the best choice, but it is if
you need security, and especially if you are running on a web server. Using
any version of Access an MDB front-end will allow the greatest flexibility
with either a JET or SQL backend. All your familiar functionality will work.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
<...@v17g2000vbb.googlegroups.com...
|
|
 |
|
 |
|
|
|
|
On Fri, 15 May 2009 10:59:14 -0600, John W. Vinson <...@STOP_SPAM.WysardOfInfo.com
Should work fine.
Available, and in fact recommended. ADO is still available but it's on the
marked-down remainders table <g
I use them routinely. However, whatever the backend, your best bet is to base
the form on a recordset which retrieves the minimum number of records. Rather
than binding the form to the entire table, use a query returning just the one
record the user wants to see, or (if they're adding new data) no records at
all.
Works fine, the only problem is that there aren't many database management
tools "out of the box". You can get SQL Server Management Studio Express for
free to manage the backend. Access makes a great report generator and
frontend; Reporting Services is an option as well, I'm more familiar with
Access.
John W. Vinson [MVP]
|
|
|
|
|
|
|
|
|
On Fri, 15 May 2009 20:50:53 GMT, "Tony Toews [MVP]" <...@telusplanet.net
Great
Very much so and is recommended.
Definitely bound,.
Less work and more work.
That'll work. It helps to have expertise in it which you appear to have. Using an
MDB for data is simpler and reduces the learning curve of course. But not as good
in other respects as I'm sure you well know.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
|
|
|
|
|
|
|
|
|
On Fri, 15 May 2009 14:36:56 -0700, Armen Stein <...@R3m00v3Th1s.gmail.com
On Fri, 15 May 2009 04:40:31 -0700 (PDT), tedd...@hotmail.com
wrote:
Hi Edward,
We've built many of these types of applications, up to 60-100
simultaneous users and complex databases over 150 tables. It's a
great approach if you follow some basic guidelines.
I've written a slideshow on techniques for using Access as a
client-server front-end to SQL Server databases. It's called "Best of
Both Worlds" at http://www.JStreetTech.com/Downloads. It includes some
thoughts on when to use SQL Server, performance and security
considerations, concurrency approaches, and techniques to help
everything run smoothly.
Armen Stein
Microsoft Access MVP
http://www.JStreetTech.com
|
|
|
|
|
|
|
|
|
On Sun, 17 May 2009 12:40:05 +0200, "marie dubois" <...@microsoft.com
tageule
<...@v17g2000vbb.googlegroups.com...
|
|
|
|
|
|
|