I have Microsoft Access on my desktop connecting to a MySQL database at my host, using an ODBC driver. I can read the data just fine. But when I try to add another record, it won't seem to do it.
Is it possible to update a MySQL database from MS Access on my desktop?
I have just one table. Very simple. Is it to do with primary key number generation or something?
Thanks,
Jon
Hello
I“m working in an application using Access as FE and MySql as BE.
When I add some registers to this linked table, OK.
Problem: When I try to add a lot of registers (700.000!) it does“nt work and the msg is that the computer does“nt have memory resources to do the job.
If I try the same with Access tables it works fine.
MySql configuration, perhaps?
Thanks a lot
Renato
I have seen it done in the past but at the time my limited knowledge did not retain how to do it, it is connected through the odbc, im am running server 2000
what code do i use to connect and how do i set up the odbc
any help would be appreciated
Jabez
I am building my frist database with MySQL as a backend to Access. I am using the ODBC driver and it looks very interesting. I have a question already though. I know that I can use the InnoDB engine and create relationships within MYSQL to enfro referential integirty, but should I? Or should I create the relationships in Access and let Access do the enforcing? Will my Access application report MySQL errors?
Thanks for the time.
I have a mysql database on my website (remote db). And i want to link to this database in acess(local bd) so that i can manipulate data.
How is it possible
Hey, Just wanted to throw the question out there, I already asked another member on their opinion on this but havent heard anything back yet, so im going to also throw the quesation out here as well and see what i get. Im new to databases and started out trying to learn Access with the intention that what i learned in Access i could use to learn MySQL, I figured access was a easier starting point to get my feet wet. I eventaully want to apply my databases to the web and im not sure but just wanted to find out. Does access have capabilities to manage a site where customers create an account on the site and log in and everything?? I was thinking access cant really do it and if it could it might be hard, so thats why i was looking into MySQL. I guess what im really asking is whats the difference between Access and MySQL, and what advantages and disadvantages do they have?? Everybodys opinion is welcome, it all helps me out. Thanks! ~[MikE]~
View 5 Replies View RelatedHello everybody,
Who can help me.
I want to access a MySQL database with ms access.
I cant seem to get it.
Please help me.
Thanks in advance,
John
Hello to all
this is my first post
i am havinga problem with my access database
so i started to converted it to MYSQL
but after converting it and running asp script it gives the following error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[TCX][MyODBC]You have an error in your SQL syntax near 'SELECT tblTopic.Topic_ID FROM tblTopic WHERE tblTopic.Forum_ID = 4 ' at line 1
/mycplus/forum/Default.asp, line 335
and the orignal sql statement in ASP Forums is
strSQL = "SELECT " & strDbTable & "Author.Username, " & strDbTable & "Author.Author_ID, " & strDbTable & "Thread.Topic_ID, " & strDbTable & "Thread.Thread_ID, " & strDbTable & "Thread.Message_date "
strSQL = strSQL & "FROM " & strDbTable & "Author, " & strDbTable & "Thread "
strSQL = strSQL & "WHERE " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID AND " & strDbTable & "Thread.Topic_ID IN "
strSQL = strSQL & " (SELECT " & strDbTable & "Topic.Topic_ID "
strSQL = strSQL & " FROM " & strDbTable & "Topic "
strSQL = strSQL & " WHERE " & strDbTable & "Topic.Forum_ID = " & intForumID & " "
'strSQL = strSQL & " ORDER BY " & strDbTable & "Topic.Last_entry_date DESC) "
'strSQL = strSQL & "ORDER BY " & strDbTable & "Thread.Message_date DESC;"
it was fully working in ASP + Access forums
Thanks
Plz help me
Hi all,
hope someone can help me with this.
Before we moved webhosting company we could have external access to our MySql database which was great as our MS Access system would periodically pull data from our MySql site (namely customer enquiries which were entered via a form on our website) and dump them in our MS Access live quotes table all automatically.
With our current host (which seems to be the norm from my web-searches) they only allow local access to the MySql system.
My question is, how can I oversome this hurdle without having to move hosting company. I really don't want to move again as it's a real pain.
All suggestions welcome.
ahrint
I have an existing MS Access/MySQL app that I need an experience developer to develop further. The existing application is fairly complex, so experienced developers only.
View 2 Replies View RelatedOn my development machine everything works great, but I know that I'm going to run into problems with distribution.
I don't think there is a way, but I'll ask. Is there any way to get around not having to install the ODBC MySQL drivers on each computer? One of the reasons I'm migrating to MySQL for a backend is the fact that I'll be going from 10 users to 150 users, each of which has a "locked down" PC, which would mean logging into each with Admin rights to install the driver. Not an impossible task, but a pain.
Is is possible to have a "shared" source for the driver? I have only a rudimentary understanding of that process.
Thanks in advance for any help that someone can provide, or some answers pointing me in the right direction.
I have converted my MS Access database tables to MySQL Server tables. I am trying to use the MS Access front end to cooperate with the MySQL Backend database. I have created a system DSN, without problems.
My issue is when I Open MS Access --> Open File --> Files of Type: ODBC Databases, nothing happens. It does not give me the option to connect to the MySQL database I just created. I also tried to import data by linking tables (again, choosing the ODBC databases option), and it does the same thing. Does anyone know what I may be doing wrong?
I'm new to access and I'm trying to learn the functionality by creating a relational DB for US zip codes from an excel document. I've imported everything and I have the tables setup. Is there a way to run a MYSQL query like this:
UPDATE tbllocation, tblzipcode SET tbllocation.ZipID = tblzipcode.ZipID WHERE tbllocation.ZipID = tblzipcode.ZipCode;
in access 2007?
Thanks
Could someone please help me?
At work we have a website with a mysql database attached to it. It keeps data such as customer name address postcode contact id etc.
Currently our main database is made in access.
I need to transfer data from the website database (which is in mysql) to our access database. And would like this to happen regulary. We have been quoted £1800 for someone to do this!
As this is a new job i would like to be able to do this myself, is it hard to do?
Could someone provide me with some information of how to do this? or where to start.
Much appriciated.
Hi There,
Whereabouts would I change the date format from the access database from yyyymmdd ?
I am trying to convert this table from access into mysql, and when I ouput to a csv file the date is in access.
Many Thanks
Chris
I don't know if this is thebest place for this, but here goes....
I have an Access FE using MYSQL 4.1 BE. I have several forms and PassThrough queries (using MYSQL syntax not supported or available in Access).
How can I use form field values to use as criteria for these queries?
FOr example, in a pure Access database. I may have a form 'Employees' with a text box 'EmployeeName'. THen have a query....
SELECT * FROM tblEMployees WHERE EmployeeName = [Forms]![Employees]![EmployeeName]
If I were to add this variable to my pass-through queries, it errors. How can I do the same thing, passing my form fileds to an Access Query? I am trying to do this right in the SQL view of the queries, not in VBA or Macros or anything.
Thanks,
Scott
If I want to distribute a front end to connect with a MySQL back end ... do I need to set up the system DSN on each workstation that will be using the front end?
View 4 Replies View RelatedHello
I'm looking for a web based front end to put on my access database. Due to the way our work site is set up and the people who will be entering some of the data my boss wants it to be accessed through a web browser. Infopath wont let me enter data into an access database through a web browser and with DAPs becoming a thing of the past we dont really want to use them either. Some of the forms will be used for raw data collection while others will be used to fill out spill reports (i work in an environmental department) so we can get the information quickly. We have tried just using access to run everthing but have meet alot of resistance as most of the people who enter the data hate it. I also had someone enter half a spill report into an SQL sequence once..dont even know how he got there. That is the main reason we are looking for a web based data entry system. I dont believe my boss wants to use anything but access for the storage. So basicly we are just looking for a way for people to use a web browser to enter data into an access database. Any advice would be greatly appreciated. Thanks
I want to use access 2007 as a front end for Sql Server DB. I want to create a basic input form, a search and display facility, and have some reports generated out of the application.
If this would be possible to do using Access in 20 days?
i am creating a database that will house some supplier information. once designed, the db will be populated with all the data and then it will be used as a reference tool for future projects.
it was requested that an "excel front end" be used for lookup and ease of use to access the data when it is finished... i am not really sure how that works.
also, what is the best way to create contingent variables in access-- for example, if a certain value is in the database then you have a corresponding action. like if there were a field asking how many suppliers there were, and if say the number is 4, then 4 entry windows come up. a sort of if/then statement?
i hope this makes sense. thanks a whole lot
I split my database so that users could only edit/view data through the forms but when I opened the front end the tables where still there (linked though) and I could edit and look at them. I assume this is normal so how can I prevent users from seeing the tables. Do I just set them to hidden? Thanks.
View 3 Replies View RelatedI am a computer novice with no experience in PHP or SQL Servers in general. Is there anyway to set up Access as a front-end to an MS SQL Server without having coding knowledge? Is there any good wizard that will export data/formats to a SQL Server while still keeping the interface mechanisms of Access?
View 4 Replies View RelatedHI:
anyone got any suggestions about using access 2003 tables as the backend and swishmax as the frontend. Thanks in advance.
Is it possible to do this?
if so what kind of connections would i use?
and how would i connect?
Hi,
I have an Access front end that has linked tables to a SQL Server back end database. The connection to the back end is a via a read only user because the front end is a reporting tool for querying, viewing and reporting on the data. I am able to view the data in the front end and set up new queries. However my user has the new query icon greyed out. I have not set up any kind of permissions or security levels to my knowledge so am a little mystified as to why their permissions should be different to mine! Does anyone have any ideas please?
I have been posting a lot recently and have greatly appreciated the help. I have just been looking at the size of a ms access project, this is a front end for another database so contains no data (runs as an mde for most). I have made a few modifications using access 2007 including at one point having it in the new file format, this was to fix a bug I was getting that caused a particular crash. I found converting it to 2007 and back cleared the problem.
Anyway the main things I added were an active directory query to enable certain buttons for a limited number of users. Including the VBA reference to do this. I also added a new report that when run in access 2007 (even in 2003 format) allows the new reportview so I can have an onclick event within the report for the user to gather more information which it wouldn't be appropriate to have on the main report.
This has balooned the size from 5mb to 50mb even after a compact and repair. Any suggestions as to possible causes could it really be adding vba references causing that much of an increase. I should say i'm not particularly worried it's ok for it to be that size I just wonder why such a massive difference.