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 |
|
thkly8
Starting Member
2 Posts |
 Posted - 2011-09-13 : 11:27:40
|
| Hi there. This is my first post so i hope i haven't left anything out!I've just started working at this small charity organization and one of the first things they want me to do is make them a Microsft Access system (easy enough).But one of the problem is, is that they already have a system made by someone else a couple of years ago which is pretty buggy. The system used a backend Mirosoft SQL Server Express 2000 and i need to export all the data from there into Access (2003 btw).I was wondering if anyone had any advice as to how i could gain access to the backend of the system so i could transfer that data.ThanksTony |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-13 : 16:07:24
|
| You'll need a login for SQL Server.Going from SQL Server (even Express) to MS Access is a step backward though. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-14 : 03:53:33
|
| Why not have your shiny new Access front end connect to MS SQL for its backend data storage? |
|
|
|
|
|
|
Exporting a Microsoft SQL backend into Access