Database Connection Strings

I have a few simple Access tables to store data in. The PF2002 wizards work fine for the input. However, I want to retrieve data from those table and concantenate the fields to create my own formatting. The wizards only allow table type views. I can not find any reference books that show how to set up a simple connection string, access the fields I need, and allow me to manipulate them. (for simple example-[LastName] & ", " & [FirstName] & " " & [MiddleInitial]. The reference books I have show me how to set up a SQL Server string, or a connection to a local harddrive using Access. How do I do it from within FRontPage2002? Thanks!!

Tom
Sat May 22 01:57:24 CDT 2004

Check out...

http://www.connectionstrings.com/

for all your connection needs! :)

Best to you.....
Tom Gahagan

"IdahoSAM" <anonymous@discussions.microsoft.com> wrote in message
news:9CBAEDCC-FE55-4A37-A3A5-058653E5E183@microsoft.com...
> I have a few simple Access tables to store data in. The PF2002 wizards
work fine for the input. However, I want to retrieve data from those table
and concantenate the fields to create my own formatting. The wizards only
allow table type views. I can not find any reference books that show how to
set up a simple connection string, access the fields I need, and allow me to
manipulate them. (for simple example-[LastName] & ", " & [FirstName] & " "
& [MiddleInitial]. The reference books I have show me how to set up a SQL
Server string, or a connection to a local harddrive using Access. How do I
do it from within FRontPage2002? Thanks!!