The Various Forms of Access

[MikeRBS]

I'm having to write a review of Access and how it might appear on corporate infrastructure (desktops, file servers and application servers). I'm thinking of these:

Vanilla self-contained application with Jet - mdb on desktop/file server.

Front-end/back-end split - both mdbs.

Compiled application (Jet or ODBC based) - mde.

Project using MSDE - adp plus MS SQL Server on an application server or MSDE on the workstation. Does MSDE have distinguishing file extension(s)?

Data Access Pages - html files on file or web server.

Any other combinations you can think of?

 

[LittleSmudge]

.mdb back end on a server with .mde s distributed to users local machines.
( stops the users fiddling with the GUI )


Any thoughts of uping the scale a bit to
All Dbs on a central MySQL back end and then using Access .mdb or .mde as user front ends ?





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[MikeRBS]

Smudge

The context is there are thousands of users across many sites, and a new XP roll-out is being done which may be tighter on Access use. I'm trying to judge any impact. Part of this is to identify the different deployment signatures of Access.

As it happens, I had forgotten MySQL as something someone with developer capability might be able to get onto a server, so thanks for that.