Skip to main content
V
VagJim22
Participant
March 26, 2008
Question

MySQL

  • March 26, 2008
  • 2 replies
  • 933 views
I am trying to build a dynamic website using MS Access.
My q is if it is necessary to download MySQL to create databases and recordsets.
I am having some connection-related problems and i am just wandering if the absence of MySQL has a role in it.
This topic has been closed for replies.

2 replies

E
edglenning
Participant
March 28, 2008
If this is all local what is your connection related problem? I am confused if it is all on the same host the connection problem may be driven by a configuration issue. I use PHP, Apache and MySQL for my local host and it works awesome. The apps really don't impact my local PC's perfromance at all either.
V
VagJim22Author
Participant
April 2, 2008
Hi i am going to be more specific about the connection-related problem i am facing.
The problem appears when i go to create a recordset at an ASP page and all these after the successful completion
of a database.
In the RS creation process i press the TEST button and the table appears meaning so far no problem.
The trouble begins when i go to save the created RS. I get a save as dialog box(and i cannot understand why) and a 2nd page is created which is connected with 1st and if i go to delete it a message appears warning me that the connection will be lost and if i do that the familiar red exclamation mark appears in the server behaviors panel.
My q is why a second page is created. Why the DB and the RS cannot co-exist in the sane page and DW creates a second.
If you want i can give you more details regarding the problem but for start let's see what we can do with above facts
Can you make any SENSE out of these?
So stating it again WHY A 2ND PAGE IS CREATED?
N
Newsgroup_User
Inspiring
March 26, 2008
VagJim22 wrote:
> I am trying to build a dynamic website using MS Access.
> My q is if it is necessary to download MySQL to create databases and
> recordsets.
> I am having some connection-related problems and i am just wandering if the
> absence of MySQL has a role in it.
>

MS Access is very different to MySQL, the lack of one will not effect
the other.

Steve
M
MikeL7
Inspiring
March 27, 2008
I would look into using MSSQL Server 2005 Express edition, it free and is much better that access, you can install it on a XP Pro machine and develop databases using the SSMS. A really good database for free, if your using PHP then use MySQL.
Connecting to either one is simple if they are installed proplery, look at a few Tutorials - Google Install MSSQL server 2005 express or MySQL.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices