473,320 Members | 1,904 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Remotely managing Access2K

Because of licensing reasons, I plan on using ASP.NET 3.5 /Access 2K
for a specific site..

What tools could I use to remotely manage the Access 2K DB? Would a
simple ODBC connection be adequate? I read some posts warning against
ADP, (plus I don't want to re-write extra code.). If ODBC is ok, I
presume the remote DB could be managed via a local client
application. Are there any networking issues to be aware of which
possibly could play havoc? Thanks for any pointers.
Jun 27 '08 #1
12 1208
"helveticus" <ms******@gmail.comwrote in message
news:22**********************************@m36g2000 hse.googlegroups.com...
Because of licensing reasons, I plan on using ASP.NET 3.5 /Access 2K
for a specific site..

What tools could I use to remotely manage the Access 2K DB? Would a
simple ODBC connection be adequate? I read some posts warning against
ADP, (plus I don't want to re-write extra code.). If ODBC is ok, I
presume the remote DB could be managed via a local client
application. Are there any networking issues to be aware of which
possibly could play havoc? Thanks for any pointers.
First things first: mainstream support for Access 2000 was retired almost
two years ago. Although the product is currently under extended support,
this is also set to end next year, after which you will be on your own if
anything happens. In addition, an extended support contract is extremely
expensive - you do have one, don't you...?

Secondly, ODBC is very old technology these days, having been superseded by
OleDb many years ago. What do you mean by "remotely manage"? Is it just
data, or will you be modifying the database schema, taking backups etc...?

Thirdly, the Jet engine is not really suitable for web applications,
especially those with lots of concurrent connections:
http://en.wikipedia.org/wiki/Microso...atabase_Engine

Is there any reason that you can't use SQL Server Express Edition?
http://msdn.microsoft.com/en-us/express/aa718378.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jun 27 '08 #2
Thanks for the reply. I have been working with A2K and SQL Express,
using A2K as the front-end. However, I find nothing beats Access for
designing front-end applications in short notice.

In the present case, I would like to capitalize on the DB manager I
wrote in A2K. It allows me to do basic CRUD operations on all relevant
SQL Express tables (no database schema modifications) plus specific
processing. I don't want to replicate this work in the web's Admin
section. Ideally, the info should be download/uploaded and processed
locally. Assuming I upgrade to ACC2003/ACC2007, would this kind of
"remote DB management" be possible via OleDB for instance? TIA.

Jun 27 '08 #3
"helveticus" <ms******@gmail.comwrote in message
news:51**********************************@34g2000h sf.googlegroups.com...
Thanks for the reply. I have been working with A2K and SQL Express,
using A2K as the front-end. However, I find nothing beats Access for
designing front-end applications in short notice.
Er, OK... I'm puzzled as to why you would want to use Access as a front-end
to SQL Server Express when it has its own:
http://www.microsoft.com/downloads/d...displaylang=en
In the present case, I would like to capitalize on the DB manager I
wrote in A2K. It allows me to do basic CRUD operations on all relevant
SQL Express tables (no database schema modifications) plus specific
processing.
Er, so are you now saying that the RDBMS you're using is SQL Server
Express...? If so, I can't understand what you need Access for...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jun 27 '08 #4
My guess the guy has written te whole application in MS Access. And links
SQL Express tables from MS Access..
Which is OK.

Just use SQL Express from your ASP.NET application and continue to use MS
Access as a front end for desktop users
Do not use ASP.NET in way so it's hitting MS Access linked tables. There is
no really point in that (except having problems :)

George.
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
"helveticus" <ms******@gmail.comwrote in message
news:51**********************************@34g2000h sf.googlegroups.com...
>Thanks for the reply. I have been working with A2K and SQL Express,
using A2K as the front-end. However, I find nothing beats Access for
designing front-end applications in short notice.

Er, OK... I'm puzzled as to why you would want to use Access as a
front-end to SQL Server Express when it has its own:
http://www.microsoft.com/downloads/d...displaylang=en
>In the present case, I would like to capitalize on the DB manager I
wrote in A2K. It allows me to do basic CRUD operations on all relevant
SQL Express tables (no database schema modifications) plus specific
processing.

Er, so are you now saying that the RDBMS you're using is SQL Server
Express...? If so, I can't understand what you need Access for...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jun 27 '08 #5
Thanks for both replies.

George got the point: I am linking up via ODBC to SQL Express tables
and would like to keeping doing so even when the DB is moved over to a
ISP host. This works fine on my local machine and was hoping that this
kind of setup would also work in such a remote configuration.

Could you please elaborate on " Do not use ASP.NET in way so it's
hitting MS Access linked tables." ? Does this refer to locking, etc.?
TIA
Jun 27 '08 #6
"helveticus" <ms******@gmail.comwrote in message
news:83**********************************@m73g2000 hsh.googlegroups.com...
I am linking up via ODBC to SQL Express tables
So, what did you mean in your OP by "What tools could I use to remotely
manage the Access 2K DB?"
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jun 27 '08 #7
Thanks. Let me rephrase the question then. My original idea was to use
A2K as a back-end on the site to avoid SQL Server charges. It seems
however that one cannot use an ODBC connection to link up to a remote
JET backend database file such as A2K, since it is not a socket based
system accessible via TCP/IP. Furthermore, as you pointed out, using
A2K as a DB would be risky since MS has dropped the product.

From the posts I have read, I have come to the conclusion that the
best approach would be to use SQL Server on the site, link up to this
DB via ODBC from a local Access front-end client to "manage" tables
(ie. simple edit/insert/delete, no schema alteration). For "heavy
artillery" operations, I would use SQL Server Management.

Is ODBC reliable? Some posts suggest that ODBC are vulnerable to
connection break ups, etc
Jun 27 '08 #8
"helveticus" <ms******@gmail.comwrote in message
news:be**********************************@34g2000h sh.googlegroups.com...
My original idea was to use A2K as a back-end on the site to avoid
SQL Server charges.
SQL Server Express Edition is *completely* free.
From the posts I have read, I have come to the conclusion that the
best approach would be to use SQL Server on the site, link up to this
DB via ODBC from a local Access front-end client to "manage" tables
(ie. simple edit/insert/delete, no schema alteration). For "heavy
artillery" operations, I would use SQL Server Management.
As I have already mentioned, SQL Server Express Edition already has its own
management software, so there's really no need to use anything else to
manage it. That's what it's for...
Is ODBC reliable? Some posts suggest that ODBC are vulnerable to
connection break ups, etc
If you use SQL Server Express Management then you don't need to worry about
ODBC at all...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jun 27 '08 #9

Yeah dude (to the OP).

Please heed this advice. The sooner you make the break and better off you
will be.

Sql Server Express Edition is FREE.

Scratching your back by putting your arm between your legs is the equivalent
of trying to use ODBC/Access.

I'm not trying to be mean, just trying to firmly let you know that it would
be much wiser to heed this advice.

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:%2***************@TK2MSFTNGP02.phx.gbl...
"helveticus" <ms******@gmail.comwrote in message
news:be**********************************@34g2000h sh.googlegroups.com...
>My original idea was to use A2K as a back-end on the site to avoid
SQL Server charges.

SQL Server Express Edition is *completely* free.
>From the posts I have read, I have come to the conclusion that the
best approach would be to use SQL Server on the site, link up to this
DB via ODBC from a local Access front-end client to "manage" tables
(ie. simple edit/insert/delete, no schema alteration). For "heavy
artillery" operations, I would use SQL Server Management.

As I have already mentioned, SQL Server Express Edition already has its
own management software, so there's really no need to use anything else to
manage it. That's what it's for...
>Is ODBC reliable? Some posts suggest that ODBC are vulnerable to
connection break ups, etc

If you use SQL Server Express Management then you don't need to worry
about ODBC at all...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jun 27 '08 #10
I meant hit SQL Express DB directly from your .NET application.
do not hit your MS Access mdb file which has only linked tables.

There is no problem with ODBC working over network whatsoever. Then only
thing it's as reliable as network is. So may be it's not good idea to run it
over wireless network,,,
George.
"helveticus" <ms******@gmail.comwrote in message
news:83**********************************@m73g2000 hsh.googlegroups.com...
Thanks for both replies.

George got the point: I am linking up via ODBC to SQL Express tables
and would like to keeping doing so even when the DB is moved over to a
ISP host. This works fine on my local machine and was hoping that this
kind of setup would also work in such a remote configuration.

Could you please elaborate on " Do not use ASP.NET in way so it's
hitting MS Access linked tables." ? Does this refer to locking, etc.?
TIA

Jun 27 '08 #11
My guess it's not management aka (creating tables, backing up....)
It's management in terms of an applicaiton that updates tables, insert
records and does all kind of business logic needed to be done when something
happens...
The Sql's managment software does not do all that...

PS: I do find MS Acceess the best tool to quickly create a nice application
with reports and such..

George.

"sloan" <sl***@ipass.netwrote in message
news:eQ**************@TK2MSFTNGP03.phx.gbl...
>
Yeah dude (to the OP).

Please heed this advice. The sooner you make the break and better off you
will be.

Sql Server Express Edition is FREE.

Scratching your back by putting your arm between your legs is the
equivalent of trying to use ODBC/Access.

I'm not trying to be mean, just trying to firmly let you know that it
would be much wiser to heed this advice.

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:%2***************@TK2MSFTNGP02.phx.gbl...
>"helveticus" <ms******@gmail.comwrote in message
news:be**********************************@34g2000 hsh.googlegroups.com...
>>My original idea was to use A2K as a back-end on the site to avoid
SQL Server charges.

SQL Server Express Edition is *completely* free.
>>From the posts I have read, I have come to the conclusion that the
best approach would be to use SQL Server on the site, link up to this
DB via ODBC from a local Access front-end client to "manage" tables
(ie. simple edit/insert/delete, no schema alteration). For "heavy
artillery" operations, I would use SQL Server Management.

As I have already mentioned, SQL Server Express Edition already has its
own management software, so there's really no need to use anything else
to manage it. That's what it's for...
>>Is ODBC reliable? Some posts suggest that ODBC are vulnerable to
connection break ups, etc

If you use SQL Server Express Management then you don't need to worry
about ODBC at all...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net


Jun 27 '08 #12
"George Ter-Saakov" <gt****@cardone.comwrote in message
news:%2***************@TK2MSFTNGP06.phx.gbl...
My guess it's not management aka (creating tables, backing up....)
It's management in terms of an applicaiton that updates tables, insert
records and does all kind of business logic needed to be done when
something happens...
The Sql's managment software does not do all that...
Do you mean things like triggers, stored procedures, exception handling, CLR
& .NET integration, UDTs, native XML, XQuery etc...?
PS: I do find MS Acceess the best tool to quickly create a nice
application with reports and such..
Me too. For the desktop. But Access is totally unsuited to this sort of web
usage. For one thing, you'd need to restrict any queries to
SQL-pass-through, otherwise Access will bring the entire superset of tables
included in the query across the wire to the desktop so that the Jet engine
can process them
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jun 27 '08 #13

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

Similar topics

0
by: Lauren Quantrell | last post by:
I'm hoping someone can tell me if I'm doing the correct thing here or if there is a better way to do this with Access2K connecting to SQL Server 2K: Dim myConn As String myConn =...
1
by: Lauren Quantrell | last post by:
In an Insert Into statement I have used the Host_Name() function to identify which user has suppied a record to a table that holds temporary data. I'm using an Access2K front end. Code: Alter...
10
by: Blake | last post by:
I have created an Access2K front end application that connects to a SQLServer2K backend. I use this vba code to create the connection from the Access app: Dim strConnect As String 'make sure...
0
by: Lauren Quantrell | last post by:
I'm trying to drop a file from Windows Explorer (or desktop, etc.) onto a field in Access2K and capture the full file path. I found an posting below that says this is possible but I cannot...
3
by: TWJohnson | last post by:
Can anyone tell me how to run the Access2k wizards from code in the Runtime enviroment? I need to do Address labels..perhaps there is another way to approach to this besides the wizards. Can anyone...
0
by: Lauren Quantrell | last post by:
I'm hoping someone can tell me if I'm doing the correct thing here or if there is a better way to do this with Access2K connecting to SQL Server 2K: Dim myConn As String myConn =...
2
by: PhilTheGap | last post by:
Hi, Is Web Site Administration Tool able to manage web applications remotely? By the way, can we start the WSAT without VS 2008 ? Best regards Philippe
6
by: Jonathan Wood | last post by:
The ASP.NET Configuration tool is great for quickly managing users in the database on my development machine. However, I don't see a way to use it to access the database on my Web server. Is...
12
by: helveticus | last post by:
I'm in the process of finalizing my site. I spent quite a bit of time designing content pages and would like to cut on development time by simply managing the DB (SQL server, evt. MySQL) via MS...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.