I
I3itchBoyz
Hello all this is my first post here and this is what im trying to do.
I own a car parts site and Im making a new site and shopping cart base
on a server side DB that I have created in Access. My main purpose i
to have only 1 DB which stays on my hosts server and I want to make
form and/or new DB that connects to it on the server and I can make th
changes from my computer (without the FTP hassle). now I was playin
around with this earlier and I linked a new DB to it but that jus
copied it all to the local drive and when I made changes they wen
unsaved on the server side. I need to beable to do this so I can us
Access as a POS system in my store and create orders withou
conflicting with Online Order numbers. (i.e. creating 2 order #12032's
and I want it so that I can manage real time inventory and other fu
options that I have yet to create.
I want to keep as little info as possible on the server side so tha
the shopping cart system runs faster. Im new to access but am learnin
quickly so Im gonna take a stab at in and say I should keep all th
Forms I made on the local access DB and only the Data tables on m
server for my ASP shopping cart to read. I hope someone could help m
by pointing me into the right direction on the best way to do this.
Thanks alot for your help. -Russell-
Also if you could give me any tips on making the shopping cart run fas
that would be great too. I read the MS Analyzer and it said to save a
a MDE file or something like that. Thank
I own a car parts site and Im making a new site and shopping cart base
on a server side DB that I have created in Access. My main purpose i
to have only 1 DB which stays on my hosts server and I want to make
form and/or new DB that connects to it on the server and I can make th
changes from my computer (without the FTP hassle). now I was playin
around with this earlier and I linked a new DB to it but that jus
copied it all to the local drive and when I made changes they wen
unsaved on the server side. I need to beable to do this so I can us
Access as a POS system in my store and create orders withou
conflicting with Online Order numbers. (i.e. creating 2 order #12032's
and I want it so that I can manage real time inventory and other fu
options that I have yet to create.
I want to keep as little info as possible on the server side so tha
the shopping cart system runs faster. Im new to access but am learnin
quickly so Im gonna take a stab at in and say I should keep all th
Forms I made on the local access DB and only the Data tables on m
server for my ASP shopping cart to read. I hope someone could help m
by pointing me into the right direction on the best way to do this.
Thanks alot for your help. -Russell-
Also if you could give me any tips on making the shopping cart run fas
that would be great too. I read the MS Analyzer and it said to save a
a MDE file or something like that. Thank