I currently have Access97 as a front end of MySQL database. Would any of
you be able to suggest me any other "easy" front end for the database.
Employees in my company are very slow to learn, so something like Access
would be good to find. The reason I am asking is, because every damn time I
host.
Apolinaras "Apollo" Sinkevicius
Carmel Music & Entertainment, LLC
701 Main Street, 2nd Floor
Evanston, IL 60202
Toll-free: 800-276-5969
Phone: 847-864-5969
Fax: 847-864-6149
E-mail: [EMAIL PROTECTED]
web-site: http://carmelentertainment.co
I found a problem with MyODBC when linking tables to Access97. It considers
DECIMAL type as TEXT (and you know you can't change that without going into
code). I changed the column type into FLOAT and it fixed the problem, but
at the same time it would be nice if MyODBC either gave you a choice
What should I convert Access97 HYPERLINK column type to in MySQL? How do I
get Access97 form to look at that new converted column same way as with
native column.
Any suggestions? Everyone in the office was pretty used to clicking on the
link to the file in the form, but now I am not able to do
What should I convert Access97 HYPERLINK column type to in MySQL? How do I
get Access97 form to look at that new converted column same way as with
native column.
Any suggestions? Everyone in the office was pretty used to clicking on the
link to the file in the form, but now I am not able to do
What would I have to do (sql expression) if I want to have a user be able
to access database from anywhere (so I don't have to make additions for all
the hosts).
database=list
username=bigpapa
password=see5060
What would be the route to do that?
Thanx
--
My set-up:
MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches
to everything)
I have no trouble running this set up, BUT...
Even when I am the only person connected (after flush and restart of
server) and I open my Access database and go directly to edit one
particular t
My set-up:
MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches
to everything)
I have no trouble running this set up, BUT...
Even when I am the only person connected (after flush and restart of
server) and I open my Access database and go directly to edit one
particular t
My set-up:
MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches
to everything)
I have no trouble running this set up, BUT...
Even when I am the only person connected (after flush and restart of
server) and I open my Access database and go directly to edit one
particular t
My set-up:
MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches
to everything)
I have no trouble running this set up, BUT...
Even when I am the only person connected (after flush and restart of
server) and I open my Access database and go directly to edit one
particular t
I would like to set a default value in DATE type column to Date(), but it
doesn't work. Is there a way to do it through column format?
If not, what should I enter in the VB code below (place where I need help
will have )
Private Sub okButton_Click()
Dim db As Database
Dim r
I wonder, is there a performance gain if compression is turned on the
client side?
My set-up:
Front end: M$Access97 via latest MyODBC
Back end: MySQL 3.23.30 on RH7 with PIII300 128Ram
LAN is 100BaseT Full Duplex switched.
Thanx
Well, finally I have launched full blown MySQL database. Speed is amazing (in
comparison with our previous monogenous M$Access database).
I am now tuning MySQL (3.23.30 on RH7.0/ PIII300 Dell server with 128RAM) server via
my.cnf
So far here is what I got:
1. ANSI mode tables
2. logs are off
3.
13 matches
Mail list logo