I have an access database which I imported into sql server on my sbs 2003
premium sp1 server. This server is also hosting my sharepoint sites.

I'm trying to create a database connection from frontpage 2003 but I don't
get the tables listed for my database on the last step of the wizard. The
only databases that list tables are pubs and northwind. How can I get the
wizard to load the the tables form my database? the database imported into
sql successfully, by the way.

Did you import that Access database into the SharePoint DB, or its own DB?
If you imported into the SP DB, stop doing that immediately. Instead,
create a new DB to hold your Access DB, and connect via the usual conenction
settings in your code.

"Ryan" <(E-Mail Removed)> wrote in message
news:8D07F24E-C3ED-4F5D-AC10-(E-Mail Removed)...
> I have an access database which I imported into sql server on my sbs 2003
> premium sp1 server. This server is also hosting my sharepoint sites.
>
> I'm trying to create a database connection from frontpage 2003 but I don't
> get the tables listed for my database on the last step of the wizard. The
> only databases that list tables are pubs and northwind. How can I get the
> wizard to load the the tables form my database? the database imported
into
> sql successfully, by the way.

I right-clicked in the sql enterprise manager and slected import, and
imported all the tables from my access database to a new sql database called
SCC.

I can see the SCC database in the drop-down menu on the "select dtatabase
and table, view or stored procedure" page of the Configure Database
connection wizard in sharepoint. The problem is it doesn't list the tables
in the database so I can't select any tables to save the connection. This
database doesn't have a password or anything set so I have the connection set
for windows authentication right now, since nothing else gets me even this
far.

Is there something I'm doing wrong?

"Richard Dudley" wrote:

> Did you import that Access database into the SharePoint DB, or its own DB?
> If you imported into the SP DB, stop doing that immediately. Instead,
> create a new DB to hold your Access DB, and connect via the usual conenction
> settings in your code.
>
> "Ryan" <(E-Mail Removed)> wrote in message
> news:8D07F24E-C3ED-4F5D-AC10-(E-Mail Removed)...
> > I have an access database which I imported into sql server on my sbs 2003
> > premium sp1 server. This server is also hosting my sharepoint sites.
> >
> > I'm trying to create a database connection from frontpage 2003 but I don't
> > get the tables listed for my database on the last step of the wizard. The
> > only databases that list tables are pubs and northwind. How can I get the
> > wizard to load the the tables form my database? the database imported
> into
> > sql successfully, by the way.
>
>
>