Thanks Bill.
Abraham
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Abraham
>
> Thanks for letting us know you got the sample.
>
> Actually, you only need the DSN file initially to link the tables. Once it is done, Access uses a connection string stored in the table MSysObjects, but your idea is how I would do it.
>
> Be sure to read my article at:
> http://thatlldoit.com/howtosarticles.aspx#sqlbackend
>
> While it was written for SQL Server, a lot of it might still apply to your database.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, "Abo" <abraham@> wrote:
> >
> > I think I found the info I need at http://www.connectionstrings.com/
> >
> > Abraham
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Abo" <abraham@> wrote:
> > >
> > > Hi,
> > > This is not strictly an Access question, but is related.
> > >
> > > I have a client-server Access aplication and I want to move the database back-end to MySQL and continue using the Access front-end.
> > > The application will be used by a number of people, and may need to be set up on client machines by someone who is not really an IT person, but is a power user. I would like to make this setup procedure as easy as possible for this person.
> > >
> > > I though of linking the Access tables to the MySQL back-end using a file DSN, hoping that all that will be needed is that one file and the client front-end will pick up the odbc connection from that file.
> > >
> > > I would really appreciate a sample file DSN, complete with host, placeholder username and placeholder password. The ones I have found on the Net are either for different databases or are not complete.
> > >
> > > Any alternative methods are also welcome.
> > >
> > > Thanks.
> > >
> > > Abraham
> > >
> >
>
Tidak ada komentar:
Posting Komentar