If the connection itself passes a test, but MS Access hangs, I don't know what to suggest. I'm not an expert, it just worked when I tried it.
You use File... Get external data... Link tables, right? Is that where it hangs? Does it list the tables in your MySQL data base, or doesn't it even get that far? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Langson B.-Computer Specialist [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 23, 2007 4:27 AM > To: Jerry Schwartz > Subject: RE: Ms access front end and mysql back end > > My database is in MySQL on the server and I have 5 machines > connected to the > > server. The front end is MS access. This is where I have > forms, queries, > reports and macros. The front end is installed on all the five work > workstations. > > The server runs Windows Advanced 2000 server and the > workstations run Windows > XP. > > The problem is, I cannot connect to the server using any of > the workstations. > When I try to connect using myodbc, the system the system is > able to connect to > the server. But when I open MS access and then try to link to > the server, MS > access hangs. > > > > What is the solution? I would really appreciate If you could assist. > Is there any other way I can connect to the database on the server. > > MS Access has limitation in terms of number of records. I > have been having > problems with constant hanging, working in MS Access (Both > Front and Back end). > That is the reason why I opted to convert MS Access Tables into Mysql. > > Can you please advise if I have to abandon MS access > completely and go to > another front end. > > > > > ______________________________________________________________ > ______________________ > Food fight? Enjoy some healthy debate > in the Yahoo! Answers Food & Drink Q&A. > http://answers.yahoo.com/dir/?link=list&sid=396545367 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
