Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 18th, 2007, 01:27 PM
Authorized User
 
Join Date: Aug 2003
Location: Pittsburgh, PA, USA.
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.

Reply With Quote
  #2 (permalink)  
Old October 18th, 2007, 02:17 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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?



mmcdonal
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 06:44 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.