Results 1 to 3 of 3

Working Directly With SQL Server Linked Tables/Code Not Working

  1. #1
    VSCurtis is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Dec 2014
    Posts
    64

    Working Directly With SQL Server Linked Tables/Code Not Working

    Hi Guys,



    I'd like to get your opinions on something. I have had to resort to working directly with my SQL Server database instead of using linked tables in Access. I'm now designing a VB.Net form to replace my Access form. My question is this, I have a collection of code stored in an Access module. Some of these subs and functions are stand-alones that I execute on the fly and others are used at various points by my form. This code will also be used in the VB.Net form as well. I am wondering what you think would be the best way to incorporate this collection of code into my project. I was actually considering trying to store some of the code in the database as stored procedures and UDFs like my Key Gen and Parse Word functions as well as writing simple stored procedures for Add Update and Delete. I have also considered writing a basic DAL for my form. What are your thoughts?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    5,200
    It sounds over-complicated. Why cant you link the SQL tables in, and run normal access forms?
    This was the intent for Access anyway. Fast development, No muss, no fuss.

  3. #3
    VSCurtis is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Dec 2014
    Posts
    64
    I'm pushing the size limit of Access 1.8 GB+ and I still have lots of data to enter.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Automatic authentication for linked tables not working
    By basabnanda in forum SharePoint
    Replies: 3
    Last Post: 09-03-2015, 05:22 PM
  2. Replies: 2
    Last Post: 04-15-2014, 09:03 PM
  3. Replies: 4
    Last Post: 11-22-2013, 10:20 AM
  4. Cannot Connect To SQL Server Using Working DSN
    By mes5464 in forum SQL Server
    Replies: 4
    Last Post: 04-03-2013, 11:08 AM
  5. Query not working with Directly pasted Tables
    By GAccess in forum Queries
    Replies: 3
    Last Post: 06-25-2012, 08:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums