any computer geeks here sql server access asp ?

[83SanDimas]

Playing around with web enabling my databases

Anyone familiar with access and sql server

[illumina]

Re: any computer geeks here sql server access asp ?

ive used sql server and mysql for backends on projects before.

Personally, I prefer JSP/PHP frontends for MySQL queries... but what in particular are you looking for?

also, where are you on the Island? im by JFK

[SeventhSon]

Re: any computer geeks here sql server access asp

i'm sort of familiar. you'll need to use ADO from ASP to access SQL Server of Access.

[83SanDimas]

Re: any computer geeks here sql server access asp

Thanks guys

I am on the east end of LI the Brookhaven Southampton border. I have been using access for years (since 1.0)

I would like to get my mdb front end on my work station to connect to the mdb I just stuck up on godaddy. I am stuck there... That is step 1 of my master plan

Step 2 is to move to sql. I have tons of data

step 3 is to replace the front ent with an asp version. I was just looking at visual studio express and Visual web designer...

So... ever connect an access front end to an acess back end on the web?

What do you use for development, somthing like visual studio.net?

[SeventhSon]

Re: any computer geeks here sql server access asp

[ QUOTE ]

I would like to get my mdb front end on my work station to connect to the mdb I just stuck up on godaddy. I am stuck there... That is step 1 of my master plan


[/ QUOTE ]

IIRC, mdb front end talks to mdb by simply using the file system or any abstraction thereof. Which implies SMB protocol. Which is Microsoft's network file system protocol. It's what allows your MDB front end to access an MDB db on a share.

I highly doubt that godaddy.com will open up an SMB port for you. Too many security risks. They may allow you to VPN into their network and mount that share over SMB (My Network Places). Step 1 is basically a deal breaker from a security standpoint.

You're best bet is to bite the bullet and figure out how to write an ASP page to access your MDB db. Then deploy that puppy on godaddy.com.

[83SanDimas]

Re: any computer geeks here sql server access asp

thanks

I was sure access could be hosted on the web...

I just Started looking at.net

[SeventhSon]

Re: any computer geeks here sql server access asp

An access db CAN be hosted on the web. You just can't use the standard Access front end to view it. You have to go through some web server front end.