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
AAAHome

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
zigzag3143

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
AAAHome

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
AntiSilence

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





Similar help and support threads
Thread Forum
Help w/Windows 8.1 split screen @2560x1440
I'm using win 8.1 with a 2560 x1440 resolution, but I can't seem to get split screen to work. I've tried a few tutorials online, but without success. I can easily split the screen by left mouse clicking the top of the screen and dragging down. The first window works normally with task bar...
General Discussion
How to split windows over 2 drives w/o partitions
I recently installed a Samsung 256G SSD as C: drive in my laptop. I cloned windows7 home from the existing HD 700G. I copied the non-essentials to ajoining HDs. I installed the old drive C: to a Sata port and taged it D: Now as my libraries grow larger I would like to split windows so that the...
General Discussion
Adjustment to Split Screen View in Windows 7
I know how to view split screen by using WINDOWS key and left/right navigation arrow keys. The problem is is that the left and right screen,as expected, does not fit on a screen half the size. Is there anyway to shrink the left and right sides so that the whole screen, though smaller fits on the...
General Discussion
Split 7GB Windows Image into 2 DVD! Help
Hello, How are you guys doing? I have a 7.24 Gb Windows 8 .iso file. How do I split it so that it would burn into 2 dvds for installation? I don’t want to buy any 8GB DVD and I don’t have USB. Is there an application that can do the job? Please help.
General Discussion
Windows Media Center Split Screen
I imagine I am not the first person to ask/complain about this, but I scoured the Forum for a solution, and couldn't find one - so please be patient. Why can't I "split screen" my Media Center window? By that, I mean - why can't I drag it to the side of the screen and have it take up half the...
Media Center
Is it time for Microsoft to Split Windows in Two again?
Is it time for Microsoft to Split Windows in Two again? | Windows 8 News
News

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 05:23.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App