Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 18th, 2007, 01:27 PM
Authorized User
Join Date: Aug 2003
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default don't know where to start

Hi all.

I am trying to figure out an access database that's written in vb.

My plan is to convert the tables into a sql server database and continue to use the front end out of access. There is one db that is named master_tables. This was converted to sqlserver db. There are a few other access interface db's, which contain the vb forms and modules, that link back to this master_tables db.

I'm running into an error that upon opening of one of the interface db's cannot find the backend data file(sqlserver). Does anyone know if you can have an interface db, linked to another master db, which tables are in sql server?

I'm also trying to figure how the vb modules and forms are written,(partially in french language), and I don't understand how the database starts. I know in access if you create an 'autoexec' macro whatever is in there will start first. What should I look for on the module side?

Thanks in advance.

Old October 18th, 2007, 02:17 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

Yikes. Maybe you want to rebuild this from the ground up. =)

If the tables are meant to be linked, you will need to install a DSN for the server they will be linking to. You will need to know the SQL Server name, the database name, whether you are using Windows or SQL Server authentication, and you will need crednetials on the SQL Server.

Once you do that, you can link the tables by clicking on the Tables object, then select Insert > Table > Link Table, and follow the wizard.

Once it is connected, then be sure to rename the table to its old name, or the code won't work.

Also, the code may not work if the data types are wrong and there are business rules trying to insert a different data type into the tables.

If there is any code that will run to access the tables using DAO, that will need to be converted to ADO since DAO won't work even with linked SQL Server tables.

As far as the start up options, those are usually controlled with the Tools > Start Up utility. I don't know of anyone who runs macros (or ever has for that matter) although I am sure many people do, so they would help with the autoexec issues.

As to the French language code, I am not sure how to help there. Sounds like you're reverse engineering something. Maybe you can get the requirements and dev from scratch. That might be easier if the application is not huge. I don't think the Upsizing wizard would be much help here (Tools > Database Utilities > Upsizing Wizard I think).

Did any of that help?


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where do I start gcjetfan General .NET 1 November 19th, 2007 01:22 PM
how to start MunishBhatia ASP.NET 3.5 Basics 3 October 1st, 2007 01:54 PM
how I start it?? italimeme JSP Basics 2 May 28th, 2007 02:07 AM
Where do I start - HELP !!!! simon4amiee VB Databases Basics 6 January 10th, 2007 05:15 PM
Don't know where to start......... Geneine Bugg BOOK: Beginning ASP 3.0 0 December 20th, 2006 12:00 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.