PC Review


Reply
Thread Tools Rate Thread

Closing Access 2007 creates multiple MDB files

 
 
camainc
Guest
Posts: n/a
 
      10th Jan 2008
This is really strange, but I can't figure out what is causing this.

I have an Access 2007 application stored on a network shared drive. I
just created a new report, saved the report, and closed Access.

Then, I went to my wife's laptop, and opened the application from
there. My new report was not there, and I also noticed about 10 or 12
copies of "database1.mdb," "database2.mdb," "database3.mdb," etc. They
all seem to be copies of the access application (which has an
extension of .accdb).

Can anyone clue me in on what is happening here?
 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      10th Jan 2008
Uncheck the Compact On Close box under:
Office Button | Access Options | Current Database.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"camainc" <(E-Mail Removed)> wrote in message
news:b1ae18b6-a501-486e-9dcf-(E-Mail Removed)...
> This is really strange, but I can't figure out what is causing this.
>
> I have an Access 2007 application stored on a network shared drive. I
> just created a new report, saved the report, and closed Access.
>
> Then, I went to my wife's laptop, and opened the application from
> there. My new report was not there, and I also noticed about 10 or 12
> copies of "database1.mdb," "database2.mdb," "database3.mdb," etc. They
> all seem to be copies of the access application (which has an
> extension of .accdb).
>
> Can anyone clue me in on what is happening here?

 
Reply With Quote
 
camainc
Guest
Posts: n/a
 
      11th Jan 2008
On Jan 9, 11:36 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:
> Uncheck the Compact On Close box under:
> Office Button | Access Options | Current Database.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users -http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "camainc" <cama...@gmail.com> wrote in message
>
> news:b1ae18b6-a501-486e-9dcf-(E-Mail Removed)...
>
> > This is really strange, but I can't figure out what is causing this.

>
> > I have an Access 2007 application stored on a network shared drive. I
> > just created a new report, saved the report, and closed Access.

>
> > Then, I went to my wife's laptop, and opened the application from
> > there. My new report was not there, and I also noticed about 10 or 12
> > copies of "database1.mdb," "database2.mdb," "database3.mdb," etc. They
> > all seem to be copies of the access application (which has an
> > extension of .accdb).

>
> > Can anyone clue me in on what is happening here?


Thanks. One other thing I found out after I posted this question was
that the laptop thought it was working in "offline" mode - this is why
the changes on the network share version were not displaying on the
laptop's version. Once I got everything synchronized, it worked fine.
 
Reply With Quote
 
Allen Browne
Guest
Posts: n/a
 
      12th Jan 2008
Ouch! I strongly recommend you do not use off-line folders for Access
databases if you value your data at all.

You may find that your database just disappears into thin air of you do.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"camainc" <(E-Mail Removed)> wrote in message
news:6edbb8a1-1188-46e8-95cb-(E-Mail Removed)...
> On Jan 9, 11:36 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:
>> Uncheck the Compact On Close box under:
>> Office Button | Access Options | Current Database.
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users -http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>> "camainc" <cama...@gmail.com> wrote in message
>>
>> news:b1ae18b6-a501-486e-9dcf-(E-Mail Removed)...
>>
>> > This is really strange, but I can't figure out what is causing this.

>>
>> > I have an Access 2007 application stored on a network shared drive. I
>> > just created a new report, saved the report, and closed Access.

>>
>> > Then, I went to my wife's laptop, and opened the application from
>> > there. My new report was not there, and I also noticed about 10 or 12
>> > copies of "database1.mdb," "database2.mdb," "database3.mdb," etc. They
>> > all seem to be copies of the access application (which has an
>> > extension of .accdb).

>>
>> > Can anyone clue me in on what is happening here?

>
> Thanks. One other thing I found out after I posted this question was
> that the laptop thought it was working in "offline" mode - this is why
> the changes on the network share version were not displaying on the
> laptop's version. Once I got everything synchronized, it worked fine.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Multiple CSV Files Into Access 2007 JanelleR Microsoft Access Getting Started 1 12th Mar 2010 01:29 PM
How do I import multiple .dbf files into Access 2007? kfournie Microsoft Access External Data 0 16th Apr 2008 02:05 PM
excel creates multiple temp files when saving westbrom Microsoft Excel Misc 6 1st Mar 2008 02:12 PM
access 2007 compact creates new database Michel Peeters Microsoft Access 1 4th Nov 2007 02:54 PM
Re: Outlook 2007 creates Tmp files in Temp folder Patrick Schmid [MVP] Microsoft Outlook Discussion 3 9th Dec 2006 04:30 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:39 PM.