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

Problem Creating A File Then Trying To Zip It

P: n/a
AccessXP (2000 Mode)

I use the following statements to create a database file:
DataFile = Path & "CouncilDBData.mdb"
Set Db = DBEngine.Workspaces(0).CreateDatabase(DataFile, dbLangGeneral)

I next run four make-table queries to ceate four tables in the database.

Finally, I try to zip the database and get the message 'File Not Found or No
Read/Write Permissions Or Sharing Problem". When I look in the folder,
CouncilDBData.mdb is there. Can anyone offer any in-sight as to what the problem
is? All the above actions are in the same procedure, might it be that the new
database file is not saved to the folder until the procedure is complete?

Thanks,

Steve
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Could it be that the file is still flagged as Open and the message isn't
fully accurate? I don't know that's the case, but seems it could cause a
problem.

Larry Linson
Microsoft Access MVP

"Steve" <sp**@nospam.spam> wrote in message
news:Uq******************@newsread3.news.atl.earth link.net...
AccessXP (2000 Mode)

I use the following statements to create a database file:
DataFile = Path & "CouncilDBData.mdb"
Set Db = DBEngine.Workspaces(0).CreateDatabase(DataFile, dbLangGeneral)

I next run four make-table queries to ceate four tables in the database.

Finally, I try to zip the database and get the message 'File Not Found or No Read/Write Permissions Or Sharing Problem". When I look in the folder,
CouncilDBData.mdb is there. Can anyone offer any in-sight as to what the problem is? All the above actions are in the same procedure, might it be that the new database file is not saved to the folder until the procedure is complete?

Thanks,

Steve

Nov 12 '05 #2

P: n/a
"Larry Linson" <bo*****@localhost.not> wrote:
Could it be that the file is still flagged as Open and the message isn't
fully accurate? I don't know that's the case, but seems it could cause a
problem.


To add to Larry's posting see if the corresponding .ldb file is present when you do
the zip. If so something is still open against it.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #3

P: n/a
Larry,

Your response was 100% right. I added a line to set Db = Nothing immediately
before the zip code and all works well now. Thanks for the insight!

Steve
"Larry Linson" <bo*****@localhost.not> wrote in message
news:pP****************@nwrddc02.gnilink.net...
Could it be that the file is still flagged as Open and the message isn't
fully accurate? I don't know that's the case, but seems it could cause a
problem.

Larry Linson
Microsoft Access MVP

"Steve" <sp**@nospam.spam> wrote in message
news:Uq******************@newsread3.news.atl.earth link.net...
AccessXP (2000 Mode)

I use the following statements to create a database file:
DataFile = Path & "CouncilDBData.mdb"
Set Db = DBEngine.Workspaces(0).CreateDatabase(DataFile, dbLangGeneral)

I next run four make-table queries to ceate four tables in the database.

Finally, I try to zip the database and get the message 'File Not Found or

No
Read/Write Permissions Or Sharing Problem". When I look in the folder,
CouncilDBData.mdb is there. Can anyone offer any in-sight as to what the

problem
is? All the above actions are in the same procedure, might it be that the

new
database file is not saved to the folder until the procedure is complete?

Thanks,

Steve


Nov 12 '05 #4

P: n/a
Thanks for responding, Tony!
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:sq********************************@4ax.com...
"Larry Linson" <bo*****@localhost.not> wrote:
Could it be that the file is still flagged as Open and the message isn't
fully accurate? I don't know that's the case, but seems it could cause a
problem.
To add to Larry's posting see if the corresponding .ldb file is present when

you do the zip. If so something is still open against it.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.