dont want to use VB Script

  • Thread starter Thread starter G Ford
  • Start date Start date
G

G Ford

. Reply (E-mail) Forward (E-mail)

Subject: MS Access db, SQL, Internet/Intranet, VB Script
From: "G Ford" <[email protected]> Sent: 10/2/2003
8:54:48 AM




HELP!!!

I inherited what I thought was a simple MS Access db.
Wrong. The programmer used SQL commands for the
relationhips, users group, security etc...;
ASP pages coded with VB Script, instead of creating them
with MS Access for the input/output for the forms and
reports the the company's intranet/internet. There are
approx 45 users.

I run from VB Script like a bad plague. I am comfortable
with MS Access and Frontpage, and would have no problems
in designing the database to do exactly what it is doing
now. Any reasons why I should not make these changes?

In the event, the answer is my worst nightmare, and it is
not a good idea, I could brush up on my SQL commands, but
would love to do without the VB Script. Also, this
programmer left no documentation or comments.

Thank you in advance for your advice.
 
ASP pages coded with VB Script,
instead of creating them with MS
Access for the input/output for the
forms and reports the the company's
intranet/internet. There are
approx 45 users.
Click to expand...

If all these 45 users are on a LAN running at 10MBPS or higher, then you may
be able to just create a multiuser Access application. I caution that if you
double that number of users, you'd have to have just about every factor as
near perfect as possible to expect adequate performance -- and, in my
experience, I've never seen a user base not grow more than originally
expected.
I run from VB Script like a bad plague.
I am comfortable with MS Access and
Frontpage, and would have no problems
in designing the database to do exactly
what it is doing now. Any reasons why
I should not make these changes?
Click to expand...

I'm not sure what you have in mind for Access and Front Page. Front Page
2002 and 2003 has the Data Interaction Wizard which will allow you to do
simple updates, and I stress _simple_. The DIW, just FYI, creates .asp
pages.

But if you are thinking of a multiuser application on the LAN, Front Page
wouldn't be involved.

Another option... stick to Access 2002 or 2003 for this, would be to look
into creating Data Access Pages with Access... that can work in an intranet
environment, where all users are using Internet Explorer 5.5 or later as
their browser. Again, because it is a web application, you can't make as
rich a user interface as you can with regular Access.
In the event, the answer is my worst night-
mare, and it is not a good idea, I could brush
up on my SQL commands, but would love
to do without the VB Script. Also, this
programmer left no documentation or comments.
Click to expand...

With .asp pages, you can use vbscript or javascript. I don't know any other
choices. If the application is undocumented, it would seem to me that you,
or someone, is going to have to know enough vbscript to be able to read it
to determine the details of what it actually does, given that there's no
documentation or comments.

Larry Linson
Microsoft Access MVP
 
Back
Top