Re: web form getting data to SQL Backend

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I created our DB in Access and a few years back split it to a FE/BE Access DB.
Now I am having record issues due to the size of the DB. I already cannot
create as many Primary Key's as my tables need (notes table has over 2M
records so I have to archive records every 30 days). So I split the DB to a
Access FE/SQL 08 BE.

I have the DB all working correctly so that the Access FE talks to the SQL 08
BE in all aspects; however, our old IT guy that is no longer here setup a
webpage that would dump leads into an Access DB that would append to my BE DB.


Now that the BE is in SQL 08 I cannot append directly from the website
anymore which would be ok except that we search the DB for duplicate values
prior to allowing the append.

The webpage is sent directly to vendors and not something that we really
publish; however, I am concearned that you think it may make my DB vunerable.

Ultimately I would like there to be a simple web form with about 10 fields
that a vendor can post to that will append directly to my SQL DB and check
for duplicates prior to the append.

Thanks in advance for your help.

Sylvain Lafontaine wrote:
First, if this is for a web page, you should ask to a newsgroup dedicated to
ASP (Classic or .NET) or to ADO or to OLEDB; as ADP has nothing to do with
this. For a description of the connection strings for SQL-Server, see:

http://www.connectionstrings.com/
http://www.carlprothman.net/Default.aspx?tabid=81

You don't say which version of SQL-Server you have, so I cannot tell you
which one is probably the best. The first thing to do would be obviously to
check that you can connect to the server and spit out some information.

Finally, for a web page, your code looks particularly sensible to SQL
injection attack. I would correct that part if I were you.

I had a split DB with a front and BE in Access. I am converting the BE to
SQL because of the size and number of users. I have all the conversion
[quoted text clipped - 56 lines]

Any ideas why?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200810/1

.

Relevant Pages

  • Re: Designing a counter
    ... To do that you could use an update query instead of the ... 'Now append the new record ... lngMaxCount into the SQL correctly. ...
    (microsoft.public.access.formscoding)
  • Re: Identity_Insert wont turn off
    ... I think that the cached connection is the problem. ... We did our upgrades using DTS or the Access upgrade ... I think that you could create your append queries in SQL ...
    (microsoft.public.access.externaldata)
  • Re: append multiple tables
    ... I suggest you first write a sample query that appends a row with fixed ... These must be placed into the SQL genereated in code. ... A single simple append query and no VBA codeing would probably result. ... >> Tom Ellison ...
    (microsoft.public.access.queries)
  • Re: Editing Existing records
    ... one way to do this would be to use code to loop through the dates and append a record or records to the underlying table using SQL ... dim mDate as date _ ... If an activity lasts more than one day, I want the record details to copy to the next date for as long as the activity lasts. ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL Connection with .udl and domain accounts
    ... work because it's not recognised by SQL-Server as a valid User Id. ... difference between a SQL account and a domain account. ... Login account using a SQL Login name and password that will ...
    (microsoft.public.sqlserver.connect)