472,373 Members | 1,911 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,373 software developers and data experts.

Access version recommendations?

I have been working for a couple of months now with an old access 97
database. I have managed to make necessary adjustments but its been at
times a struggle.

I have now been commissioned to construct an entirely new database and
I would wish this to be as 'all singing and dancing' as possible and
almost definitely have a web based front end.

Question is what version of Access am I best to update to to best do
this? Am I correct in my belief that Access XP has substantial links to
frontpage XP? Anyone any experience in using this? (Also if it became
necessary to copy customer records from the 97 DB is this possible to
the later versions?)

Also am I correct in thinking that accessing an access DB through a
webfront end can be done through any machine and not just one with
access or the correct version of access on it? (thinking of website
connectivity here).

Or would people recommend moving away from access altogether? Your
opinion is very much appreciated!

DDiver

Nov 13 '05 #1
3 1398
Here Alan goes again. Some versions of Access are better than others.
Someone else here has suggested that the better versions alternate with the
worse versions. I liked 97, so based on that, 2000 would stink, 2002 would
be better, 2003 may stink. I own 97, 2000 and 2002. I stopped doing
commercial work just before the release of 2002 so my opinion of anything
after 2000 has limited credibility. The stuff I've done since would work
fine in Access 2 so I don't sweat Access XP hard enough to see its flaws. I
like the bells & whistles that come with MSDE & SQL Server enough that my
preffered DBMS is SQL Server and not Jet. I never got far enough with
FrontPage to learn how to do decent database connected web sites that work
as nice as I want them to so I'll not offer an opinion there. Good luck.

--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS
<dd*****@yahoo.co.uk> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I have been working for a couple of months now with an old access 97
database. I have managed to make necessary adjustments but its been at
times a struggle.

I have now been commissioned to construct an entirely new database and
I would wish this to be as 'all singing and dancing' as possible and
almost definitely have a web based front end.

Question is what version of Access am I best to update to to best do
this? Am I correct in my belief that Access XP has substantial links to
frontpage XP? Anyone any experience in using this? (Also if it became
necessary to copy customer records from the 97 DB is this possible to
the later versions?)

Also am I correct in thinking that accessing an access DB through a
webfront end can be done through any machine and not just one with
access or the correct version of access on it? (thinking of website
connectivity here).

Or would people recommend moving away from access altogether? Your
opinion is very much appreciated!

DDiver

Nov 13 '05 #2
"Alan Webb" <kn*****@hotmail.com> wrote in
news:p-********************@comcast.com:
I never got far enough with FrontPage to learn how to do decent
database connected web sites that work as nice as I want them ...


Has anyone?

--
Lyle
--
Nov 13 '05 #3
If you use Server side scripting\ASP then the client machines do not
need to have any version of Access at all. There are other things to
take into consideration as well, such as security and processing power
of the computer that will be serving up the wep pages and how many
people will be accessing the database through the web pages
simultaniously. Using Access 2003, you can create web pages, but I
prefer to use APS in the Visual Studio InterDev environment and
Microsoft Publisher 2003, (don't know if that is an option for you).
Using ASP, the backend just becomes a database file that holds the data
and the work is done by the ASP page, so it really would not matter
which version of Access you use except from the point of which driver
to use to create the database connection.

Hope this helps.
David Hodgkins, MCSD, MCDBA, MCSE
www.jstarsoftware.com - Home of AutoCompact for Access Databases

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Squirrel | last post by:
I've developed an Access 2002 database which will be deployed with the backend on a server and frontend on the users' PCs. I've now been advised that new employees will be given laptops with...
0
by: HelenD | last post by:
Last night took the plunge and upgraded to Office 2003 pro, and told it to get rid of 2000. Realized too late that some programs (such as FMS Develper Suite) do not yet include the components to...
4
by: Bruce | last post by:
I am developing an ASP.NET web service application. It works fine on my WinXP Prof development machine. But when I send it to a Windows Server 2003 system I get the following error (attached...
7
by: Allison | last post by:
Hi -- we are a small manufacturing looking for a multi-user database to take customer orders (nothing too complicated, with 3 users total). We think we should be using Access, but are wondering...
5
by: Lyle Fairfield | last post by:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/callnetfrcom.asp The Joy of Interoperability Sometimes a revolution in programming forces you to abandon all...
9
by: Algonquin J. Calhoun | last post by:
I've developed an application that exceeds the Access 2GB limit. This application was developed as a prototype and the users have found it very useful. Approximately 45,000 records are added to...
7
by: AkosBeres | last post by:
I’m in the process of setting a sample local Access table called "Fruits" to store data in the following sample fileds: Week Amount Description Version or sequence The data will be loaded into...
9
by: Don | last post by:
I've continued to use Access 97 all these years because (1) it does everything I need quickly and (2) most of what I've read online indicates that it's still the most bug-free version of Access. ...
14
by: xander.grespesky | last post by:
hi all, I'm looking for recommendations for unix "shell access" services that provide a c++ compiler (gcc or intel). free would be preferable. basically i'm looking at testing out some...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
1
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
0
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.
0
DizelArs
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.