Real Estate Agent Database

[Rudodoo]

I am creating a web-site which will contain hundreds of listings using an
Access Database. Can I attach the Database to Dreamweaver? How do I attach
the pictures with its MLS listing? Also, will it benefit me if I use
Microsoft SQL server 2005 with Access? and if so how? I want to create
something similiar to txkrealestate.com. Any tips would be greatly
appreciated

 

[Ed Warren]

Rudodoo
There's a reason those "expensive" real estate programs are expensive.

Your project is like doing do-it-yourself brain surgery (sometimes its
better to get expert assistance) ;>

You may want to find a local developer that you can engage to help you
with this project (web based data access is never trivial)

Re Dreamweaver, I suspect you can tie it to access, the real problem is
rather if your web server (or ISP) supports Access.

If you are developing a web site, you probably want to start with Visual
Studio 2005, and SQL 2005 (or MySQL) , but Access CAN be used ( like a
shovel can be used to dig a canal)
Note Access is really designed to be a great data consumer, it's
orginial purpose was to provide desktop data "access". It is great at
gathering data from from disparate data sources into the client machine,
organizing it, and displaying it. It is less great, although adequate in
some cases, as a data 'source'. It is specifically weak as a large volume,
multiuser, data pump for a high volume web site.

For pictures you want to store hyperlink references to the picture
files, in the database.

Ed Warren.

 

[Rudodoo]

Rudodoo
There's a reason those "expensive" real estate programs are expensive.

Your project is like doing do-it-yourself brain surgery (sometimes its
better to get expert assistance) ;>

You may want to find a local developer that you can engage to help you
with this project (web based data access is never trivial)

Re Dreamweaver, I suspect you can tie it to access, the real problem is
rather if your web server (or ISP) supports Access.

If you are developing a web site, you probably want to start with Visual
Studio 2005, and SQL 2005 (or MySQL) , but Access CAN be used ( like a
shovel can be used to dig a canal)
Note Access is really designed to be a great data consumer, it's
orginial purpose was to provide desktop data "access". It is great at
gathering data from from disparate data sources into the client machine,
organizing it, and displaying it. It is less great, although adequate in
some cases, as a data 'source'. It is specifically weak as a large volume,
multiuser, data pump for a high volume web site.

For pictures you want to store hyperlink references to the picture
files, in the database.

Ed Warren.




Well should I start a creation in Access and then transfer it to SQL?

 

[Ed Warren]

Was there something you wanted to say??