Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Split Access in Windows 7?


19 Nov 2009   #1

Windows XP to Windows 7
 
 
Split Access in Windows 7?

Hi, we are migrating our office to Windows 7 & the new MS Office 2007. We don't have a network but need everyone to be able to work in MS Access at the same time. I was told splitting the database in Access would help us achieve this.

Will this still be the way to do it with Windows 7 & Office 2007 or does Windows 7 offer new, better ways to share programs without having a server?

Thanks,
AAAHome

My System SpecsSystem Spec
.

19 Nov 2009   #2

Win 8 Release candidate 8400
 
 

Quote   Quote: Originally Posted by AAAHome View Post
Hi, we are migrating our office to Windows 7 & the new MS Office 2007. We don't have a network but need everyone to be able to work in MS Access at the same time. I was told splitting the database in Access would help us achieve this.

Will this still be the way to do it with Windows 7 & Office 2007 or does Windows 7 offer new, better ways to share programs without having a server?

Thanks,
AAAHome
Hi and welcome

If you dont ahve a network how will you work on the database at the same time?

Ken J++
My System SpecsSystem Spec
19 Nov 2009   #3

Windows XP to Windows 7
 
 

By splitting the database into two components - 1 backend that contains the tables, & the other contains the queries, forms, reports, etc. The one with the queries, etc. is installed onto each users computer & the other is on a mapped network. Can it not work this way or is a server definitely required?
My System SpecsSystem Spec
.


19 Nov 2009   #4

Windows 7 Home Premium 64-Bit
 
 

Quote   Quote: Originally Posted by AAAHome View Post
By splitting the database into two components - 1 backend that contains the tables, & the other contains the queries, forms, reports, etc. The one with the queries, etc. is installed onto each users computer & the other is on a mapped network. Can it not work this way or is a server definitely required?
Surely that means you'd have to merge any changes that each user has made to their local copy?

How does your office function without a network?

I would get a network, an SQL Server (such as MS SQL Express which is free) and migrate the Access database to SQL and then write a multi-user front end for the users to write.
My System SpecsSystem Spec
Reply

 Split Access in Windows 7?




Thread Tools




Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 01:50 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33