By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,328 Members | 1,669 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,328 IT Pros & Developers. It's quick & easy.

sql server and access

P: n/a
I mean how does it work. I'm new to this and i cant find good
information. Access is the front end (forms..report...etc), and sql the
database right?? Do i need a dedicated server for that. Stuff like
that....Can i build my Db in access and send it to the sql server....
thx

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
SQL is actually a language used for querying databases - Microsoft's two database products are "SQL Server" and "Access". Both are "databases" in that you can create tables and store data in them.

Access supports VBA or "Visual Basic for Applications", which is what allows you to create screens and things to interact with the data and the end user. The reports are slightly different, but we won't go into that now. The general idea is that you can use Access all by itself to create a complete, standalone application.

SQL Server is an enterprise level database, meaning that it's got enterprise level database management facilities, like reorganising indexes, splitting it into separate files, etc. It doesn't support VBA itself, so you need a separate development environment to create an application to use the data in the database.

You can link tables in a SQL Server database so that they look like any other table in Access. So you can write forms and screens in Access to work with the data. The big difference is that Access isn't storing the data locally itself, but working with the data in the SQL Server database. Since a SQL Server database almost always supports multiple users, normally it does run on its own server somewhere. But you could set up a SQL Server database locally, and link to one on your PC just as you would link to one on a server.

I believe there are some functions that allow you to "upscale" an Access database to a SQL Server one ie. take all of the tables and relationships you have created in Access and create them in a SQL Server database. I have no idea how that would work, though.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #2

P: n/a
thx

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.