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.
| Author |
Topic |
|
Diceman
Starting Member
3 Posts |
 Posted - 2006-11-27 : 03:10:04
|
| i have roughly 10-15 access databases that i am trying to run through sql server express, i installed this thing thinking it would would "just work minus a little configuration", what a misconception. so do tell, what do i need to do. i have sql server express running, it is configured to allow remote connections. i know the path's of these access databases. how do i attach them. i saw something about the command line interface but im not interested in that because of the number of databases i will need to manage, not to mention trying to add an additional one 6 months down the road and i will be lost all over again. i thought about downloading SQL Server Management Studio thinking it would be a "gui side" to the CLI version. while it was downloading, it said i need XX program, i go to that page, it says i need XX and XX first, it is turning into a pyramid scheme to install a billion programs. so point blank, i want to share some access databases to my local lan, i have sql server express installed and running. what do i need to finish this out. the simplest and smallest footprint solution is needed.all this because the program im using cant do remote databases. ugh. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-27 : 03:30:09
|
| Do you want to import Access database or just access it from SQL Server?You can create Linked server to access database to access it from SQL Server. But this seems like pretty bizzare design. If you want to import it, you can use DTS. Also, if you are using Access 2003, there is upsizing wizard to upgrade db to SQL 2005.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
Diceman
Starting Member
3 Posts |
Posted - 2006-11-27 : 04:50:19
|
| im basically just wanting read access to these databases from another server. i plan on running sql queries on the access databases, then graph the results with cacti. a dynamic webpage is also a possibility, will be a little more work for me in the short term, but once it is running it wont hurt anything and i will have a visual page to look at as well if i desire. whichever is easier, i dont care, i just want it to be done and working. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-27 : 04:56:58
|
| If you just want to access database, why bother with SQL Server at all?Why don't you connect directly to the Access database file through OLEDB or ODBC?Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
Diceman
Starting Member
3 Posts |
Posted - 2006-11-27 : 17:07:14
|
| cause i have no clue how this stuff works or what to use, im a *nix guy and windows is not my thing. if this program could use a remote database, the database would be on a *nix server and i wouldnt even be messing with this crap right now.i looked at ODBC but didnt really understand how i was supposed to make it all work together and the sql server deal looked easier to setup and go. like i said, i dont care how it gets done, i just need the quickest solution. i've already spent way more time on this that i wanted to. |
|
|
|
|
|
|
|
|
getting started, need some help