Get an list of tabels in asp - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Get an list of tabels in asp

Author

Topic

gerten
Starting Member

17 Posts

Posted - 2003-10-07 : 17:13:34

Can someone help me to get an list of all tabels from Access db to an asp website.

Best reg
Gert

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2003-10-07 : 19:54:48

I assume you mean an Access ".mdb"?

select name from msysobjects where type = 1

(this will give you the system tables too)
--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"

gerten
Starting Member

17 Posts

Posted - 2003-10-08 : 19:33:25

Sorry, sure i ment ".mdb"
Years ago i started some project with an golf statistic in access.
I have this mdb where i put some password, and now it can't remember it.
So my point was to get all tabels names and then all field. so i can make an new mdb without password.
With this code i get following answer "Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][Drivrutin för ODBC Microsoft Access] Ogiltigt kontonamn eller lösenordInvalid accont or password.
/golf/Default.asp, line 11"

I have try to put system mdb in ODBC conn, with no result.
How get i around this, here is the code:

Best regards
Gert

<%
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "Golf"

SQL="select name from msysobjects where type = 1"
response.write SQL
Set rs = connect.execute(sql)
response.write rs(namn)

Connect.Close
%>

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2003-10-08 : 19:50:13

So... you're saying that you put an administrator password on your mdb file and now you want us to tell you how to get around the security? Even if I knew, I wouldn't post that on a public forum.

--------------------------------------------------------
Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url]

gerten
Starting Member

17 Posts

Posted - 2003-10-08 : 20:19:41

Not get around the security. only list tabelsnam and fild so i can make a new one. But maby i had to make an new mdb. i remember for eatch post in some tabels it was up to 50 fieldnams. so it would be easier too coy this rather than make an new one.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources