SQL instead of Access
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16790
Printed Date: 29 March 2026 at 8:45am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL instead of Access
Posted By: Kipp
Subject: SQL instead of Access
Date Posted: 03 October 2005 at 11:46pm
|
First I would like to say thanks, I have tried many other "free" asp apps out there and am kicking myself for not finding Web Wiz sooner...
Now the question...
I am having a hard time getting FP to work with access on GoDaddy. I can get SQL to work no problem. I have told it is a file permission problem with FP but I have no idea how to change it. I was told the FP will do it automaticly...if there is one thing I have learned about Microsoft it is that NOTHING is done automaticly AND right...
How hard would it be to make some of these access only apps work with sql, preferably the db I already have up?
Thanks in advance for all your assistance.
Kip
|
Replies:
Posted By: dpyers
Date Posted: 04 October 2005 at 5:02pm
|
MS SQL can import an access db. You might have to tweak a couple of column settings but it's prety straight forward. For WWF, there's a couple of how-to threads that go into the import in some detail. Haven't heard too much about godaddy hosting that's good. Do make sure you're on a windows plan and not a linux plan though. Linux can support FP, but not MS Access. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: clownfire
Date Posted: 24 December 2005 at 9:41am
|
Godaddy requires you to have your access dbs in a specific directory and you have to authorize the service in your control panel. Does anyone know much about to import from access to sql in godaddy, they don't use the enterprise mangler.
|
Posted By: Kipp
Date Posted: 24 December 2005 at 2:16pm
| You are not going to be able to use GO Daddy with Access if the app requires modify access on the folder, i.e. if the user will submit ANY data. I was told this is for security reasons. |
Posted By: clownfire
Date Posted: 24 December 2005 at 9:28pm
| This is wrong. I am using Access with Godaddy right now. You have to enable the service in your hosting control panel and then the dbs must be hosted in the access_db directory. |
Posted By: the boss
Date Posted: 17 January 2006 at 12:56pm
|
why in the world u want to use godaddy..?? there are better hosting companies out there in the same cost ------------- http://www.web2messenger.com/theboss"> 
|
Posted By: dpyers
Date Posted: 18 January 2006 at 2:12am
|
The OP was over 3 months ago. He's either settled in by now or long gone from godaddy.
-------------
Lead me not into temptation... I know the short cut, follow me. |