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

Access 2007 conversion - VBA project password protected

P: 77
Hi,

I am trying to create a new application to work with my SQL server database from my Access 2007 using the upsize wizard. It gave me an error saying, "The upsizing wizard cannot convert your database to a client server database because the VBA project is password protected". I am aware that in this type of situation I have to link SQL Server tables to the current application instead of trying and create a new application.

Anyone has a different solution to this problem, please help.

Thanks
Jan 10 '08 #1
Share this Question
Share on Google+
1 Reply


Dököll
Expert 100+
P: 2,364
Hi,

I am trying to create a new application to work with my SQL server database from my Access 2007 using the upsize wizard. It gave me an error saying, "The upsizing wizard cannot convert your database to a client server database because the VBA project is password protected". I am aware that in this type of situation I have to link SQL Server tables to the current application instead of trying and create a new application.

Anyone has a different solution to this problem, please help.

Thanks
Hello, AccessHunter!

I would start from the source. If Access database is protected, why not unprotect it. This is a quick and dirty way of handling it perhaps there are other ways, but would you mind trying that?

Also, couldn't Access talk to your SQL Server? Bare in mind I am new to this, you may have good reason to want to convert, surely possible, just offering options:-)
Jan 11 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.