Split Database vs. Access Project

C

Candance

I have an Access Database that I want multiple users to share, some of whom
work remotely from home. I have split the database into front and back ends.
Can I simply convert the back end to an sql server format, and connect the
front end to those sql tables, or do I have to upsize the front end to a MS
project?

Also, I experimented with upsizing the database using the MSSQL server
version of sql that came with my Office 2003 program (skinny version). Can I
migrate that to a shared network drive, and what needs to be installed on the
network drive to accept it?
 
D

De Jager

Candance said:
I have an Access Database that I want multiple users to share, some of whom
work remotely from home. I have split the database into front and back
ends.
Can I simply convert the back end to an sql server format, and connect the
front end to those sql tables, or do I have to upsize the front end to a
MS
project?

Also, I experimented with upsizing the database using the MSSQL server
version of sql that came with my Office 2003 program (skinny version).
Can I
migrate that to a shared network drive, and what needs to be installed on
the
network drive to accept it?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split Database 9
Multiple users of a split database 3
Recommended UK companies for migrating from Access to SQL 6
SQL Server 13
Access 2007-Splitting a Database 2
Copying a split database 3
Copying a split database 1
Your network access was interrupted 6

Top